Databases Manager

Supervising your databases is simpler than ever before, due to the Website Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have extensive knowledge in handling databases, you will find it effortless to manage the Databases Manager.

You could make a brand new database just by entering the username and security password or generate a database back–up with simply a click of the mouse. Furthermore, via the Data Manager you’ll get direct access to the administration area for every database, so that you can quickly edit it.

Via the Databases Manager you can easily create an archived copy of your database anytime you would like! Therefore, you will always have a backup of your active content in case your web site gets compromised or if you mistakenly delete a database. To make a backup: click the ’clock’ symbol alongside a particular database and after that wait for a couple of seconds for the backup process to be carried out.

There are no limitations on the amount of databases you can back up or the amount of backups you can make for any database.

Most of Web Hosting Review’s Linux cloud hosting bundles present PgSQL support. Whilst falling behind MySQL regarding reputation and usage, PgSQL databases are famous for giving the top level of security for your web site content. That’s the reason why businesses like Skype and Yahoo employ PgSQL databases and not MySQL.

In terms of database management, PgSQL is as uncomplicated as MySQL.

We’ve integrated InnoDB – the new default MySQL database engine on all our machines. InnoDB is perfect for substantial database websites that require high levels of effectiveness and scalability. Experiments have demonstrated that sites applying InnoDB based tables achieve a 3–fold operation increase for significant joins, as compared with those using MyISAM tables.

InnoDB works by using row–level locking in an effort to eliminate overall performance issues discovered at the maximum usage times of the earlier release of the database engine – MyISAM, which employs table–level locking.

With the detailed database stats tool integrated into the Website Control Panel, you’re going to be able to keep track of the load produced through your dynamic websites around the clock. Any overload issue with your websites could lower the loading rates and have a damaging influence over the online experience of your respective website visitors. So, by having info for the database load right away, it will be easier to mend overload difficulties without delay.

The database statistics interface displays details of the amount of daily, hourly and monthly queries, so you’re able to analyze the way the load is spread over different time frames.