Databases Manager

The Databases Manager within our Control Panel comes with an effective but intuitive interface. You’ll be able to configure a whole new MySQL or PostgreSQL database simply by specifying a user name and security password. Also, you can create a backup file or alter the security password of any database with simply a click of the mouse.

From the Databases Manager you have direct access to the admin area for all your databases, so you can make hassle–free alterations if you happen to need to.

In case you have dealt with databases, you are aware that making a manual database back–up is simply not a basic task. In an effort to change this, we’ve developed very simple tool that will back up your whole database with simply one click of the mouse. The back–up file is going to be prepared for you in under a minute, with respect to the size of the selected database.

You won’t notice any confines on the amount of copies you could make for any chosen database.

Nearly all of Cheap Ass Hosting’s Linux cloud website hosting bundles provide PgSQL support. Although falling behind MySQL regarding acceptance and employment, PgSQL databases are renowned for providing the maximum level of safety for your web site content material. That’s the reason why companies such as Skype and Yahoo employ PgSQL databases instead of MySQL.

In terms of database administration, PgSQL is identically hassle–free as MySQL.

We have integrated InnoDB – the brand new standard MySQL database engine on each of our machines. InnoDB is designed for massive database sites which require high levels of efficiency and scalability. Tests have demonstrated that web sites utilizing InnoDB based tables attain a 3–fold efficiency grow for huge joins, compared to those working with MyISAM tables.

InnoDB works by using row–level locking in order to get rid of the efficiency difficulties found at the high usage times of the previous version of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load generated by the databases in your powerful web site will help you stop all kinds of overload difficulties that might slow it down and chase away visitors. For this specific purpose, we’ve bundled a detailed Database Stats tool in the Control Panel. There you can get comprehensive info on the arriving requests to your databases for every hour, day and month.

Based on the volume of day–to–day and hourly queries, it is possible to find out which databases are utilized the most and then consider measures to optimize their work.