Databases Manager

Database management might sound like a difficult job to beginner cloud hosting clients, but with the Databases Manager, it’s actually pretty simple! To create a new database, you just need to enter the username and password. Database backups are just a mouse click away as well.People who desire to explore their databases as well as revise them should use the phpMyAdmin and phpPgAdmin tools.

We’ve evolved the manual database back–up generation into a quite easy job. To execute this: inside of the Databases Manager, click on the ’clock’ symbol next to the database that you would like to back up and afterwards wait for a few seconds for the process to take place. With respect to the size of the database, the generation of any backup file will require somewhere between a couple of seconds and a minute.

You can make as many backups of a database as you desire. We have not set any restrictions about the amount of databases that you could back up as well.

A lot of Sitewarehouse’s cloud web hosting plans grant PgSQL support. Whilst dropping behind MySQL when considering global recognition and utilization, PgSQL databases are famous for providing the best level of stability for your web site content and articles. That is the main reason why brands like Skype and Yahoo employ PgSQL databases as an alternative to MySQL.

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

We have installed InnoDB – the brand new standard MySQL database engine on all our servers. InnoDB is made for big database sites that demand high effectiveness and scalability. Experiments have revealed that sites using InnoDB based tables achieve a 3–fold efficiency boost for substantial joins, as compared to those working with MyISAM tables.

InnoDB uses row–level locking in order to get rid of the performance issues witnessed at the maximum usage times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Via the thorough database statistics tool incorporated into the Site Control Panel, it’s possible to keep a record of the stress created through your dynamic websites round the clock. Any overload issue with your web sites could reduce the loading speeds and have a damaging effect on the online experience of your site visitors. Hence, having data about the database work in real time, you’ll be able to fix overload problems immediately.

The database stats user interface reveals info of the amount of daily, hourly and monthly queries, so you can analyze just how the load is allocated over several time frames.