Database Manager

The Database Manager within our Website Control Panel boasts an effective but still intuitive interface. You can easily configure a brand new MySQL or PostgreSQL database by simply typing in a username and password. Also, you can create a back–up file or customize the password of a database with only a mouse click.

Through the Database Manager you will possess immediate access to the admin area for all your databases, in order to make effortless corrections if you happen to have to.

We’ve evolved the manual database back–up formation into a quite simple activity. To execute this: inside the Database Manager, click the ’clock’ symbol beside the database that you would like to back up and afterwards wait for a few seconds for the process to take place. Depending upon the size of the database, the generation of any back–up file is going to take between a couple of seconds and a minute.

You may make as many copies of a database as you would like. We have not fixed any limitations about the volume of databases that you can back up too.

You will find PgSQL support in all our cloud web hosting plans plans. PgSQL databases are not as well–known and commonly used as MySQL, nonetheless they deliver the highest level of stability for your site content. Due to this, many famous businesses like Skype and Yahoo take advantage of PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, because of the easy–to–use user interface of the Database Manager.

PgSQL databases are integrated by default in the most innovative web hosting plans. For the basic plans, they are presented as upgrades.

The MySQL databases on our web servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB was built to guarantee the highest efficiency for sites that operate with big volumes of data. It presents CPU efficiency that can not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, so that you’ll be able to update/insert/create/alter/drop several times for a single "operation" of your app. Also, it employs row–level locking in place of MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Keeping track of the load accumulated by the databases for your active site assists you to avoid any overload troubles that could slow it down and ward off visitors. For that reason, we’ve built–in a complete Database Stats tool within the Website Control Panel. There you shall find complete info on the incoming requests to your databases for each hour, day and month.

In line with the quantity of daily and hourly queries, it will be straightforward to find out what databases are used the most and consider procedures to optimize their work.