Database Manager

Managing your databases now is easier than ever, due to the Web Hosting Control Panel user interface for MySQL and PgSQL administration! Even if you do not have considerable experience in making use of databases, it will be simple to handle the Database Manager.

You could make a new database merely by typing the username and security password or produce a database back–up with a simple mouse click. Furthermore, through the Data Manager you’ll possess direct access to the administrator area for every single database, so you’re able to quite simply alter it.

We have transformed the manual database back–up formation into a very easy task. To do this: inside of the Database Manager, click the ’clock’ icon near the database that you want to back up and wait around for a couple of seconds for the backup process to take place. With regards to the size of your database, the generation of a back–up file will need between a few seconds and a minute.

You can make as many backup copies of a database as you desire. We haven’t set any limitations for the number of databases that you could back up either.

A majority of D- M- Hosting’s Linux hosting plans deliver PgSQL support. Although dropping behind MySQL in terms of global recognition and utilization, PgSQL databases are renowned for supplying the best level of safety for your site content. That is the main reason why companies like Skype and Yahoo employ PgSQL databases as an alternative to MySQL.

With regard to database administration, PgSQL is just as simple and easy as MySQL.

With D- M- Hosting, you shall inevitably find the latest edition of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is far more secure as compared to the former storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it grants total transaction support. What’s more, it makes use of row–level locking, in lieu of MyISAM’s table–level locking, that seemed to trigger effectiveness troubles at peak usage times.

Via the thorough database stats tool included in the Web Hosting Control Panel, you will be able to keep a record of the stress produced from your dynamic web sites 24 / 7. Every overload trouble with your sites could slow the loading rates and have a negative influence over the online experience of your visitors. Thus, having information for the database work immediately, you’ll be able to solve overload issues straight away.

The database statistics user interface displays details of the amount of daily, hourly and monthly queries, which enables you to evaluate the way the load is spread over several time frames.