Databases Manager

Overseeing your databases now is easier than ever, as a result of Web Hosting Control Panel user interface for MySQL and PgSQL administration! Even though you may not have substantial experience of working with databases, you will find it an easy task to work with the Databases Manager.

You may create a new database simply by keying in the user name and password or make a database backup with a simple click of the mouse. At the same time, with the Data Manager you will possess direct access to the administration area for every database, which enables you to immediately modify it.

We have developed the manual database backup generation into a quite simple job. To execute this: inside the Databases Manager, click on the ’clock’ image on the side of the database that you want to back up and then wait around for a couple of seconds for the process to take place. Depending upon the size of the database, the creation of the back–up file is going to take somewhere between a couple of seconds and a minute.

You may make as many copies of a database as you would like. We’ve not set any limits on the amount of databases you can back up either.

You can find PgSQL support in every one of our Linux cloud hosting offers. PgSQL databases may not be as well–known and widely used as MySQL, nonetheless they provide the greatest level of security for your web site content. For this reason, several popular businesses like Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as elementary as MySQL, because of the user–friendly user interface of the Databases Manager.

PgSQL databases are provided automatically in the most sophisticated web hosting packages. For the basic packages, they’re featured as upgrades.

We’ve set up InnoDB – the new default MySQL database engine on our servers. InnoDB is good for large database sites which need high overall performance and scalability. Experiments have indicated that websites using InnoDB based tables attain a 3–fold operation grow for significant joins, in comparison with those using MyISAM tables.

InnoDB utilizes row–level locking as a way to eliminate the functionality difficulties observed at the peak consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

We provide you a quick option to monitor the database usage of your active websites. From your in–depth database statistics user interface, that is built–into the Web Hosting Control Panel, you can easily track the load generated through your active web sites in real time. The presented info will help you to evaluate the database load variations by the hour, per day or per month.

It is easy to monitor the database load for your websites from the Database Stats section of the Web Hosting Control Panel. The table on–screen shows the database lookups generated within the present month. To look at info for a previous month, simply click on the back arrows located at the top.