Database Manager

The Database Manager within our Site Control Panel features a robust yet user–friendly interface. It’s possible to configure a brand new MySQL or PostgreSQL database by just typing in a user name and security password. Furthermore, you could make a back–up file or modify the security password of an database with a click of the mouse.

Within the Database Manager you’ll have direct access to the management area for every one of your databases, which enables you to make simple and easy corrections when you have to.

Provided you have dealt with databases, you know generating a manual database back–up is just not a simple task. In an effort to change this, we have made a simple tool that can back up the entire database with simply a single mouse click. The backup file shall be available for you in under a minute, with respect to the size of the chosen database.

There are no limitations on exactly how many back–ups you can make for any specific database.

PgSQL databases are significantly less common when compared to the well–known MySQL databases. Nonetheless, they represent a favored option for designers who seek the finest stability for their websites and web applications. Due to the user–friendly Database Manager included in the Reseller Hosting Center Control Panel, you can control all your PostgreSQL databases with simply a click of the mouse.

You’re going to find PgSQL databases incorporated by default in the best cloud plans packages. If you are using a regular hosting package, it’s possible to ask for PgSQL databases to be added to your hosting account as upgrades.

With Reseller Hosting Center, you will consistently find the most current edition of MySQL and the default MySQL storage engine – InnoDB, installed.

InnoDB is a lot more stable when compared to the old storage engine’s edition – MyISAM. It’s ACID–compliant and, best of all – it has full transaction support. It also works by using row–level locking, instead of MyISAM’s table–level locking, that seemed to cause efficiency troubles at peak usage occasions.

Keeping tabs on the load made by the databases on your active website assists you to prevent all kinds of overload troubles that might slow it down and ward off visitors. For this purpose, we have built in a descriptive Database Stats tool inside the Site Control Panel. There you can see comprehensive info about the inbound requests to your databases for each hour, day and month.

Based on the quantity of daily and by the hour queries, you are able to find out what databases are employed the most as well as take measures to enhance their load.