Databases Manager

Administering your databases is easier than ever before, because of the Control Panel interface for MySQL and PgSQL administration! Assuming you do not have considerable knowledge in handling databases, you will find it simple to manage our Databases Manager.

You can make a new database just by specifying the user name and password or create a database back–up with a simple click of the mouse. In addition, through the Data Manager you will possess direct access to the administration area for every single database, allowing you to quickly modify it.

We have changed the manual database back–up creation into a very easy job. To execute this: in the Databases Manager, click on the ’clock’ icon next to the database that you would like to back up and afterwards hang on for a few seconds for the backup process to take place. With regards to the size of the database, the building of the back–up file is going to take somewhere between a couple of seconds and a minute.

You can create as many backup copies of a database as you wish. We haven’t fixed any limitations on the quantity of databases you can back up as well.

You’re going to find PgSQL support in our Linux cloud website hosting plans packages. PgSQL databases may not be as popular and commonly used as MySQL, however they supply you with the maximum level of protection for your site content. Because of this, several well–known businesses like Skype and Yahoo work with PgSQL databases. Handling PgSQL databases is as easy as MySQL, thanks to the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are provided by default within the most innovative web hosting plans. For the regular packages, they are presented as upgrades.

We’ve incorporated InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is good for substantial database sites that demand high levels of efficiency and scalability. Tests indicate that websites utilizing InnoDB based tables attain a 3–fold overall performance grow for substantial joins, compared to those applying MyISAM tables.

InnoDB uses row–level locking so as to get rid of the operation issues detected at the top usage times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Keeping tabs on the load caused by the databases for your active site makes it possible to stop all kinds of overload difficulties that might slow it down and chase away website visitors. As a result, we’ve integrated a descriptive Database Stats tool within the Control Panel. There you can find all–encompassing info on the arriving requests to your databases for each hour, day and month.

In line with the number of daily and per hour queries, you are going to be able to find out which databases are being used the most and also consider measures to enhance their work.