Databases Manager

Database management may seem like a difficult job to unskilled cloud hosting clients, nevertheless with our Databases Manager, it’s actually quite simple! To make a whole new database, you just ought to type in the username and password. Database back–ups are only a click away too.People who would like to examine their databases and then change them can use the phpMyAdmin and phpPgAdmin tools.

We have transformed the manual database back–up creation into a very easy job. To execute this: inside the Databases Manager, click on the ’clock’ symbol on the side of the database that you would like to back up and afterwards hang on for a couple of seconds for the backup process to take place. With respect to the size of the database, the generation of any back–up file is going to take somewhere between a few seconds and a minute.

You may make as many copies of a database as you wish. We haven’t fixed any limitations on the volume of databases you can back up as well.

Almost all of the Linux cloud hosting plans offer PgSQL support. Whilst falling behind MySQL with regard to level of popularity and usage, PgSQL databases are renowned for offering up the best level of stability for your site content and articles. This is the main reason why companies such as Skype and Yahoo rely on PgSQL databases instead of MySQL.

With respect to database administration, PgSQL is equally simple as MySQL.

We have installed InnoDB – the brand new standard MySQL database engine on every one of our machines. InnoDB is good for sizeable database websites which require high levels of effectiveness and scalability. Trials have demonstrated that web sites utilizing InnoDB based tables achieve a 3–fold operation grow for massive joins, as compared to those applying MyISAM tables.

InnoDB utilizes row–level locking in an effort to eliminate the operation problems witnessed at the peak consumption times of the earlier version of the database engine – MyISAM, which uses table–level locking.

Tracking the load made by the databases in your busy web site will let you prevent virtually any overload issues that can slow it down and chase away website visitors. For this specific purpose, we have designed a in–depth Database Stats tool inside the Site Control Panel. There you can find broad information on the incoming requests to your databases for every single hour, day and month.

Using the volume of day–to–day and hourly queries, you will be able to find out what databases are used the most and also take actions to optimize their work.