Database Manager

Administering your databases now is easier than before, thanks to the Control Panel interface for MySQL and PgSQL control! Assuming you do not have considerable experience in utilizing databases, it will be easy to use WebDockers’s Database Manager.

You may create a whole new database just by typing the username and security password or create a database backup with simply a click of the mouse. Likewise, through the Data Manager you will have direct access to the management area for each and every database, so you can effectively revise it.

Via the Database Manager it is easy to generate an archived backup of your database when you would like! Thus, you’ll always have a backup of your dynamic information if your website gets compromised or you erroneously remove a database. To generate a backup: click the ’clock’ icon beside a certain database and afterwards wait for a few seconds for the process to be finished.

There aren’t any limits on the amount of databases you can back up or the quantity of backup copies you can create for a database.

Almost all of our shared website hosting plans feature PgSQL support. While falling behind MySQL with respect to popularity and utilization, PgSQL databases are renowned for presenting the best level of stability for your site content and articles. It is the basic reason why companies like Skype and Yahoo go with PgSQL databases as opposed to MySQL.

In terms of database administration, PgSQL is equally effortless to use as MySQL.

We’ve added InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is made for huge database web sites which need high functionality and scalability. Trials have established that websites applying InnoDB based tables achieve a 3–fold general performance boost for very big joins, in comparison with those applying MyISAM tables.

InnoDB makes use of row–level locking as a way to remove the functionality problems noticed at the peak consumption times of the earlier variant of the database engine – MyISAM, which employs table–level locking.

Monitoring the load generated by the databases for your busy website makes it possible to reduce virtually any overload issues that could slow it down and ward off visitors. For this reason, we have built in a detailed Database Stats tool inside the Control Panel. There you can find broad information on the inbound 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, it will be easy to find out what databases are employed the most and then consider procedures to enhance their load.