Databases Manager

The Databases Manager inside our Hosting Control Panel has a powerful nevertheless user friendly interface. You can configure a completely new MySQL or PostgreSQL database by just typing in a user name and security password. What’s more, you can make a backup file or customize the password of an database with merely a mouse click.

Via the Databases Manager you have direct access to the management area for all of your databases, so that you can make quick corrections if you happen to have to.

Via the Databases Manager you are able to produce an archived copy of your database when you desire! Therefore, you’ll always have a back–up of your dynamic information if your site gets broken into or you mistakenly eliminate a database. To generate a backup: click on the ’clock’ image next to any database and then just wait for a couple of seconds for the process to be executed.

There won’t be any limits on the volume of databases you are able to back up or the quantity of backup copies you may make for a database.

PgSQL databases are much less famous as opposed to the standard MySQL databases. Even so, they’re a preferred selection for web developers who are looking for the finest security for their websites and applications. Because of the intuitive Databases Manager built into the Diversity Hosting Services Control Panel, you can administer your PostgreSQL databases with merely a click of the mouse.

Yow will discover PgSQL databases included automatically with the best Linux shared website hosting services packages. If you are with a standard hosting package, it is possible to request PgSQL databases to be included in your hosting account as upgrades.

The MySQL databases on Diversity Hosting Services’s web servers make use of the most up–to–date release of the InnoDB storage engine. InnoDB has been built to ensure the highest possible effectiveness for sites that operate with large amounts of data. It provides CPU performance that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means you can update/insert/create/alter/drop many times for one "operation" of your web application. Also, it makes use of row–level locking and not MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Keeping track of the load generated by the databases for your powerful web site will help you stop any overload difficulties that might slow it down and ward off site visitors. For this purpose, we’ve included a thorough Database Stats tool directly into the Hosting Control Panel. There you can find broad information regarding the inbound requests to your databases for every hour, day and month.

Using the number of day–to–day and per hour queries, you are able to find out which databases are employed the most and then take measures to enhance their work.