Databases Manager

Supervising your databases is much simpler than before, thanks to the Site Control Panel user interface for MySQL and PgSQL control! Even though you may not have considerable experience of utilizing databases, you will find it an easy task to manage our Databases Manager.

You can make a completely new database merely by typing the username and security password or create a database backup with simply a mouse click. Additionally, through the Data Manager you have direct access to the administration area for every database, so you’re able to easily alter it.

We’ve evolved the manual database backup creation into a quite simple task. To execute this: inside the Databases Manager, click the ’clock’ image beside the database that you plan to back up and then wait for a few seconds for the process to take place. With regards to the size of your database, the building of any backup file will take somewhere between a couple of seconds and a minute.

You may create as many copies of a database as you would like. We have not determined any confines on the volume of databases that you can back up too.

Nearly all of HostCover’s shared website hosting plans bundles offer PgSQL support. Although falling behind MySQL regarding level of popularity and application, PgSQL databases are renowned for delivering the highest level of protection for your website content material. That’s the reason why companies such as Skype and Yahoo rely upon PgSQL databases and not MySQL.

With respect to database administration, PgSQL is as uncomplicated as MySQL.

The MySQL databases on our web servers make use of the most up–to–date build of the InnoDB storage engine. InnoDB was created to ensure the max performance for sites that deal with huge amounts of data. It supplies CPU efficiency that could not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides 100% transaction support, meaning that you can update/insert/create/alter/drop repeatedly for a single "operation" of your web app. In addition, it makes use of row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Keeping track of the load made by the databases within your busy site makes it possible to prevent any overload issues that might slow it down and chase away site visitors. For this purpose, we’ve bundled a thorough Database Stats tool in the Site Control Panel. There you can get detailed info on the arriving requests to your databases for each hour, day and month.

Based on the number of daily and by the hour queries, you’ll be able to determine which databases are used the most and also consider procedures to enhance their load.