Databases Manager

Taking control of your databases is simpler than before, due to the Web Control Panel interface for MySQL and PgSQL administration! Provided you do not have extensive knowledge in handling databases, you will find it easy to use the Databases Manager.

You may create a whole new database merely by specifying the user name and security password or make a database backup with simply a mouse click. Additionally, with the Data Manager you have direct access to the administration area for every database, so that you can effectively revise it.

We have changed the manual database back–up generation into a quite easy activity. To execute that: in the Databases Manager, click on the ’clock’ symbol on the side of the database that you plan to back up and afterwards hang on for a few seconds for the backup process to take place. Depending on the size of your database, the creation of any backup file can take between a few seconds and a minute.

You can create as many backups per database as you wish. We’ve not fixed any limits for the volume of databases you can back up either.

PgSQL databases are less famous when compared to the prevalent MySQL databases. However, they are a favorite alternative for developers who are looking for the finest stability for their websites and web apps. Via the incredibly user–friendly Databases Manager integrated into the DM Hosting Control Panel, you can control all your PostgreSQL databases with merely a click of the mouse.

You’re going to find PgSQL databases included automatically with the advanced shared hosting plans packages. In case you are using a standard hosting package, you’re able to ask for PgSQL databases to be included in your web hosting account as upgrades.

With DM Hosting, you will regularly find the most current release of MySQL as well as the default MySQL storage engine – InnoDB, installed.

InnoDB is more stable when compared to the former storage engine’s version – MyISAM. It is ACID–compliant and, even more importantly – it has 100% transaction support. You’ll find, it makes use of row–level locking, in lieu of MyISAM’s table–level locking, that previously used to result in effectiveness issues at peak usage times.

Monitoring the load caused by the databases within your active site makes it possible to stop all kinds of overload issues that can slow it down and ward off visitors. For that reason, we have incorporated a in–depth Database Stats tool into the Web Control Panel. There you will find in–depth info about the arriving requests to your databases for every hour, day and month.

Depending on the amount of day–to–day and by the hour queries, it will be straightforward to find out which databases are being used the most and take measures to optimize their work.