Databases Manager

Managing your databases is much easier than in the past, due to the Online Control Panel user interface for MySQL and PgSQL control! Provided you do not have in depth expertise in handling databases, you will find it an easy task to handle Karn Hosting’s Databases Manager.

You can create a completely new database by just keying in the user name and password or produce a database backup with only a mouse click. Moreover, through the Data Manager you’ll get direct access to the administration area for each database, so you’re able to easily manage it.

Via the Databases Manager it’s possible to produce an archived backup of your database anytime you need! That way, you will always have a backup of your dynamic content material in case your website gets broken into or you incorrectly get rid of a database. To make a backup: click on the ’clock’ icon next to any database and after that wait for a couple of seconds for the process to be performed.

There are not any limits for the volume of databases you are able to back up or the number of backups you can create for a database.

PgSQL databases are significantly less sought after as compared to the widespread MySQL databases. Even so, they represent a preferred choice for web developers who are looking for the utmost security for their web sites and applications. Because of the easy–to–use Databases Manager built into the Karn Hosting Control Panel, you can control all your PostgreSQL databases with just a click of the mouse.

You can discover PgSQL databases bundled automatically in the best cloud hosting plans packages. If you are using a standard hosting package, it’s possible to request PgSQL databases to be included in your account as upgrades.

We have installed InnoDB – the new standard MySQL database engine on all our machines. InnoDB is good for significant database websites which require high levels of general performance and scalability. Experiments have revealed that web sites working with InnoDB based tables reach a 3–fold effectiveness increase for massive joins, compared to those using MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to eliminate functionality problems found at the high usage times of the earlier version of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load caused by the databases in your dynamic web site will help you avoid any kind of overload difficulties that could slow it down and chase away site visitors. For this reason, we have incorporated a in–depth Database Stats tool into your Online Control Panel. There you can get all–encompassing info about the arriving requests to your databases for every single hour, day and month.

Depending on the number of day–to–day and per hour queries, it will be easy to find out what databases are being used the most and consider measures to enhance their load.