Database Manager

Overseeing your databases now is easier than ever before, thanks to the Site Control Panel interface for MySQL and PgSQL management! Even though you may not have in depth experience in utilizing databases, you will find it easy to work with the Database Manager.

You can make a completely new database by just keying in the username and password or make a database backup with only a mouse click. Moreover, within the Data Manager you’ll have direct access to the administrative area for every database, meaning you can effortlessly alter it.

We’ve developed the manual database back–up generation into a quite easy job. To do so: in the Database Manager, click the ’clock’ image beside the database that you plan to back up and after that wait around for a few seconds for the backup process to take place. With regards to the size of the database, the generation of any backup file will require somewhere between a couple of seconds and a minute.

You can make as many back–ups of a database as you wish. We’ve not determined any confines about the quantity of databases you can back up either.

A lot of our Linux shared web hosting packages plans grant PgSQL support. While dropping behind MySQL when it comes to global recognition and utilization, PgSQL databases are famous for presenting the top level of stability for your site content material. It is the primary reason why companies such as Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

With regard to database administration, PgSQL is equally hassle–free as MySQL.

We have incorporated InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is made for substantial database web sites that require high general performance and scalability. Experiments have indicated that websites applying InnoDB based tables attain a 3–fold efficiency grow for significant joins, compared with those utilizing MyISAM tables.

InnoDB employs row–level locking in an effort to eliminate performance issues found at the top usage times of the prior version of the database engine – MyISAM, which employs table–level locking.

Checking the load caused by the databases within your powerful site makes it possible to prevent any overload problems that can slow it down and chase away site visitors. Therefore, we’ve included a in–depth Database Stats tool inside the Site Control Panel. There you can see complete information on the inbound requests to your databases for every hour, day and month.

Depending on the volume of daily and per hour queries, you are able to determine which databases are being used the most as well as consider actions to optimize their work.