Databases Manager

Overseeing your databases is less complicated than ever before, thanks to the Control Panel user interface for MySQL and PgSQL control! Even though you may not have considerable expertise in making use of databases, it will be very easy to manage our Databases Manager.

You may create a brand new database merely by entering the username and security password or produce a database backup with just a click of the mouse. At the same time, through the Data Manager you’ll have direct access to the administrative area for every database, allowing you to instantly edit it.

Assuming you have dealt with databases, you know making a manual database back–up is not really an elementary job. In an effort to change this, we’ve created very simple tool that can back up the entire database with just a single click. The data backup file is going to be completely ready for you in less than a minute, depending upon the size of the selected database.

There aren’t any confines on exactly how many backups you can create for any chosen database.

A lot of our Linux cloud web hosting bundles deliver PgSQL support. While dropping behind MySQL with respect to level of popularity and employment, PgSQL databases are renowned for presenting the top level of safety for your web site content material. That’s the primary reason why companies like Skype and Yahoo employ PgSQL databases instead of MySQL.

When it comes to database management, PgSQL is identically effortless to use as MySQL.

We have set up InnoDB – the new default MySQL database engine on our machines. InnoDB is perfect for significant database websites that require high efficiency and scalability. Trials indicate that web sites applying InnoDB based tables achieve a 3–fold operation boost for significant joins, in comparison with those applying MyISAM tables.

InnoDB employs row–level locking in an effort to eliminate the operation problems observed at the top consumption times of the previous version of the database engine – MyISAM, which employs table–level locking.

Tracking the load produced by the databases on your active web site will let you reduce any kind of overload troubles that might slow it down and ward off website visitors. For this purpose, we have bundled a comprehensive Database Stats tool into the Control Panel. There you will find broad info on the arriving requests to your databases for every single hour, day and month.

Using the number of daily and per hour queries, you are able to find out which databases are utilized the most as well as consider procedures to enhance their load.