Databases Manager

The Databases Manager in the Web Control Panel includes a powerful but still user–friendly and uncomplicated user interface. It’s possible to configure a brand new MySQL or PostgreSQL database by just typing a username and password. Additionally, you can create a backup file or modify the password of any database with simply a click of the mouse.

With the Databases Manager you’ve got immediate access to the administrative area for every one of your databases, meaning you can make easy corrections if you ever have to.

In case you have worked with databases, you already know that making a manual database back–up is just not a basic job. In order to change this, we’ve developed an easy to understand tool that can back up your whole database with merely one mouse click. The back–up file shall be ready for you in under a minute, with respect to the size of the selected database.

You won’t notice any limitations on the actual number of backups you can create for any specific database.

Practically all of our Linux cloud hosting plans grant PgSQL support. Whilst dropping behind MySQL with respect to acceptance and application, PgSQL databases are renowned for presenting the greatest level of stability for your site content. This is the main reason why companies such as Skype and Yahoo use PgSQL databases as opposed to MySQL.

In relation to database administration, PgSQL is identically easy to understand as MySQL.

We’ve set up InnoDB – the new default MySQL database engine on all our machines. InnoDB is great for substantial database sites that need high performance and scalability. Experiments have established that websites employing InnoDB based tables attain a 3–fold operation grow for huge joins, compared to those utilizing MyISAM tables.

InnoDB uses row–level locking as a way to get rid of the overall performance difficulties observed at the maximum usage times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load caused by the databases on your active web site assists you to avoid any sort of overload problems that can slow it down and chase away website visitors. As a result, we’ve provided a detailed Database Stats tool into the Web Control Panel. There you will find broad information regarding the inbound requests to your databases for every hour, day and month.

Depending on the volume of day–to–day and per hour queries, you are going to be able to determine which databases are employed the most and then take actions to enhance their work.