Database Manager

Database management may seem like a complicated job to newbie website hosting users, nevertheless with our Database Manager, it’s in fact quite simple! To configure a brand new database, you just have to type in the username and password. Database backups are only a click away as well.People that desire to examine their databases and also change them can make use of the phpMyAdmin and phpPgAdmin tools.

We’ve transformed the manual database backup generation into a quite simple task. To do so: in the Database Manager, click the ’clock’ icon next to the database that you plan to back up and afterwards wait around for a few seconds for the process to take place. Depending upon the size of your database, the creation of a backup file will take between a couple of seconds and a minute.

You can create as many backups per database as you would like. We’ve not fixed any restrictions on the quantity of databases that you could back up either.

Nearly all of our shared web hosting bundles offer PgSQL support. Although dropping behind MySQL with regards to level of popularity and utilization, PgSQL databases are famous for delivering the greatest level of security for your site content. That’s the main reason why businesses like Skype and Yahoo rely on PgSQL databases instead of MySQL.

In relation to database administration, PgSQL is just as quick as MySQL.

We’ve installed InnoDB – the new default MySQL database engine on all our machines. InnoDB is perfect for large database sites that demand high levels of overall performance and scalability. Trials demonstrate that sites applying InnoDB based tables achieve a 3–fold functionality boost for significant joins, in comparison with those making use of MyISAM tables.

InnoDB employs row–level locking so as to eliminate the general performance problems witnessed at the top usage times of the prior release of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load accumulated by the databases on your busy web site will let you avoid all sorts of overload troubles that might slow it down and ward off visitors. For that reason, we have designed a comprehensive Database Stats tool straight into the Web Control Panel. There you can see all–encompassing info on the arriving requests to your databases for each hour, day and month.

Based on the number of daily and by the hour queries, you are able to determine which databases are employed the most and then consider steps to optimize their work.