Database Manager

The Database Manager in the Online Control Panel comes with a refined yet uncomplicated user interface. You’re able to set up a completely new MySQL or PostgreSQL database by simply typing a username and password. Additionally, you could make a backup file or change the password of a database with merely a click of the mouse.

Via the Database Manager you will get direct access to the administrative area for all your databases, meaning you can make hassle–free corrections in the event you need to.

Provided you have worked with databases, you are aware that creating a manual database backup is not a simple job. So as to change this, we have created a simple tool that can back up your whole database with one mouse click. The data backup file will be set for you in under a minute, depending upon the size of the chosen database.

There are not any confines on the number of backup copies you can create for a specific database.

PgSQL databases are much less widespread than the common MySQL databases. However, they represent a preferred option for web developers who are looking for the maximum stability for their web sites and applications. Thanks to the user–friendly Database Manager integrated into the Plaza Hosting Services UK Control Panel, you can manage all your PostgreSQL databases with merely a click of the mouse.

You’ll find PgSQL databases provided by default with the top web hosting plans packages. In case you are using a standard hosting package, you are able to ask for PgSQL databases to be included in your hosting account as upgrades.

The MySQL databases on Plaza Hosting Services UK’s servers work with the latest release of the InnoDB storage engine. InnoDB was meant to ensure the highest possible efficiency for websites that deal with massive volumes of data. It delivers CPU effectiveness that can not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, meaning that you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your app. Furthermore, it employs row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Plaza Hosting Services UK offers you a quick option to keep an eye on the database usage on your powerful web sites. From your thorough database stats interface, that’s built into the Online Control Panel, you’ll be able to track the load produced through your active websites in real time. The offered information will let you analyze the database load changes every hour, on a daily basis or per month.

It’s possible to record the database load for all your sites from the Database Stats section of the Online Control Panel. The table onscreen presents the database lookups generated within the present month. To look at information and facts for an earlier month, just click on the back arrows situated at the top.