Database Manager

Taking control of your databases is easier than before, on account of the Site Control Panel interface for MySQL and PgSQL control! Even if you do not have detailed knowledge of making use of databases, it will be simple to work with the Database Manager.

You could make a new database by just keying in the user name and password or produce a database back–up with just a mouse click. At the same time, through the Data Manager you have direct access to the admin area for every single database, to help you to quickly update it.

Through the Database Manager you can easily generate an archived copy of your database anytime you would like! This way, you will always have a data backup of your operating information if your web site gets broken into or if you mistakenly erase a database. To make a backup: click on the ’clock’ icon beside a particular database and after that wait for a few seconds for the backup process to be done.

There won’t be any confines about the quantity of databases you would be able to back up or the quantity of backup copies you can create for any database.

You’ll find PgSQL support in all of our Linux cloud hosting plans. PgSQL databases may not be as popular and commonly used as MySQL, however they provide the maximum level of stability for your site content and articles. Because of this, a number of well–known companies like Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as simple as MySQL, due to the user–friendly user interface of the Database Manager.

PgSQL databases are incorporated automatically inside the most sophisticated web hosting plans. For the basic bundles, they’re included as upgrades.

We have installed InnoDB – the brand new default MySQL database engine on all of our machines. InnoDB is great for sizeable database sites which require high general performance and scalability. Trials have revealed that sites employing InnoDB based tables reach a 3–fold efficiency increase for large joins, in contrast to those employing MyISAM tables.

InnoDB makes use of row–level locking as a way to remove the operation issues witnessed at the top usage times of the prior release of the database engine – MyISAM, which uses table–level locking.

We provide you a simple and easy way for you to keep tabs on the database utilization on your powerful websites. From the in–depth database stats user interface, that’s integrated into the Site Control Panel, it is easy to keep an eye on the load produced from your dynamic websites in real time. The delivered data will help you to analyze the database load variations each hour, daily or monthly.

It is possible to record the database load for all of your websites within the Database Stats section of the Site Control Panel. The table on–screen shows the database queries accumulated within the present month. To have a look at data for an earlier month, all you have to do is click on the back arrows situated at the top.