Database Manager

Taking control of your databases is less complicated than ever, thanks to the Web Hosting Control Panel interface for MySQL and PgSQL management! Assuming you do not have thorough experience of making use of databases, it will be very easy to deal with the Database Manager.

You could make a new database by simply specifying the username and password or produce a database back–up with just a mouse click. Additionally, through the Data Manager you will possess direct access to the management area for every single database, so its possible to immediately alter it.

Assuming you have worked with databases, you are aware that making a manual database back–up is simply not a basic task. As a way to change this, we have developed a simple tool that will back up your complete database with merely one mouse click. The back–up file is going to be set for you in less than a minute, with regards to the size of the chosen database.

There are no limitations on just how many backup copies you can make for a chosen database.

You’ll find PgSQL support in our Linux shared web hosting services offers. PgSQL databases may not be as popular and widespread as MySQL, nonetheless they supply you with the top level of safety for your website content. Because of this, many widely known businesses like Skype and Yahoo take advantage of PgSQL databases. Handling PgSQL databases is as simple as MySQL, thanks to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are included by default inside of the most sophisticated web hosting packages. For the standard packages, they are included as upgrades.

We have integrated InnoDB – the brand new default MySQL database engine on our servers. InnoDB is designed for big database web sites which require high overall performance and scalability. Tests have established that websites working with InnoDB based tables achieve a 3–fold general performance increase for large joins, compared with those utilizing MyISAM tables.

InnoDB works by using row–level locking so as to take away the operation problems witnessed at the peak consumption times of the earlier version of the database engine – MyISAM, which uses table–level locking.

Monitoring the load caused by the databases for your dynamic site will help you stop any sort of overload troubles that could slow it down and ward off site visitors. For that reason, we have included a detailed Database Stats tool into the Web Hosting Control Panel. There you shall find complete info about the arriving requests to your databases for each hour, day and month.

In line with the quantity of daily and hourly queries, you’ll be able to determine which databases are used the most and also consider actions to enhance their work.