Databases Manager

The Databases Manager inside our Website Control Panel contains a robust but easy to navigate interface. You’re able to set up a whole new MySQL or PostgreSQL database simply by typing in a username and password. Additionally, you can create a back–up file or alter the security password of any database with only a mouse click.

From the Databases Manager you’ll possess immediate access to the admin area for every one of your databases, so you’re able to make simple and easy modifications in case you have to.

We’ve made the manual database backup formation into a very easy task. To do this: inside of the Databases Manager, click the ’clock’ symbol on the side of the database that you would like to back up and after that hang on for a few seconds for the backup process to take place. Depending on the size of the database, the generation of a back–up file can take between a few seconds and a minute.

You can create as many backups of a database as you wish. We have not specified any boundaries about the quantity of databases you can back up either.

You’ll find PgSQL support in all our hosting plans plans. PgSQL databases might not be as popular and commonly used as MySQL, however they offer the highest level of safety for your site content. Because of this, several widely known businesses like Skype and Yahoo make use of PgSQL databases. Managing PgSQL databases is as elementary as MySQL, as a result of the easy–to–use user interface of the Databases Manager.

PgSQL databases are included automatically with the most sophisticated web hosting plans. For the standard bundles, they’re presented as upgrades.

We’ve set up InnoDB – the brand new default MySQL database engine on every one of our web servers. InnoDB is made for big database web sites which need high performance and scalability. Experiments indicate that sites employing InnoDB based tables achieve a 3–fold efficiency increase for significant joins, as compared with those utilizing MyISAM tables.

InnoDB employs row–level locking as a way to eliminate the overall performance problems discovered at the high usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

Through the detailed database statistics tool included in the Website Control Panel, you are going to be able to make a record of the load created from your active web sites 24 / 7. Every single overload problem with your web sites could lower the loading speeds and have a damaging effect on the online experience of your respective site visitors. Which means that, by having data about the database work right away, it will be straightforward to fix overload troubles right away.

The database statistics user interface shows information of the volume of daily, hourly and monthly queries, allowing you to review just how the load is spread over several periods of time.