Databases Manager

Supervising your databases is simpler than ever, thanks to the Hosting Control Panel interface for MySQL and PgSQL control! Provided you do not have in depth expertise in handling databases, you will find it easy to deal with the Databases Manager.

You can make a new database merely by specifying the username and security password or produce a database backup with a simple mouse click. Also, with the Data Manager you will have direct access to the management area for every single database, so its possible to almost instantly revise it.

Assuming you have dealt with databases, you know generating a manual database backup is not really an elementary task. So as to change this, we have developed an easy to understand tool that can back up your complete database with one click of the mouse. The backup file shall be set for you in less than a minute, depending upon the size of the selected database.

There aren’t any confines on the total number of backup copies you can make for any chosen database.

PgSQL databases are significantly less popular as opposed to the popular MySQL databases. Nonetheless, they represent a favored selection for developers who seek the utmost safety for their sites and apps. Due to the easy–to–use Databases Manager built–into the Host Fidelity Control Panel, you can manage all your PostgreSQL databases with merely a click of the mouse.

You’ll find PgSQL databases bundled by default inside the top Linux shared hosting packages. In case you are with a regular hosting package, it’s possible to ask for PgSQL databases to be added in your hosting account as upgrades.

We have incorporated InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is perfect for big database web sites that need high efficiency and scalability. Experiments demonstrate that sites using InnoDB based tables achieve a 3–fold efficiency increase for massive joins, as compared with those working with MyISAM tables.

InnoDB makes use of row–level locking in order to clear away the effectiveness problems detected at the high consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

Checking the load produced by the databases within your powerful site will help you prevent any sort of overload issues that could slow it down and ward off visitors. For this purpose, we’ve incorporated a in depth Database Stats tool straight into the Hosting Control Panel. There you will find broad information about the incoming requests to your databases for each hour, day and month.

Using the quantity of day–to–day and per hour queries, you are able to determine which databases are used the most as well as take measures to optimize their load.