Databases Manager

Managing your databases is simpler than before, due to the Site Control Panel interface for MySQL and PgSQL management! Even though you may not have thorough experience in dealing with databases, you will find it effortless to deal with the Databases Manager.

You may create a brand new database by just typing the username and password or generate a database back–up with simply a mouse click. In addition, from the Data Manager you have direct access to the management area for each and every database, so you’re able to conveniently modify it.

Provided you have worked with databases, you are aware that making a manual database back–up isn’t a simple job. So as to change this, we’ve created very simple tool that can back up your whole database with simply a single click of the mouse. The backup file shall be all set for you in under a minute, depending on the size of the selected database.

There are no limits on the amount of back–ups you may make for any particular database.

Nearly all of the Linux cloud web hosting plans offer PgSQL support. While falling behind MySQL with regard to level of popularity and usage, PgSQL databases are renowned for supplying the best level of stability for your website content. That is the basic reason why brands like Skype and Yahoo rely on PgSQL databases rather than MySQL.

When considering database management, PgSQL is as hassle–free as MySQL.

The MySQL databases on our servers make use of the latest release of the InnoDB storage engine. InnoDB was created to guarantee the highest possible functionality for websites that operate with huge amounts of data. It grants CPU effectiveness that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers 100% transaction support, meaning it’s possible to update/insert/create/alter/drop more than once for one "operation" of your app. Moreover, it uses row–level locking as an alternative for MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

From your broad database statistics tool integrated into the Site Control Panel, it will be possible to keep a record of the stress generated through your busy websites 24 x 365. Any overload issue with your web sites could slow the loading rates and have a damaging effect on the online experience of your respective visitors. Therefore, by having info for the database load in real time, it will be easy to fix overload troubles quickly.

The database statistics user interface shows info of the amount of daily, hourly and monthly lookups, so you can evaluate just how the load is allocated over different time frames.