Database Manager

Database management may sound like a hard task to unskilled web hosting clients, nevertheless with the Database Manager, it’s actually reasonably easy! To create a brand new database, you only need to key in your username and password. Database back–ups are a mouse click away too.People who need to look into their databases and also update them can use the phpMyAdmin and phpPgAdmin tools.

We have developed the manual database backup generation into a quite simple task. To do this: in the Database Manager, click the ’clock’ image near the database that you want to back up and afterwards wait around for a few seconds for the backup process to take place. With respect to the size of the database, the creation of any back–up file will need somewhere between a couple of seconds and a minute.

You can make as many backup copies of a database as you would like. We haven’t set any boundaries about the quantity of databases you can back up too.

Nearly all of the Linux hosting packages packages grant PgSQL support. Whilst falling behind MySQL regarding global recognition and employment, PgSQL databases are famous for giving the top level of safety for your web site content and articles. That’s the primary reason why companies such as Skype and Yahoo rely upon PgSQL databases and not MySQL.

When it comes to database management, PgSQL is just as easy to use as MySQL.

We have installed InnoDB – the new default MySQL database engine on all our machines. InnoDB is perfect for large database websites that demand high performance and scalability. Tests show that sites employing InnoDB based tables achieve a 3–fold efficiency boost for very big joins, in contrast to those making use of MyISAM tables.

InnoDB utilizes row–level locking as a way to get rid of the general performance problems spotted at the peak consumption times of the prior release of the database engine – MyISAM, which employs table–level locking.

Checking the load caused by the databases on your busy website will let you avoid any kind of overload issues that can slow it down and chase away website visitors. For that reason, we have built in a comprehensive Database Stats tool inside the Online Control Panel. There you can see extensive info about the arriving requests to your databases for every hour, day and month.

Based on the quantity of day–to–day and hourly queries, it is possible to determine which databases are employed the most as well as consider steps to optimize their load.