Databases Manager

Supervising your databases now is easier than ever, as a result of Online Control Panel interface for MySQL and PgSQL administration! Assuming you do not have thorough knowledge in working with databases, you will find it effortless to deal with the Databases Manager.

You can create a whole new database simply by keying in the username and password or generate a database back–up with simply a mouse click. At the same time, with the Data Manager you’ll possess direct access to the management area for every database, so you can conveniently manage it.

Through the Databases Manager it’s easy to make an archived duplicate of your database whenever you would like! Therefore, you’ll always have a backup of your active content material if your website gets hacked or if you accidentally get rid of a database. To generate a back–up: click the ’clock’ image on the side of a certain database and after that wait for a few seconds for the backup process to be finalized.

There aren’t any confines on the quantity of databases you would be able to back up or the number of backups you may make for any database.

You will find PgSQL support in all our shared website hosting offers. PgSQL databases are not as sought after and commonly used as MySQL, nonetheless they provide you with the top level of stability for your website content. Because of this, several famous companies such as Skype and Yahoo apply PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, thanks to the easy–to–use user interface of the Databases Manager.

PgSQL databases are included automatically with the most advanced web hosting bundles. For the standard bundles, they’re featured as upgrades.

We’ve installed InnoDB – the new default MySQL database engine on our machines. InnoDB is good for massive database web sites that require high levels of efficiency and scalability. Trials demonstrate that web sites using InnoDB based tables achieve a 3–fold operation grow for huge joins, when compared with those working with MyISAM tables.

InnoDB takes advantage of row–level locking so as to eliminate effectiveness problems noticed at the top consumption times of the previous version of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load accumulated by the databases in your busy web site makes it possible to reduce any sort of overload troubles that can slow it down and ward off visitors. For this specific purpose, we’ve incorporated a thorough Database Stats tool directly into the Online Control Panel. There you will find in depth info on the arriving requests to your databases for each hour, day and month.

Based on the number of daily and per hour queries, it will be easy to find out what databases are being used the most as well as consider procedures to enhance their load.