Databases Manager

The Databases Manager within our Online Control Panel comes with a refined but still convenient user interface. You’re able to configure a brand new MySQL or PostgreSQL database by just specifying a user name and security password. What’s more, you could make a backup file or customize the security password of your database with merely a click of the mouse.

Within the Databases Manager you will get direct access to the administrator area for every one of your databases, so you can make quick modifications should you need to.

Through the Databases Manager you can produce an archived duplicate of your database whenever you would like! This way, you are going to always have a data backup of your operating information in the event your site gets hacked or if you incorrectly erase a database. To produce a backup: click the ’clock’ image next to a certain database and after that wait for a few seconds for the backup process to be performed.

There aren’t any restricts on the number of databases you would be able to back up or the number of backups you can make for any database.

You’re going to find PgSQL support in our cloud hosting offers. PgSQL databases aren’t as well–known and commonly used as MySQL, nevertheless they offer the greatest level of security for your web site content and articles. Therefore, many popular companies such as Skype and Yahoo make use of PgSQL databases. Managing PgSQL databases is as elementary as MySQL, thanks to the incredibly user–friendly interface of the Databases Manager.

PgSQL databases are incorporated by default inside the most innovative web hosting bundles. For the standard bundles, they’re suggested as upgrades.

The MySQL databases on achemahost.com’s machines employ the most up–to–date build of the InnoDB storage engine. InnoDB is meant to ensure the highest possible efficiency for sites that operate with substantial volumes of data. It provides CPU performance that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, which means you’ll be able to update/insert/create/alter/drop several times for a single "operation" of your web application. Furthermore, it takes advantage of row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.

Through the complete database statistics tool integrated into the Online Control Panel, it’s possible to keep tabs of the load created from your active sites 24 hour a day. Every overload problem with your websites could lower the loading speeds and have a damaging influence over the overall experience of your website visitors. Hence, by having information for the database load in real time, it will be easier to mend overload problems as quickly as possible.

The database data user interface shows info of the amount of daily, hourly and monthly lookups, allowing you to review how the load is spread over several time periods.