Database Manager

The Database Manager inside the Control Panel contains a refined nevertheless simple to operate user interface. You’re able to configure a completely new MySQL or PostgreSQL database by just typing a user name and security password. Additionally, you can make a back–up file or alter the security password of the database with only a click of the mouse.

From the Database Manager you’ll get direct access to the administrator area for all your databases, so you can make easy alterations if you happen to have to.

We have transformed the manual database back–up creation into a quite easy task. To do this: inside of the Database Manager, click the ’clock’ symbol near the database that you plan to back up and then hang on for a couple of seconds for the process to take place. With respect to the size of the database, the generation of a back–up file is going to take between a couple of seconds and a minute.

You may create as many backups per database as you wish. We have not set any limitations for the volume of databases you can back up too.

Almost all of Domain Kitty’s cloud web hosting plans bundles provide PgSQL support. Although dropping behind MySQL with respect to popularity and utilization, PgSQL databases are famous for presenting the highest level of protection for your web site content material. It is the basic reason why businesses like Skype and Yahoo rely on PgSQL databases in lieu of MySQL.

With regard to database administration, PgSQL is just as straightforward as MySQL.

The MySQL databases on Domain Kitty’s servers use the latest version of the InnoDB storage engine. InnoDB was built to ensure the highest possible performance for web sites that work with large volumes of data. It grants CPU efficiency that could not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, which means that it is easy to update/insert/create/alter/drop more than once for a single "operation" of your web application. Furthermore, it works by using row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

Keeping tabs on the load made by the databases in your active web site makes it possible to reduce all kinds of overload difficulties that can slow it down and chase away website visitors. As a result, we’ve included a detailed Database Stats tool in the Control Panel. There you will find in depth information on the incoming requests to your databases for each and every hour, day and month.

In line with the volume of day–to–day and by the hour queries, you will be able to find out what databases are used the most and also take procedures to optimize their load.