Databases Manager

Administering your databases is less complicated than ever, as a result of Online Control Panel interface for MySQL and PgSQL control! In case you do not have detailed knowledge in making use of databases, you will find it an easy task to handle our Databases Manager.

You may create a completely new database simply by keying in the user name and password or make a database back–up with only a click of the mouse. Likewise, with the Data Manager you will get direct access to the admin area for each database, so that you can quite easily edit it.

Provided you have dealt with databases, you know creating a manual database backup is just not an elementary task. In an effort to change this, we have developed an effortless to use tool that will back up your entire database with one click of the mouse. The back–up file will be all set for you in less than a minute, depending on the size of the chosen database.

There won’t be any restrictions on the number of backup copies you can make for any chosen database.

You are going to find PgSQL support in all of our Linux cloud website hosting packages. PgSQL databases might not be as sought after and frequently used as MySQL, but they give the highest possible level of safety for your website content and articles. Because of this, a number of widely known brands like Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, as a result of the intuitive interface of the Databases Manager.

PgSQL databases are included by default inside of the most advanced web hosting packages. For the basic plans, they are offered as upgrades.

We have added InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is made for large database web sites which require high levels of functionality and scalability. Trials demonstrate that web sites using InnoDB based tables reach a 3–fold general performance increase for huge joins, as compared with those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking as a way to remove the overall performance problems spotted at the high consumption times of the earlier variant of the database engine – MyISAM, which employs table–level locking.

Tracking the load caused by the databases within your busy website makes it possible to stop any kind of overload issues that could slow it down and chase away visitors. For that reason, we’ve bundled a detailed Database Stats tool into the Online Control Panel. There you can see complete info on the arriving requests to your databases for each and every hour, day and month.

Based on the volume of day–to–day and per hour queries, it will be straightforward to determine which databases are used the most and consider procedures to optimize their load.