Database Manager

Supervising your databases is much easier than before, because of the Hosting Control Panel interface for MySQL and PgSQL control! Even though you may not have extensive knowledge in making use of databases, it will be an easy task to handle our Database Manager.

You could make a completely new database merely by specifying the user name and password or generate a database back–up with simply a mouse click. Also, from the Data Manager you’ll possess direct access to the administrative area for each database, to help you to effectively update it.

In case you have dealt with databases, you know creating a manual database back–up is simply not a basic job. So as to change this, we have created very simple tool that will back up the entire database with just one click of the mouse. The data backup file shall be ready for you in under a minute, depending upon the size of the selected database.

There are not any restrictions on the total number of backup copies you can create for any specific database.

PgSQL databases are much less common when compared to the prevalent MySQL databases. Then again, they represent a preferred alternative for web developers who are looking for the maximum protection for their websites and web applications. Thanks to the intuitive Database Manager incorporated into the DigiHostPro Control Panel, you can manage all your PostgreSQL databases with merely a mouse click.

You are going to find PgSQL databases incorporated by default with the best shared web hosting packages. If you are using a regular hosting package, it’s possible to ask for PgSQL databases to be added in your cloud hosting account as upgrades.

We’ve installed InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is good for big database web sites that demand high overall performance and scalability. Tests have revealed that web sites using InnoDB based tables reach a 3–fold effectiveness increase for very big joins, compared with those applying MyISAM tables.

InnoDB works by using row–level locking in an effort to get rid of the effectiveness issues witnessed at the peak usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

Tracking the load caused by the databases in your active website assists you to reduce virtually any overload problems that might slow it down and chase away visitors. For that reason, we’ve included a descriptive Database Stats tool in the Hosting Control Panel. There you can find broad info on the arriving requests to your databases for each and every hour, day and month.

Using the quantity of day–to–day and by the hour queries, it’s possible to find out which databases are employed the most and then consider steps to enhance their work.