Databases Manager

Overseeing your databases is much simpler than in the past, thanks to the Web Control Panel user interface for MySQL and PgSQL management! In case you do not have thorough knowledge of handling databases, you will find it very easy to manage the Databases Manager.

You could make a new database by only specifying the user name and password or create a database backup with a simple mouse click. Additionally, within the Data Manager you will have direct access to the management area for each database, meaning you can effectively revise it.

From the Databases Manager you can easily make an archived duplicate of your database anytime you wish! Therefore, you will always have a backup of your operating information in case your website gets hacked or if you accidentally eliminate a database. To make a back–up: click on the ’clock’ symbol on the side of any database and afterwards wait for a couple of seconds for the process to be done.

There are no restricts for the number of databases you can back up or the volume of backup copies you can make for any database.

You’ll find PgSQL support in all of our Linux shared website hosting plans offers. PgSQL databases might not be as well–known and widely used as MySQL, nevertheless they provide you with the maximum level of protection for your web site content. For this reason, a number of widely known brands like Skype and Yahoo apply PgSQL databases. Taking care of PgSQL databases is as easy and simple as MySQL, due to the easy–to–use user interface of the Databases Manager.

PgSQL databases are incorporated by default inside of the most advanced web hosting packages. For the normal plans, they are featured as upgrades.

The MySQL databases on our machines make use of the latest version of the InnoDB storage engine. InnoDB is developed to guarantee the highest functionality for websites that process big volumes of data. It delivers CPU performance that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and supplies total transaction support, so that you’ll be able to update/insert/create/alter/drop more than once for one "operation" of your web app. At the same time, it uses row–level locking as a substitute for MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

Monitoring the load accumulated by the databases on your powerful site assists you to stop any overload problems that can slow it down and ward off site visitors. For this purpose, we have incorporated a descriptive Database Stats tool straight into the Web Control Panel. There you will find extensive info about the arriving requests to your databases for each hour, day and month.

Using the amount of day–to–day and by the hour queries, it is possible to determine which databases are utilized the most and also take procedures to optimize their load.