Databases Manager

Administering your databases is less complicated than in the past, on account of the Website Control Panel interface for MySQL and PgSQL administration! In case you do not have extensive knowledge of dealing with databases, it will be an easy task to use our Databases Manager.

You can make a whole new database merely by keying in the user name and password or make a database backup with simply a mouse click. Furthermore, within the Data Manager you will have direct access to the admin area for every single database, to help you to almost instantly modify it.

Within the Databases Manager you can easily make an archived copy of your database anytime you need! Thus, you are going to always have a backup of your dynamic information in case your website gets hacked or if you erroneously get rid of a database. To make a back–up: click on the ’clock’ image beside a given database and then wait for a few seconds for the backup process to be finalized.

There won’t be any restrictions about the volume of databases you are able to back up or the volume of backup copies you can make for a database.

Practically all of Central Target Hosting’s Linux hosting bundles provide PgSQL support. While dropping behind MySQL in terms of level of popularity and usage, PgSQL databases are renowned for supplying the highest level of security for your site content. It is the reason why brands like Skype and Yahoo employ PgSQL databases as an alternative to MySQL.

With respect to database management, PgSQL is equally simple and easy as MySQL.

The MySQL databases on Central Target Hosting’s machines use the latest version of the InnoDB storage engine. InnoDB is created to ensure the max performance for websites that process large volumes of data. It delivers CPU efficiency that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, meaning that you’re able to update/insert/create/alter/drop several times for one "operation" of your web application. Furthermore, it uses row–level locking as a substitute for MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.

Keeping tabs on the load generated by the databases for your powerful web site makes it possible to stop any sort of overload troubles that might slow it down and chase away website visitors. For that reason, we have provided a thorough Database Stats tool directly into the Website Control Panel. There you will find detailed info about the incoming requests to your databases for every single hour, day and month.

Using the quantity of day–to–day and hourly queries, it will be easier to determine which databases are used the most as well as consider steps to enhance their work.