Database Manager

The Database Manager inside our Control Panel provides a robust but simplified interface. It is easy to set up a new MySQL or PostgreSQL database by just specifying a user name and security password. Additionally, you could make a back–up file or alter the password of a database with a mouse click.

With the Database Manager you’ve got immediate access to the admin area for all your databases, which means you can make hassle–free corrections should you need to.

We have made the manual database back–up creation into a quite easy task. To execute this: in the Database Manager, click the ’clock’ image beside the database that you plan to back up and hang on for a couple of seconds for the process to take place. With respect to the size of your database, the building of a backup file is going to take between a few seconds and a minute.

You may make as many back–ups per database as you wish. We’ve not set any confines for the volume of databases you could back up either.

PgSQL databases are much less sought after as compared to the prevalent MySQL databases. On the other hand, they represent a favorite option for programmers seeking the maximum protection for their web sites and web applications. Through the intuitive Database Manager incorporated into the Durham Webs Control Panel, you can control all your PostgreSQL databases with a click of the mouse.

You’ll find PgSQL databases incorporated by default inside of the advanced Linux shared web hosting packages packages. In case you are with a standard hosting package, you can ask for PgSQL databases to be included in your hosting account as upgrades.

We have installed InnoDB – the new default MySQL database engine on all of our machines. InnoDB is ideal for huge database websites that need high functionality and scalability. Experiments indicate that websites making use of InnoDB based tables attain a 3–fold effectiveness increase for substantial joins, compared with those utilizing MyISAM tables.

InnoDB utilizes row–level locking so as to remove the performance difficulties observed at the top consumption times of the previous variant of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load generated by the databases within your busy site assists you to stop any overload issues that might slow it down and chase away website visitors. As a result, we have built–in a complete Database Stats tool straight into the Control Panel. There you shall find in–depth information about the inbound requests to your databases for every single hour, day and month.

Using the amount of daily and by the hour queries, you will be able to determine which databases are employed the most and take procedures to optimize their work.