Databases Manager

Taking control of your databases is much simpler than ever before, thanks to the Control Panel interface for MySQL and PgSQL management! Assuming you do not have considerable expertise in making use of databases, you will find it simple to handle the Databases Manager.

You can make a brand new database by merely specifying the username and password or make a database backup with simply a click of the mouse. Additionally, through the Data Manager you will have direct access to the admin area for each individual database, so its possible to quite simply update it.

We have developed the manual database backup generation into a very easy task. To do so: in the Databases Manager, click on the ’clock’ image near the database that you intend to back up and wait for a couple of seconds for the process to take place. Depending upon the size of the database, the building of the backup file will need somewhere between a few seconds and a minute.

You may make as many back–ups of a database as you would like. We’ve not determined any restrictions for the volume of databases you can back up too.

Almost all of the Linux shared web hosting packages packages offer PgSQL support. Whilst falling behind MySQL when it comes to popularity and application, PgSQL databases are famous for providing the maximum level of stability for your website content material. That is the key reason why businesses like Skype and Yahoo employ PgSQL databases and not MySQL.

With regard to database administration, PgSQL is just as quick as MySQL.

The MySQL databases on our machines work with the latest build of the InnoDB storage engine. InnoDB was designed to guarantee the top effectiveness for websites that operate with significant amounts of data. It offers CPU efficiency that can not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, which means that you’re able to update/insert/create/alter/drop a couple of times for a single "operation" of your web app. At the same time, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.

Keeping tabs on the load caused by the databases for your busy website assists you to prevent any overload difficulties that can slow it down and chase away visitors. Therefore, we’ve bundled a descriptive Database Stats tool within the Control Panel. There you can see all–encompassing information on the incoming requests to your databases for every hour, day and month.

Depending on the number of daily and per hour queries, it will be straightforward to find out which databases are used the most and then consider steps to optimize their load.