Databases Manager

Taking control of your databases is easier than before, due to the Web Control Panel interface for MySQL and PgSQL control! Assuming you do not have considerable expertise in making use of databases, you will find it very easy to use the Databases Manager.

You can create a brand new database merely by typing the username and password or create a database back–up with a simple click of the mouse. In addition, within the Data Manager you’ll possess direct access to the admin area for each individual database, meaning you can easily modify it.

Provided you have dealt with databases, you are aware that generating a manual database backup is not a simple job. In an effort to change this, we’ve made a simple tool that can back up the entire database with just one mouse click. The data backup file shall be available for you in under a minute, based on the size of the chosen database.

You won’t notice any restrictions on the amount of backup copies you could make for any selected database.

You’ll find PgSQL support in our Linux cloud web hosting service bundles. PgSQL databases are not as popular and widely used as MySQL, nonetheless they supply the best level of stability for your site content and articles. For this reason, a number of popular brands like Skype and Yahoo use PgSQL databases. Handling PgSQL databases is as easy and simple as MySQL, thanks to the user–friendly interface of the Databases Manager.

PgSQL databases are provided automatically within the most innovative web hosting bundles. For the standard packages, they’re presented as upgrades.

We’ve installed InnoDB – the new default MySQL database engine on each of our web servers. InnoDB is perfect for significant database web sites that need high levels of general performance and scalability. Trials have shown that sites utilizing InnoDB based tables attain a 3–fold operation boost for large joins, in contrast to those employing MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to remove the general performance problems spotted at the maximum consumption times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Checking the load caused by the databases within your powerful web site will help you stop all overload problems that could slow it down and chase away visitors. Therefore, we have bundled a thorough Database Stats tool into the Web Control Panel. There you shall find in depth information regarding the inbound requests to your databases for every single hour, day and month.

Using the quantity of daily and by the hour queries, you will be able to determine which databases are used the most and then take steps to enhance their work.