Databases Manager

Administering your databases is easier than ever before, because of the Online Control Panel interface for MySQL and PgSQL administration! Provided you do not have substantial knowledge in working with databases, you will find it easy to use Best Website Hosting Service’s Databases Manager.

You could make a whole new database by merely specifying the user name and password or generate a database back–up with simply a click of the mouse. Additionally, with the Data Manager you will get direct access to the management area for each individual database, which means you can immediately alter it.

If you have worked with databases, you are aware that making a manual database back–up is not a simple task. As a way to change this, we’ve developed an effortless to use tool that can back up your complete database with just one click. The backup file shall be available for you in less than a minute, based on the size of the chosen database.

There are not any restrictions on just how many back–ups you may make for any chosen database.

You are going to find PgSQL support in each of our Linux web hosting plans. PgSQL databases may not be as popular and widespread as MySQL, nonetheless they provide the maximum level of protection for your web site content. Due to this, several well–known brands like Skype and Yahoo utilize PgSQL databases. Dealing with PgSQL databases is as easy and simple as MySQL, thanks to the easy–to–use user interface of the Databases Manager.

PgSQL databases are provided automatically in the most innovative web hosting plans. For the standard plans, they’re presented as upgrades.

We have set up InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is ideal for large database sites which need high performance and scalability. Tests indicate that web sites making use of InnoDB based tables reach a 3–fold effectiveness grow for large joins, in comparison with those working with MyISAM tables.

InnoDB utilizes row–level locking in order to be able to eliminate general performance difficulties observed at the top usage times of the previous version of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load made by the databases on your powerful site makes it possible to stop all kinds of overload troubles that might slow it down and ward off visitors. For this specific purpose, we have built–in a descriptive Database Stats tool straight into the Online Control Panel. There you will find all–encompassing information about the arriving requests to your databases for each hour, day and month.

Depending on the volume of day–to–day and per hour queries, you’ll be able to find out which databases are utilized the most and then consider actions to enhance their load.