Database Manager

The Database Manager in the Control Panel contains an effective but uncomplicated user interface. You are able to configure a whole new MySQL or PostgreSQL database simply by typing a username and security password. Additionally, you can make a back–up file or change the password of a database with merely a mouse click.

Through the Database Manager you’ll possess immediate access to the administrator area for every one of your databases, allowing you to make easy corrections if you happen to have to.

We have evolved the manual database back–up creation into a very easy job. To execute this: within the Database Manager, click the ’clock’ image near the database that you plan to back up and after that hang on for a couple of seconds for the backup process to take place. Depending upon the size of the database, the generation of the backup file will take somewhere between a couple of seconds and a minute.

You can create as many backup copies per database as you would like. We haven’t determined any confines on the volume of databases you can back up as well.

A lot of our Linux web hosting packages provide PgSQL support. Whilst falling behind MySQL when it comes to global recognition and utilization, PgSQL databases are renowned for giving the highest level of safety for your website content and articles. That’s the primary reason why brands like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

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

We have incorporated InnoDB – the brand new standard MySQL database engine on every one of our machines. InnoDB is great for massive database websites which need high performance and scalability. Tests have shown that web sites using InnoDB based tables reach a 3–fold efficiency boost for large joins, in comparison with those working with MyISAM tables.

InnoDB uses row–level locking as a way to clear away the efficiency difficulties witnessed at the peak consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load made by the databases in your active website assists you to stop any sort of overload issues that might slow it down and ward off website visitors. For this specific purpose, we’ve provided a in–depth Database Stats tool inside the Control Panel. There you can see all–encompassing info about the arriving requests to your databases for each hour, day and month.

Depending on the volume of daily and by the hour queries, it is possible to find out which databases are used the most and then take actions to optimize their load.