Databases Manager

Taking control of your databases is much simpler than before, as a result of Control Panel user interface for MySQL and PgSQL management! Even if you do not have extensive experience of dealing with databases, you will find it simple to manage our Databases Manager.

You can create a new database merely by typing the user name and password or produce a database backup with merely a click of the mouse. Furthermore, within the Data Manager you’ll possess direct access to the administrative area for each database, which means you can quite simply update it.

We have evolved the manual database backup formation into a simple activity. To execute that: inside of the Databases Manager, click the ’clock’ symbol on the side of the database that you would like to back up and after that wait around for a few seconds for the backup process to take place. Depending upon the size of your database, the creation of any backup file can take between a few seconds and a minute.

You may create as many copies per database as you desire. We’ve not determined any limits about the amount of databases that you could back up either.

You can find PgSQL support in our hosting offers. PgSQL databases aren’t as sought after and commonly used as MySQL, but they supply the best level of safety for your site content and articles. Therefore, a lot of popular companies such as Skype and Yahoo apply PgSQL databases. Handling PgSQL databases is as easy and simple as MySQL, as a result of the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are bundled automatically with the most sophisticated web hosting bundles. For the normal packages, they are suggested as upgrades.

The MySQL databases on our machines employ the most recent version of the InnoDB storage engine. InnoDB has been built to guarantee the max efficiency for web sites that process big amounts of data. It offers CPU effectiveness that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, which means you can update/insert/create/alter/drop a couple of times for one "operation" of your web application. In addition, it employs row–level locking and not MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

Checking the load caused by the databases in your powerful web site makes it possible to stop all kinds of overload issues that might slow it down and ward off website visitors. For this reason, we have incorporated a thorough Database Stats tool into the Control Panel. There you can see complete info about the inbound requests to your databases for each and every hour, day and month.

Using the number of day–to–day and hourly queries, you’ll be able to find out which databases are employed the most and also consider measures to optimize their load.