Databases Manager

The Databases Manager within our Web Site Control Panel incorporates a powerful nevertheless user–friendly interface. You are able to set up a new MySQL or PostgreSQL database by just typing in a user name and password. Moreover, you can make a backup file or alter the security password of an database with simply a click of the mouse.

With the Databases Manager you’ll possess direct access to the management area for every one of your databases, meaning you can make simple corrections in case you need to.

We have made the manual database back–up formation into a quite simple activity. To execute that: inside the Databases Manager, click the ’clock’ icon next to the database that you intend to back up and after that wait around for a few seconds for the backup process to take place. Depending upon the size of your database, the building of the back–up file will take somewhere between a few seconds and a minute.

You can create as many backup copies of a database as you want. We have not specified any limits on the volume of databases that you can back up as well.

You can find PgSQL support in all our Linux shared website hosting packages plans. PgSQL databases are not as sought after and commonly used as MySQL, however they provide the best level of stability for your site content and articles. For this reason, several widely known companies such as Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as easy as MySQL, because of the user–friendly user interface of the Databases Manager.

PgSQL databases are incorporated automatically in the most innovative web hosting plans. For the basic packages, they are featured as upgrades.

We’ve incorporated InnoDB – the new standard MySQL database engine on every one of our web servers. InnoDB is great for sizeable database sites which require high levels of functionality and scalability. Experiments have demonstrated that websites using InnoDB based tables achieve a 3–fold functionality boost for substantial joins, compared with those working with MyISAM tables.

InnoDB utilizes row–level locking so as to take away the functionality issues observed at the high usage times of the prior version of the database engine – MyISAM, which uses table–level locking.

Checking the load accumulated by the databases in your busy web site will let you stop any sort of overload difficulties that might slow it down and chase away website visitors. For this reason, we’ve bundled a in–depth Database Stats tool straight into the Web Site Control Panel. There you shall find all–encompassing information on the incoming requests to your databases for each hour, day and month.

Using the volume of daily and hourly queries, you will be able to determine which databases are employed the most and also take actions to enhance their load.