Databases Manager

Managing your databases is much simpler than ever, because of the Web Hosting Control Panel user interface for MySQL and PgSQL management! Assuming you do not have in depth knowledge of managing databases, it will be effortless to handle our Databases Manager.

You can make a brand new database simply by specifying the user name and password or make a database backup with a click of the mouse. In addition, from the Data Manager you’ll possess direct access to the administrator area for each database, allowing you to quite easily edit it.

We’ve transformed the manual database backup formation into a quite simple job. To execute this: inside of the Databases Manager, click the ’clock’ image beside the database that you plan to back up and afterwards wait for a few seconds for the backup process to take place. With regards to the size of the database, the building of a back–up file will require between a couple of seconds and a minute.

You can make as many back–ups of a database as you want. We have not determined any limitations for the volume of databases that you could back up too.

The majority of ERC Hosting’s cloud service plans present PgSQL support. Although falling behind MySQL regarding reputation and usage, PgSQL databases are famous for presenting the best level of stability for your website content. This is the key reason why brands like Skype and Yahoo use PgSQL databases in lieu of MySQL.

When considering database management, PgSQL is equally simple as MySQL.

We have added InnoDB – the new default MySQL database engine on all our machines. InnoDB is ideal for significant database sites that demand high levels of effectiveness and scalability. Experiments have established that websites applying InnoDB based tables attain a 3–fold overall performance grow for very large joins, in comparison with those working with MyISAM tables.

InnoDB employs row–level locking as a way to eliminate the general performance issues detected at the peak consumption times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

Via the thorough database statistics tool built into the Web Hosting Control Panel, you are going to be able to keep a record of the load produced through your dynamic sites 24 / 7. Every overload issue with your web sites can slow the loading rates and have a bad impact on the overall impression of your respective visitors. Which means that, by having details for the database work immediately, you are able to eliminate overload problems right away.

The database statistics interface reveals data of the volume of daily, hourly and monthly lookups, allowing you to review how the load is spread over different time periods.