Database Manager

The Database Manager in the Online Control Panel comes with a powerful yet easy to use interface. You’ll be able to configure a new MySQL or PostgreSQL database simply by specifying a user name and password. Additionally, you can create a back–up file or change the password of any database with simply a mouse click.

From the Database Manager you have immediate access to the administrative area for all your databases, so that you can make hassle–free alterations in the event you have to.

We have designed the manual database back–up generation into a simple job. To execute that: inside of the Database Manager, click on the ’clock’ symbol on the side of the database that you want to back up and afterwards wait around for a couple of seconds for the process to take place. Depending upon the size of the database, the building of any backup file will need somewhere between a couple of seconds and a minute.

You may create as many copies per database as you desire. We have not determined any confines about the number of databases you can back up too.

PgSQL databases are significantly less common in comparison to the common MySQL databases. Having said that, they represent a favored choice for developers who seek the greatest safety for their web sites and apps. Due to the easy–to–use Database Manager built into the Duoservers.co.uk Control Panel, you can control all of your PostgreSQL databases with a simple mouse click.

You can find PgSQL databases incorporated by default inside of the advanced shared hosting packages. Assuming that you are using a regular hosting package, you are able to ask for PgSQL databases to be added in your website hosting account as upgrades.

With Duoservers.co.uk, you’ll consistently find the most current build of MySQL along with the default MySQL storage engine – InnoDB, installed.

InnoDB is far more secure than the former storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it grants 100% transaction support. In addition, it works by using row–level locking, as an alternative to MyISAM’s table–level locking, that previously used to result in efficiency troubles at peak usage times.

Through the all–encompassing database stats tool built–into the Online Control Panel, you’ll be able to keep tabs of the load accumulated through your active web sites 24 / 7. Virtually any overload trouble with your sites could slow the loading rates and have a damaging influence over the overall experience of your website visitors. Which means that, having information about the database work instantly, it is possible to solve overload issues right away.

The database statistics interface reveals information of the quantity of daily, hourly and monthly queries, in order to evaluate how the load is spread over different periods of time.