Databases Manager

The Databases Manager within our Web Hosting Control Panel contains a powerful nevertheless easy to navigate user interface. It is easy to set up a new MySQL or PostgreSQL database by simply typing in a user name and password. What’s more, you may create a backup file or alter the security password of your database with just a click of the mouse.

With the Databases Manager you have direct access to the administration area for every one of your databases, so you can make easy adjustments when you need to.

Via the Databases Manager you can generate an archived duplicate of your database whenever you need! For this reason, you’ll always have a back–up of your dynamic information in the event your website gets hacked or you mistakenly remove a database. To make a back–up: click the ’clock’ icon on the side of a given database and afterwards just wait for a couple of seconds for the backup process to be carried out.

There aren’t any restricts for the volume of databases you would be able to back up or the number of back–ups you can make for a database.

You’re going to find PgSQL support in each of our Linux cloud web hosting packages. PgSQL databases might not be as well–known and widespread as MySQL, however they provide you with the greatest level of stability for your web site content. Due to this, several famous companies such as Skype and Yahoo apply PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, because of the incredibly user–friendly interface of the Databases Manager.

PgSQL databases are included automatically inside of the most innovative web hosting plans. For the regular plans, they’re included as upgrades.

We have set up InnoDB – the new default MySQL database engine on every one of our web servers. InnoDB is perfect for large database websites that require high efficiency and scalability. Experiments have demonstrated that sites working with InnoDB based tables attain a 3–fold overall performance grow for very large joins, as compared to those utilizing MyISAM tables.

InnoDB employs row–level locking as a way to take away the overall performance problems observed at the maximum consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load caused by the databases within your active website makes it possible to reduce virtually any overload difficulties that can slow it down and ward off website visitors. For that reason, we have provided a thorough Database Stats tool inside the Web Hosting Control Panel. There you will find complete info on the incoming requests to your databases for each and every hour, day and month.

In line with the amount of day–to–day and by the hour queries, you will be able to find out which databases are employed the most and consider measures to optimize their load.