Databases Manager

Taking control of your databases is easier than ever, thanks to the Website Control Panel user interface for MySQL and PgSQL control! Even if you do not have detailed knowledge of managing databases, you will find it an easy task to use PRO2AIS’s Databases Manager.

You can make a new database simply by specifying the user name and security password or generate a database back–up with a click of the mouse. Moreover, through the Data Manager you will get direct access to the administrator area for every single database, so that you can quite simply revise it.

We have developed the manual database back–up creation into a quite easy task. To do this: inside the Databases Manager, click the ’clock’ icon beside the database that you would like to back up and after that wait around for a few seconds for the process to take place. With respect to the size of your database, the building of a back–up file can take somewhere between a couple of seconds and a minute.

You may create as many copies per database as you wish. We haven’t determined any confines for the number of databases you could back up either.

PgSQL databases are less sought after as opposed to the prevalent MySQL databases. However, they are a favored option for designers who are looking for the utmost stability for their websites and applications. Because of the incredibly user–friendly Databases Manager built–into the PRO2AIS Control Panel, you can administer all your PostgreSQL databases with a simple mouse click.

You can find PgSQL databases bundled automatically within the best Linux cloud website hosting service packages. In case you are with a standard hosting package, you’re able to ask for PgSQL databases to be included in your hosting account as upgrades.

With PRO2AIS, you will always discover the latest variant of MySQL and also the default MySQL storage engine – InnoDB, installed.

InnoDB is more dependable than the old storage engine’s edition – MyISAM. It is ACID–compliant and, best of all – it offers total transaction support. Additionally, it uses row–level locking, as opposed to MyISAM’s table–level locking, that would always trigger functionality troubles at peak usage occasions.

Keeping track of the load caused by the databases within your powerful website assists you to reduce all kinds of overload issues that could slow it down and ward off website visitors. For this specific purpose, we’ve incorporated a comprehensive Database Stats tool within the Website Control Panel. There you can find in–depth info on the arriving requests to your databases for every single hour, day and month.

In line with the quantity of daily and per hour queries, it will be easy to find out which databases are utilized the most and also consider procedures to optimize their load.