Database Manager

Managing your databases is less complicated than before, thanks to the Web Control Panel user interface for MySQL and PgSQL administration! Provided you do not have extensive knowledge of handling databases, you will find it simple to handle the Database Manager.

You can make a brand new database simply by typing the username and password or make a database backup with only a mouse click. At the same time, with the Data Manager you’ll get direct access to the administrator area for every database, allowing you to quite easily alter it.

We have developed the manual database backup generation into a quite easy task. To execute this: in the Database Manager, click on the ’clock’ image next to the database that you want to back up and then wait for a few seconds for the backup process to take place. With regards to the size of the database, the creation of any backup file is going to take between a couple of seconds and a minute.

You can make as many back–ups of a database as you would like. We haven’t fixed any confines about the number of databases you can back up either.

You’ll find PgSQL support in all of our shared hosting service offers. PgSQL databases are not as famous and commonly used as MySQL, but they supply the greatest level of protection for your web site content. Because of this, a number of well–known companies like Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as simple as MySQL, because of the user–friendly interface of the Database Manager.

PgSQL databases are bundled automatically inside the most advanced web hosting bundles. For the standard packages, they are offered as upgrades.

We have added InnoDB – the new default MySQL database engine on our machines. InnoDB is great for big database web sites that require high levels of functionality and scalability. Trials demonstrate that web sites using InnoDB based tables achieve a 3–fold overall performance increase for huge joins, compared to those making use of MyISAM tables.

InnoDB utilizes row–level locking in an effort to eliminate effectiveness difficulties spotted at the maximum usage times of the prior release of the database engine – MyISAM, which uses table–level locking.

From the in depth database statistics tool incorporated into the Web Control Panel, it is possible to keep track of the load accumulated by your dynamic sites at any hour. Any overload difficulty with your sites can slow the loading rates and have a bad influence over the online experience of your website visitors. Hence, by having info for the database load immediately, it will be easier to eliminate overload troubles without delay.

The database statistics user interface reveals info of the amount of daily, hourly and monthly lookups, so you’re able to evaluate how the load is spread over various time frames.