Database Manager

The Database Manager in the Control Panel incorporates a robust but still easy to use interface. It is possible to configure a completely new MySQL or PostgreSQL database simply by entering a user name and security password. What’s more, you can create a backup file or modify the security password of your database with simply a click of the mouse.

With the Database Manager you’ll get immediate access to the administrator area for each of your databases, meaning you can make simple changes if you ever have to.

We have developed the manual database back–up generation into a quite easy job. To do so: in the Database Manager, click on the ’clock’ symbol on the side of the database that you intend to back up and after that wait for a few seconds for the backup process to take place. Depending on the size of your database, the generation of the back–up file will require somewhere between a couple of seconds and a minute.

You can make as many backup copies per database as you want. We haven’t fixed any limits for the quantity of databases that you could back up too.

You are going to find PgSQL support in each of our website hosting plans bundles. PgSQL databases are not as well–known and commonly used as MySQL, however they provide the greatest level of security for your web site content and articles. For this reason, a lot of well–known companies such as Skype and Yahoo make use of PgSQL databases. Maintaining PgSQL databases is as easy as MySQL, because of the incredibly user–friendly interface of the Database Manager.

PgSQL databases are provided by default in the most sophisticated web hosting plans. For the normal bundles, they are offered as upgrades.

The MySQL databases on our servers utilize the most up–to–date version of the InnoDB storage engine. InnoDB has been designed to guarantee the optimum performance for sites that work with substantial volumes of data. It delivers CPU performance that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, which means that it is possible to update/insert/create/alter/drop more than once for a single "operation" of your app. In addition, it takes advantage of row–level locking rather than MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

We supply you a pretty simple route to observe the database consumption on your active web sites. From your descriptive database statistics interface, that is incorporated into the Control Panel, you can easily keep track of the load generated from your active sites in real time. The displayed information will help you to evaluate the database load fluctuations each hour, each day or each month.

You are able to keep an eye on the database load for all of your web sites within the Database Stats portion of the Control Panel. The table on–screen presents the database queries created in the present month. To examine info for a previous month, click on the back arrows placed at the top.