Databases Manager

Database management might sound like a complicated job to unskilled cloud hosting clients, but with our Databases Manager, it’s actually pretty simple! To set up a brand new database, you just ought to provide your username and password. Database back–ups are just a mouse click away also.People who want to look into their databases and edit them can make use of the phpMyAdmin and phpPgAdmin tools.

Provided you have dealt with databases, you know that making a manual database back–up is simply not an elementary job. As a way to change this, we’ve created an effortless to use tool that will back up your complete database with one mouse click. The data backup file is going to be ready for you in under a minute, depending upon the size of the selected database.

There are no limits on the total number of back–ups you could make for a selected database.

A majority of SynNetHost’s shared web hosting plans packages provide PgSQL support. Although dropping behind MySQL when it comes to reputation and employment, PgSQL databases are renowned for providing the maximum level of protection for your web site content and articles. This is the reason why brands like Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.

With regards to database administration, PgSQL is identically straightforward as MySQL.

We have installed InnoDB – the new default MySQL database engine on each of our servers. InnoDB is designed for substantial database web sites that demand high overall performance and scalability. Trials have shown that web sites employing InnoDB based tables achieve a 3–fold general performance grow for huge joins, as compared with those making use of MyISAM tables.

InnoDB makes use of row–level locking so as to eliminate the general performance problems spotted at the high usage times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load produced by the databases on your powerful web site will let you reduce any sort of overload troubles that can slow it down and chase away site visitors. For this purpose, we’ve included a descriptive Database Stats tool inside the Web Hosting Control Panel. There you can find broad info about the incoming requests to your databases for every hour, day and month.

In line with the volume of daily and hourly queries, it is possible to find out which databases are used the most and take measures to enhance their work.