Databases Manager

Supervising your databases is much easier than in the past, because of the Web Control Panel interface for MySQL and PgSQL management! Provided you do not have thorough expertise in managing databases, you will find it very easy to handle the Databases Manager.

You can make a brand new database by merely keying in the username and security password or generate a database backup with merely a mouse click. Also, via the Data Manager you’ll possess direct access to the administrative area for each database, so you’re able to efficiently manage it.

From the Databases Manager you’ll be able to generate an archived backup of your database when you desire! Therefore, you’ll always have a back–up of your active content material in the event your site gets hacked or you incorrectly get rid of a database. To produce a back–up: click on the ’clock’ icon beside a particular database and then simply wait for a few seconds for the backup process to be finalized.

There aren’t any limitations about the quantity of databases you are able to back up or the amount of backups you can make for any database.

You’re going to find PgSQL support in all of our web hosting offers. PgSQL databases may not be as popular and widespread as MySQL, but they deliver the best level of safety for your site content and articles. Due to this, many famous companies like Skype and Yahoo work with PgSQL databases. Dealing with PgSQL databases is as simple and easy as MySQL, thanks to the intuitive user interface of the Databases Manager.

PgSQL databases are bundled automatically in the most advanced web hosting plans. For the normal bundles, they’re included as upgrades.

We have added InnoDB – the brand new standard MySQL database engine on all of our servers. InnoDB is good for big database web sites that require high efficiency and scalability. Trials have revealed that sites applying InnoDB based tables reach a 3–fold operation increase for huge joins, in comparison to those applying MyISAM tables.

InnoDB makes use of row–level locking in order to be able to take away the efficiency problems detected at the peak usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Tracking the load accumulated by the databases for your powerful website will help you prevent all kinds of overload issues that can slow it down and ward off visitors. For this specific purpose, we have provided a detailed Database Stats tool inside the Web Control Panel. There you shall find all–inclusive information regarding the inbound requests to your databases for every single hour, day and month.

Based on the amount of day–to–day and hourly queries, you will be able to determine which databases are being used the most and also take procedures to optimize their load.