Databases Manager

The Databases Manager in the Website Control Panel comes with a robust yet convenient–to–use interface. You can easily set up a completely new MySQL or PostgreSQL database by simply entering a username and password. Moreover, you could make a back–up file or modify the password of a database with a mouse click.

Through the Databases Manager you’ll possess direct access to the administrative area for every one of your databases, which enables you to make effortless corrections if you happen to need to.

Assuming you have dealt with databases, you know generating a manual database backup is just not a basic task. In order to change this, we’ve made very simple tool that can back up your complete database with just one click of the mouse. The backup file is going to be all set for you in less than a minute, with respect to the size of the selected database.

There aren’t any restrictions on the total number of back–ups you could make for any chosen database.

You are going to find PgSQL support in each of our hosting packages packages. PgSQL databases aren’t as popular and frequently used as MySQL, nonetheless they supply the maximum level of security for your site content. Due to this, a number of popular companies such as Skype and Yahoo employ PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, on account of the intuitive interface of the Databases Manager.

PgSQL databases are bundled by default in the most innovative web hosting bundles. For the regular packages, they’re included as upgrades.

With Gun Confiscation, you’ll invariably find the most up–to–date version of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is more reliable as compared to the past storage engine’s edition – MyISAM. It’s ACID–compliant and, most importantly – it includes complete transaction support. It also employs row–level locking, in lieu of MyISAM’s table–level locking, that seemed to result in performance troubles at high usage occasions.

Keeping tabs on the load made by the databases for your dynamic site will help you prevent any kind of overload difficulties that can slow it down and chase away visitors. For this reason, we’ve bundled a comprehensive Database Stats tool into your Website Control Panel. There you can find extensive information about 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 find out which databases are used the most and then consider measures to optimize their work.