Databases Manager

The Databases Manager within our Site Control Panel includes a powerful nevertheless simplified interface. You’ll be able to configure a completely new MySQL or PostgreSQL database by just specifying a user name and security password. Moreover, you can make a backup file or customize the password of an database with simply a mouse click.

Through the Databases Manager you have immediate access to the administrative area for all of your databases, which means you can make effortless modifications in case you need to.

We’ve changed the manual database back–up generation into a quite easy task. To do this: within the Databases Manager, click on the ’clock’ symbol beside the database that you intend to back up and then hang on for a few seconds for the backup process to take place. Depending on the size of your database, the building of a back–up file will take between a couple of seconds and a minute.

You may make as many back–ups per database as you desire. We’ve not determined any limits on the volume of databases that you can back up as well.

PgSQL databases are significantly less common in comparison to the prevalent MySQL databases. However, they’re a preferred choice for programmers who are looking for the maximum security for their sites and web apps. Via the intuitive Databases Manager included in the Dunham Hosting Control Panel, you can control all of your PostgreSQL databases with a simple click of the mouse.

You’ll find PgSQL databases provided automatically inside the advanced Linux website hosting packages. In case you are with a basic hosting package, you’ll be able to request PgSQL databases to be added to your cloud hosting account as upgrades.

We have added InnoDB – the new default MySQL database engine on all of our machines. InnoDB is designed for big database sites which need high levels of efficiency and scalability. Trials have indicated that web sites applying InnoDB based tables achieve a 3–fold performance boost for large joins, compared to those working with MyISAM tables.

InnoDB works by using row–level locking so as to clear away the effectiveness problems found at the top consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

We supply you a painless route to keep track of the database usage on your busy websites. Via the in–depth database statistics interface, that is built into the Site Control Panel, it is easy to monitor the load accumulated through your dynamic sites in real time. The displayed information will assist you to evaluate the database load changes per hour, daily or monthly.

You can monitor the database load for all of your sites within the Database Stats area of the Site Control Panel. The table onscreen presents the database lookups created in the present month. To take a look at information for a previous month, all you have to do is click on the back arrows situated at the top.