Databases Manager

The Databases Manager within our Control Panel contains a refined nevertheless simple to operate interface. You are able to configure a new MySQL or PostgreSQL database by just typing in a username and security password. Also, you could make a backup file or customize the security password of an database with merely a mouse click.

From the Databases Manager you have direct access to the administrative area for every one of your databases, in order to make simple and easy changes if you ever need to.

We’ve transformed the manual database back–up creation into a simple job. To do this: in the Databases Manager, click the ’clock’ symbol on the side of the database that you plan to back up and then hang on for a few seconds for the backup process to take place. With respect to the size of the database, the generation of any backup file will require somewhere between a couple of seconds and a minute.

You may make as many backup copies of a database as you wish. We have not set any boundaries about the volume of databases that you can back up as well.

Nearly all of Domain-Host.Biz’s Linux cloud hosting packages plans grant PgSQL support. Whilst dropping behind MySQL with respect to level of popularity and utilization, PgSQL databases are renowned for offering up the greatest level of stability for your website content material. That’s the primary reason why businesses like Skype and Yahoo use PgSQL databases as an alternative to MySQL.

With regards to database administration, PgSQL is equally hassle–free as MySQL.

With Domain-Host.Biz, you’ll inevitably discover the most up–to–date release of MySQL and the default MySQL storage engine – InnoDB, set up.

InnoDB is more secure than the old storage engine’s edition – MyISAM. It’s ACID–compliant and, even more importantly – it has complete transaction support. You’ll find, it makes use of row–level locking, in lieu of MyISAM’s table–level locking, that used to result in efficiency problems at peak usage occasions.

Keeping track of the load caused by the databases on your busy site will help you avoid any overload difficulties that might slow it down and ward off site visitors. For this purpose, we have bundled a in depth Database Stats tool into the Control Panel. There you can find all–encompassing information about the arriving requests to your databases for each and every hour, day and month.

Depending on the volume of day–to–day and hourly queries, you’ll be able to find out what databases are being used the most and also take steps to enhance their work.