Databases Manager

Supervising your databases is less complicated than ever before, on account of the Control Panel user interface for MySQL and PgSQL control! Assuming you do not have extensive knowledge of managing databases, it will be effortless to deal with Khalsa Host’s Databases Manager.

You can make a new database by merely entering the user name and security password or produce a database backup with simply a click of the mouse. Likewise, through the Data Manager you have direct access to the administrative area for every single database, which enables you to quite simply edit it.

From the Databases Manager it’s easy to create an archived duplicate of your database whenever you want! Therefore, you will always have a data backup of your operating information in the event your web site gets broken into or you erroneously delete a database. To create a back–up: click the ’clock’ symbol alongside any database and after that just wait for a few seconds for the backup process to be executed.

There won’t be any limits on the number of databases you are able to back up or the volume of backups you can make for a database.

You will find PgSQL support in all our Linux cloud hosting service bundles. PgSQL databases may not be as popular and widely used as MySQL, nonetheless they deliver the highest level of protection for your website content. Because of this, many popular brands like Skype and Yahoo implement PgSQL databases. Taking care of PgSQL databases is as easy as MySQL, thanks to the intuitive user interface of the Databases Manager.

PgSQL databases are bundled automatically in the most advanced web hosting packages. For the standard bundles, they’re included as upgrades.

With Khalsa Host, you’ll inevitably discover the most recent edition of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is a lot more dependable than the old storage engine’s edition – MyISAM. It is ACID–compliant and, most significantly – it has full transaction support. Additionally, it works by using row–level locking, instead of MyISAM’s table–level locking, that previously used to lead to performance problems at high usage periods.

Monitoring the load made by the databases on your active site will help you stop any overload difficulties that might slow it down and ward off visitors. For this reason, we have integrated a detailed Database Stats tool into your Control Panel. There you shall find all–inclusive info about the incoming requests to your databases for every single hour, day and month.

Based on the amount of daily and per hour queries, you are going to be able to determine which databases are utilized the most and consider procedures to optimize their load.