Databases Manager

The Databases Manager in the Online Control Panel comes with a refined yet convenient user interface. It is easy to configure a new MySQL or PostgreSQL database by simply typing in a username and security password. Moreover, you may create a backup file or customize the security password of an database with only a mouse click.

With the Databases Manager you will have direct access to the admin area for every one of your databases, meaning you can make simple and easy alterations if you ever need to.

Assuming you have dealt with databases, you know that generating a manual database backup is simply not a simple job. In an effort to change this, we have made a simple tool that can back up the entire database with one click of the mouse. The back–up file will be set for you in less than a minute, based on the size of the chosen database.

There aren’t any restrictions on the total number of backups you may make for a chosen database.

The majority of the Linux hosting plans deliver PgSQL support. Whilst dropping behind MySQL regarding acceptance and utilization, PgSQL databases are famous for giving the top level of stability for your site content and articles. This is the reason why companies such as Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

With regard to database management, PgSQL is just as uncomplicated as MySQL.

We have incorporated InnoDB – the new default MySQL database engine on all our servers. InnoDB is designed for substantial database sites which need high overall performance and scalability. Tests have shown that websites working with InnoDB based tables reach a 3–fold overall performance increase for massive joins, when compared to those applying MyISAM tables.

InnoDB employs row–level locking as a way to eliminate the performance issues observed at the peak consumption times of the previous release of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load accumulated by the databases in your dynamic website assists you to avoid any overload troubles that can slow it down and ward off visitors. For that reason, we’ve integrated a complete Database Stats tool in the Online Control Panel. There you can find in depth information on the inbound requests to your databases for each and every hour, day and month.

Based on the amount of daily and hourly queries, you are able to find out which databases are utilized the most and also consider actions to enhance their work.