Databases Manager

The Databases Manager in our Website Control Panel incorporates a robust nevertheless user friendly interface. It is possible to set up a whole new MySQL or PostgreSQL database by simply specifying a user name and security password. What’s more, you could make a back–up file or customize the password of a database with simply a click of the mouse.

From the Databases Manager you’ve got direct access to the administrative area for each of your databases, meaning you can make effortless corrections if you happen to need to.

Through the Databases Manager you’re able to produce an archived duplicate of your database when you need! That way, you’ll always have a data backup of your dynamic content in the event your web site gets broken into or if you incorrectly eliminate a database. To make a back–up: click the ’clock’ icon next to any database and after that just wait for a couple of seconds for the process to be carried out.

There are no restricts about the quantity of databases you can back up or the number of back–ups you can make for a database.

You will find PgSQL support in our Linux cloud web hosting packages bundles. PgSQL databases are not as famous and widely used as MySQL, nevertheless they give the highest level of safety for your site content and articles. For this reason, several widely known companies like Skype and Yahoo employ PgSQL databases. Managing PgSQL databases is as easy as MySQL, due to the intuitive interface of the Databases Manager.

PgSQL databases are provided automatically within the most advanced web hosting packages. For the standard packages, they are included as upgrades.

With Web-Wizards, you shall always find the newest build of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is much more stable in comparison to the old storage engine’s edition – MyISAM. It’s ACID–compliant and, above all – it gives complete transaction support. Additionally, it makes use of row–level locking, as an alternative to MyISAM’s table–level locking, that used to cause performance problems at peak usage occasions.

Keeping tabs on the load made by the databases on your powerful site makes it possible to reduce all kinds of overload problems that can slow it down and ward off website visitors. As a result, we’ve built–in a in depth Database Stats tool directly into the Website Control Panel. There you can see complete information about the arriving requests to your databases for each and every hour, day and month.

In line with the number of day–to–day and by the hour queries, it’s possible to determine which databases are being used the most and also take procedures to optimize their work.