Database Manager

Administering your databases is easier than before, thanks to the Online Control Panel interface for MySQL and PgSQL control! Even if you do not have detailed knowledge of making use of databases, it will be simple to deal with our Database Manager.

You may create a new database merely by keying in the username and security password or create a database backup with just a mouse click. Also, through the Data Manager you’ll get direct access to the administration area for every database, to help you to immediately alter it.

We have transformed the manual database backup generation into a very easy activity. To execute that: inside the Database Manager, click on the ’clock’ symbol near the database that you would like to back up and after that wait around for a few seconds for the backup process to take place. Depending on the size of the database, the generation of any backup file will need somewhere between a couple of seconds and a minute.

You can create as many backups per database as you want. We have not determined any confines for the amount of databases that you can back up too.

You can find PgSQL support in all our Linux cloud hosting plans. PgSQL databases may not be as popular and commonly used as MySQL, nonetheless they provide the greatest level of security for your site content and articles. Due to this, a number of famous businesses like Skype and Yahoo apply PgSQL databases. Taking care of PgSQL databases is as easy as MySQL, due to the incredibly user–friendly user interface of the Database Manager.

PgSQL databases are provided automatically within the most innovative web hosting plans. For the normal bundles, they’re included as upgrades.

We have added InnoDB – the new standard MySQL database engine on every one of our machines. InnoDB is good for sizeable database sites that need high levels of functionality and scalability. Trials have established that websites making use of InnoDB based tables reach a 3–fold functionality increase for big joins, as compared with those working with MyISAM tables.

InnoDB uses row–level locking in order to be able to eliminate the efficiency issues found at the maximum usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load produced by the databases for your busy web site makes it possible to avoid all overload issues that can slow it down and chase away website visitors. For this reason, we have designed a thorough Database Stats tool inside the Online Control Panel. There you can see extensive information regarding the incoming requests to your databases for every single hour, day and month.

Using the number of day–to–day and by the hour queries, it will be easy to find out which databases are utilized the most as well as consider procedures to enhance their load.