Databases Manager

The Databases Manager inside our Hosting Control Panel boasts a robust but simple to use user interface. You can easily configure a brand new MySQL or PostgreSQL database simply by typing in a user name and security password. Additionally, you could make a back–up file or customize the password of your database with only a mouse click.

With the Databases Manager you’ll have immediate access to the administrative area for every one of your databases, which enables you to make uncomplicated adjustments in the event you have to.

We have developed the manual database back–up formation into a very easy task. To execute this: inside the Databases Manager, click on the ’clock’ icon near the database that you intend to back up and after that wait around for a couple of seconds for the backup process to take place. Depending on the size of your database, the generation of any backup file will take between a few seconds and a minute.

You can create as many backups of a database as you want. We’ve not specified any boundaries on the quantity of databases that you can back up as well.

PgSQL databases are less common compared to the well–known MySQL databases. Nevertheless, they are a favored selection for designers who seek the finest stability for their sites and web applications. Because of the easy–to–use Databases Manager integrated into the Full System Integration Inc. Control Panel, you can control all your PostgreSQL databases with merely a mouse click.

You can discover PgSQL databases integrated by default in the advanced Linux cloud hosting packages. If you are using a regular hosting package, you’ll be able to request PgSQL databases to be added to your web hosting account as upgrades.

We’ve incorporated InnoDB – the new default MySQL database engine on every one of our machines. InnoDB is made for significant database web sites that demand high levels of effectiveness and scalability. Experiments have established that sites employing InnoDB based tables reach a 3–fold performance boost for significant joins, in comparison to those employing MyISAM tables.

InnoDB employs row–level locking in order to be able to eliminate efficiency issues witnessed at the maximum usage times of the prior release of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load produced by the databases within your active website will let you avoid all sorts of overload difficulties that might slow it down and ward off site visitors. For this purpose, we’ve built–in a in depth Database Stats tool directly into the Hosting Control Panel. There you can get comprehensive information regarding the incoming requests to your databases for each and every hour, day and month.

Using the number of daily and per hour queries, it will be straightforward to determine which databases are employed the most and then take steps to optimize their work.