Databases Manager

The Databases Manager in our Web Hosting Control Panel boasts a robust nevertheless well designed interface. It is possible to set up a whole new MySQL or PostgreSQL database by simply specifying a user name and password. Additionally, you can make a backup file or alter the security password of any database with a click of the mouse.

Within the Databases Manager you have direct access to the management area for every one of your databases, meaning you can make hassle–free changes when you need to.

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

You can create as many backup copies per database as you want. We haven’t fixed any restrictions on the number of databases you can back up either.

Most of the Linux cloud hosting plans offer PgSQL support. Although falling behind MySQL regarding level of popularity and employment, PgSQL databases are renowned for offering up the maximum level of protection for your site content material. That is the reason why brands like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

When considering database administration, PgSQL is identically simple as MySQL.

We have incorporated InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is designed for huge database websites that need high overall performance and scalability. Experiments have shown that web sites making use of InnoDB based tables attain a 3–fold operation grow for very big joins, as compared to those making use of MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to clear away the performance difficulties witnessed at the maximum consumption times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.

Via the all–inclusive database statistics tool built into the Web Hosting Control Panel, it is possible to keep tabs of the load created through your dynamic sites twenty–four hours a day. Any overload problem with your web sites can slow the loading speeds and have a negative impact on the overall experience of your respective visitors. Thus, having info for the database load live, you’ll be able to resolve overload troubles as fast as possible.

The database data user interface displays information of the number of daily, hourly and monthly queries, so you can assess the way the load is distributed over various time frames.