Database Manager

The Database Manager in the Web Hosting Control Panel incorporates a powerful but still straightforward user interface. You’ll be able to set up a brand new MySQL or PostgreSQL database simply by entering a user name and password. Moreover, you can create a backup file or modify the security password of any database with simply a mouse click.

Within the Database Manager you will possess direct access to the administration area for all your databases, allowing you to make simple and easy corrections in the event you need to.

We have designed the manual database back–up formation into a very simple activity. To execute that: inside the Database Manager, click on the ’clock’ icon on the side of the database that you want to back up and after that hang on for a few seconds for the backup process to take place. With respect to the size of your database, the building of the back–up file can take between a few seconds and a minute.

You can make as many backups per database as you wish. We haven’t determined any limits for the volume of databases that you could back up as well.

PgSQL databases are much less common as compared to the widespread MySQL databases. Nevertheless, they represent a favorite choice for designers who seek the maximum protection for their websites and web apps. Through the incredibly user–friendly Database Manager incorporated into the VPS Dealer Control Panel, you can administer all your PostgreSQL databases with simply a mouse click.

Yow will discover PgSQL databases integrated automatically with the best shared hosting packages. If you are with a standard hosting package, you’ll be able to request PgSQL databases to be included in your web hosting account as upgrades.

The MySQL databases on VPS Dealer’s servers make use of the most current release of the InnoDB storage engine. InnoDB is created to ensure the top performance for sites that process substantial volumes of data. It offers CPU performance that can not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning that you’ll be able to update/insert/create/alter/drop many times for a single "operation" of your web app. Also, it uses row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Keeping tabs on the load caused by the databases on your powerful web site makes it possible to stop virtually any overload troubles that can slow it down and chase away visitors. For this specific purpose, we have designed a comprehensive Database Stats tool directly into the Web Hosting Control Panel. There you will find all–inclusive info about the arriving requests to your databases for every single hour, day and month.

Based on the number of daily and per hour queries, you are going to be able to determine which databases are utilized the most and then consider actions to optimize their work.