Databases Manager

Administering your databases is much easier than ever, thanks to the Web Hosting Control Panel interface for MySQL and PgSQL control! In case you do not have substantial experience in making use of databases, you will find it an easy task to handle Exceleration21’s Databases Manager.

You can create a completely new database by only specifying the user name and password or create a database back–up with only a mouse click. Moreover, from the Data Manager you will have direct access to the management area for every single database, so you can immediately update it.

We have made the manual database back–up formation into a very simple task. To execute that: inside of the Databases Manager, click on the ’clock’ image near the database that you want to back up and afterwards wait around for a couple of seconds for the backup process to take place. Depending upon the size of the database, the generation of a back–up file can take between a couple of seconds and a minute.

You may create as many back–ups of a database as you wish. We haven’t determined any confines for the number of databases that you can back up too.

PgSQL databases are significantly less famous as opposed to the prevalent MySQL databases. Nonetheless, they represent a preferred selection for designers who are looking for the best stability for their websites and web apps. Due to the incredibly user–friendly Databases Manager integrated into the Exceleration21 Control Panel, you can control all of your PostgreSQL databases with simply a click of the mouse.

Yow will discover PgSQL databases incorporated by default inside of the advanced cloud hosting packages. In case you are with a basic hosting package, it is easy to ask for PgSQL databases to be added in your hosting account as upgrades.

The MySQL databases on Exceleration21’s servers make use of the most current version of the InnoDB storage engine. InnoDB was made to guarantee the highest performance for sites that work with massive volumes of data. It offers CPU effectiveness that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning that it is possible to update/insert/create/alter/drop several times for one "operation" of your web app. Additionally, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Keeping track of the load produced by the databases for your active site makes it possible to stop all overload problems that might slow it down and chase away site visitors. For this reason, we have provided a in–depth Database Stats tool directly into the Web Hosting Control Panel. There you can see complete info about the incoming requests to your databases for every single hour, day and month.

In line with the amount of daily and by the hour queries, you’re going to be able to determine which databases are employed the most and take actions to enhance their work.