Databases Manager

Database management may appear like a complicated job to unskilled hosting clients, but with the Databases Manager, it’s actually pretty simple! To configure a completely new database, you only have to key in the username and password. Database back–ups are simply a mouse click away on top of that.People who would like to look into their databases as well as update them may use the phpMyAdmin and phpPgAdmin tools.

We have developed the manual database backup creation into a very simple task. To do so: inside of the Databases Manager, click the ’clock’ symbol next to the database that you would like to back up and then wait around for a few seconds for the process to take place. Depending on the size of the database, the creation of any backup file is going to take between a couple of seconds and a minute.

You may create as many copies of a database as you would like. We have not determined any limitations about the volume of databases you can back up as well.

The majority of our Linux shared website hosting packages grant PgSQL support. Whilst falling behind MySQL with regards to reputation and usage, PgSQL databases are renowned for providing the best level of safety for your site content and articles. This is the reason why companies like Skype and Yahoo use PgSQL databases and not MySQL.

With respect to database management, PgSQL is equally quick as MySQL.

We’ve added InnoDB – the brand new standard MySQL database engine on all our web servers. InnoDB is perfect for substantial database websites that demand high effectiveness and scalability. Tests have revealed that websites working with InnoDB based tables achieve a 3–fold efficiency increase for big joins, compared to those using MyISAM tables.

InnoDB uses row–level locking in an effort to take away the general performance difficulties discovered at the high consumption times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load produced by the databases in your dynamic website will help you reduce virtually any overload issues that could slow it down and ward off visitors. For that reason, we’ve incorporated a complete Database Stats tool directly into the Online Control Panel. There you will find extensive information regarding the incoming requests to your databases for each and every hour, day and month.

Depending on the amount of day–to–day and by the hour queries, you will be able to find out which databases are employed the most and also consider measures to enhance their load.