Databases Manager

Administering your databases is much simpler than ever, on account of the Control Panel user interface for MySQL and PgSQL administration! Provided you do not have detailed knowledge in handling databases, it will be very easy to deal with the Databases Manager.

You may create a whole new database simply by keying in the username and password or produce a database back–up with merely a mouse click. Also, through the Data Manager you’ll have direct access to the administrative area for each database, so that you can efficiently edit it.

We have changed the manual database back–up generation into a quite easy task. To execute that: in the Databases Manager, click the ’clock’ icon beside the database that you want to back up and after that wait for a few seconds for the process to take place. Depending on the size of your database, the building of a backup file will require between a couple of seconds and a minute.

You may make as many backups of a database as you would like. We have not determined any restrictions for the amount of databases you could back up as well.

Practically all of the shared web hosting bundles offer PgSQL support. Although dropping behind MySQL with regard to level of popularity and usage, PgSQL databases are famous for offering the best level of safety for your site content and articles. That’s the main reason why companies like Skype and Yahoo go with PgSQL databases and not MySQL.

In terms of database management, PgSQL is just as hassle–free as MySQL.

The MySQL databases on our web servers use the most recent version of the InnoDB storage engine. InnoDB has been intended to ensure the maximum efficiency for web sites that process substantial amounts of data. It supplies CPU efficiency that could not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, which means that you’ll be able to update/insert/create/alter/drop several times for one "operation" of your application. Additionally, it employs row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

From your complete database stats tool built–into the Control Panel, you will be able to make a record of the load created from your dynamic websites 24 x 365. Any overload problem with your websites can lower the loading rates and have a negative effect on the online experience of your respective visitors. Thus, having info about the database work in real time, you are able to solve overload troubles promptly.

The database data user interface displays details of the number of daily, hourly and monthly lookups, so that you can examine just how the load is spread over different time frames.