Databases Manager

Supervising your databases now is easier than in the past, because of the Online Control Panel interface for MySQL and PgSQL administration! Even though you may not have detailed knowledge in making use of databases, it will be simple to use our Databases Manager.

You may create a brand new database just by entering the username and security password or create a database back–up with simply a mouse click. Additionally, from the Data Manager you will get direct access to the management area for every database, which enables you to easily alter it.

With the Databases Manager it’s possible to produce an archived copy of your database anytime you would like! This way, you will always have a back–up of your dynamic information in the event your site gets broken into or you erroneously get rid of a database. To make a backup: click on the ’clock’ icon on the side of a particular database and after that just wait for a few seconds for the process to be finished.

There won’t be any limitations about the number of databases you would be able to back up or the amount of backups you may make for a database.

PgSQL databases are less common as compared to the well–known MySQL databases. Having said that, they represent a favored selection for web developers seeking the greatest security for their sites and apps. Thanks to the user–friendly Databases Manager integrated into the E12Web Control Panel, you can control all your PostgreSQL databases with just a click of the mouse.

You can find PgSQL databases integrated by default inside the advanced cloud web hosting packages. Assuming that you are using a standard hosting package, it is possible to ask for PgSQL databases to be included in your account as upgrades.

We’ve integrated InnoDB – the new standard MySQL database engine on each of our servers. InnoDB is ideal for significant database sites which need high performance and scalability. Trials demonstrate that sites employing InnoDB based tables reach a 3–fold performance increase for significant joins, when compared to those making use of MyISAM tables.

InnoDB utilizes row–level locking in order to be able to remove the functionality problems seen at the peak consumption times of the prior release of the database engine – MyISAM, which uses table–level locking.

Tracking the load produced by the databases for your powerful site makes it possible to prevent all sorts of overload difficulties that could slow it down and ward off visitors. For this specific purpose, we have designed a detailed Database Stats tool straight into the Online Control Panel. There you can get in depth info on the incoming requests to your databases for each and every hour, day and month.

In line with the number of daily and by the hour queries, it will be easier to find out what databases are employed the most and then take procedures to enhance their work.