Database Manager

The Database Manager inside our Web Hosting Control Panel includes an effective but still easy to navigate interface. You’re able to configure a completely new MySQL or PostgreSQL database simply by entering a user name and password. Furthermore, you can create a backup file or modify the security password of any database with simply a mouse click.

Within the Database Manager you have direct access to the management area for all your databases, meaning you can make hassle–free alterations when you have to.

We have made the manual database back–up formation into a very easy task. To execute that: inside the Database Manager, click the ’clock’ icon on the side of the database that you intend to back up and afterwards hang on for a couple of seconds for the process to take place. Depending upon the size of your database, the generation of the back–up file will need between a few seconds and a minute.

You may make as many back–ups of a database as you wish. We have not set any limits about the number of databases that you could back up too.

Nearly all of our Linux shared hosting packages offer PgSQL support. Whilst falling behind MySQL with respect to reputation and utilization, PgSQL databases are renowned for offering the best level of safety for your web site content material. This is the main reason why companies like Skype and Yahoo use PgSQL databases in lieu of MySQL.

With regards to database management, PgSQL is equally easy to use as MySQL.

We have installed InnoDB – the brand new default MySQL database engine on every one of our web servers. InnoDB is ideal for huge database sites that require high overall performance and scalability. Tests demonstrate that sites applying InnoDB based tables achieve a 3–fold operation grow for substantial joins, in comparison to those applying MyISAM tables.

InnoDB employs row–level locking so as to eliminate the effectiveness issues discovered at the peak consumption times of the previous version of the database engine – MyISAM, which uses table–level locking.

Checking the load caused by the databases within your active site will help you stop all sorts of overload troubles that could slow it down and ward off site visitors. For this specific purpose, we have integrated a detailed Database Stats tool straight into the Web Hosting Control Panel. There you can find detailed information about the arriving requests to your databases for each and every hour, day and month.

Based on the quantity of day–to–day and hourly queries, it is possible to determine which databases are used the most as well as take procedures to enhance their work.