Databases Manager

Taking control of your databases is less complicated than before, thanks to the Control Panel user interface for MySQL and PgSQL control! Assuming you do not have substantial knowledge of working with databases, you will find it easy to handle the Databases Manager.

You can create a whole new database just by specifying the username and password or generate a database backup with only a mouse click. In addition, with the Data Manager you will possess direct access to the administration area for each individual database, which means you can efficiently revise it.

Assuming you have dealt with databases, you are aware that generating a manual database backup is just not a basic job. As a way to change this, we’ve created very simple tool that can back up your whole database with just one click of the mouse. The data backup file will be all set for you in less than a minute, depending on the size of the chosen database.

You won’t notice any confines on the total number of backups you can make for a specific database.

You’ll find PgSQL support in all of our shared web hosting offers. PgSQL databases aren’t as popular and commonly used as MySQL, nevertheless they provide the highest possible level of protection for your website content and articles. Because of this, many popular companies such as Skype and Yahoo work with PgSQL databases. Handling PgSQL databases is as elementary as MySQL, as a result of the intuitive user interface of the Databases Manager.

PgSQL databases are included automatically inside the most sophisticated web hosting packages. For the standard packages, they are offered as upgrades.

We have installed InnoDB – the new default MySQL database engine on all our servers. InnoDB is perfect for massive database websites that demand high general performance and scalability. Experiments have established that web sites using InnoDB based tables achieve a 3–fold efficiency increase for huge joins, when compared with those employing MyISAM tables.

InnoDB takes advantage of row–level locking in order to clear away the functionality issues detected at the top consumption times of the prior release of the database engine – MyISAM, which uses table–level locking.

With the in depth database statistics tool built–into the Control Panel, it’s possible to keep tabs of the load generated through your busy websites twenty–four hours a day. Virtually any overload problem with your sites can lower the loading speeds and have a bad effect on the overall impression of your website visitors. Thus, having data about the database work instantly, it is also possible to resolve overload difficulties as soon as possible.

The database statistics user interface displays data of the amount of daily, hourly and monthly lookups, in order to assess the way the load is spread over various periods of time.