Database Manager

Database management may appear like a difficult job to unskilled web hosting clients, however with our Database Manager, it’s actually relatively easy! To make a completely new database, you just need to provide your username and password. Database backups are simply a click away also.Those who need to examine their databases as well as modify them should use the phpMyAdmin and phpPgAdmin tools.

We have changed the manual database backup creation into a quite simple job. To do so: inside of the Database Manager, click the ’clock’ icon beside the database that you intend to back up and after that wait around for a couple of seconds for the process to take place. Depending upon the size of your database, the creation of a backup file will take between a couple of seconds and a minute.

You may make as many backup copies per database as you would like. We haven’t fixed any limitations on the number of databases that you can back up too.

Practically all of the Linux cloud hosting bundles present PgSQL support. Whilst dropping behind MySQL in terms of acceptance and utilization, PgSQL databases are renowned for giving the highest level of stability for your site content and articles. That’s the key reason why brands like Skype and Yahoo go with PgSQL databases as opposed to MySQL.

When considering database administration, PgSQL is identically quick as MySQL.

We’ve integrated InnoDB – the new default MySQL database engine on each of our machines. InnoDB is designed for significant database web sites that need high levels of functionality and scalability. Tests have revealed that web sites employing InnoDB based tables attain a 3–fold overall performance boost for massive joins, when compared with those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking so as to take away the overall performance issues spotted at the high usage times of the prior version of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load generated by the databases in your dynamic website will help you stop all overload problems that can slow it down and chase away visitors. For this reason, we have incorporated a thorough Database Stats tool into the Website Control Panel. There you can find comprehensive information regarding the incoming requests to your databases for each and every hour, day and month.

Using the number of day–to–day and by the hour queries, it will be easier to determine which databases are being used the most and then take steps to optimize their work.