Databases Manager

The Databases Manager in our Web Control Panel provides a refined but straightforward user interface. It is possible to configure a brand new MySQL or PostgreSQL database simply by specifying a user name and security password. What’s more, you can make a back–up file or alter the security password of an database with merely a mouse click.

Within the Databases Manager you’ve got direct access to the administrator area for all your databases, in order to make simple alterations when you need to.

We have developed the manual database back–up formation into a quite simple job. To do so: in the Databases Manager, click the ’clock’ symbol next to the database that you plan to back up and after that wait for a couple of seconds for the process to take place. Depending on the size of the database, the creation of any back–up file will need between a couple of seconds and a minute.

You may create as many backups per database as you desire. We have not fixed any restrictions about the quantity of databases you can back up too.

You are going to find PgSQL support in all our hosting plans offers. PgSQL databases are not as sought after and frequently used as MySQL, nonetheless they supply you with the best level of safety for your website content and articles. Therefore, several popular businesses like Skype and Yahoo take advantage of PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, thanks to the user–friendly interface of the Databases Manager.

PgSQL databases are integrated automatically with the most advanced web hosting plans. For the normal plans, they’re presented as upgrades.

The MySQL databases on our web servers make use of the most up–to–date build of the InnoDB storage engine. InnoDB has been created to ensure the highest functionality for websites that deal with significant volumes of data. It boasts CPU performance that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, which means that you are able to update/insert/create/alter/drop repeatedly for a single "operation" of your application. In addition, it utilizes row–level locking rather than MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

Keeping track of the load accumulated by the databases in your powerful web site assists you to avoid all overload issues that can slow it down and chase away visitors. For that reason, we’ve built–in a in–depth Database Stats tool directly into the Web Control Panel. There you shall find in depth info on the incoming requests to your databases for each and every hour, day and month.

Using the quantity of day–to–day and by the hour queries, you will be able to find out what databases are used the most as well as consider procedures to optimize their load.