Databases Manager

Supervising your databases is much easier than before, due to the Web Site Control Panel interface for MySQL and PgSQL control! Even though you may not have substantial knowledge in utilizing databases, it will be an easy task to deal with our Databases Manager.

You can make a whole new database by simply keying in the user name and security password or generate a database back–up with only a click of the mouse. Likewise, from the Data Manager you will get direct access to the management area for each and every database, so that you can efficiently alter it.

If you have worked with databases, you already know that making a manual database backup is not really an elementary task. So as to change this, we have developed a simple and easy to use tool that will back up your whole database with only a single click. The data backup file shall be completely ready for you in under a minute, with respect to the size of the selected database.

You won’t notice any confines on the actual number of backups you can make for a chosen database.

You’ll find PgSQL support in all our shared plans bundles. PgSQL databases might not be as popular and commonly used as MySQL, however they offer the highest level of security for your site content. Therefore, a lot of well–known companies such as Skype and Yahoo implement PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, thanks to the intuitive user interface of the Databases Manager.

PgSQL databases are provided automatically within the most sophisticated web hosting plans. For the normal bundles, they are offered as upgrades.

We’ve installed InnoDB – the new standard MySQL database engine on all of our servers. InnoDB is great for massive database web sites that require high levels of effectiveness and scalability. Tests show that sites using InnoDB based tables attain a 3–fold operation boost for big joins, in comparison with those working with MyISAM tables.

InnoDB employs row–level locking so as to clear away the efficiency difficulties spotted at the top consumption times of the prior version of the database engine – MyISAM, which uses table–level locking.

Tracking the load made by the databases for your active site will help you reduce all sorts of overload issues that might slow it down and ward off site visitors. Therefore, we’ve built–in a detailed Database Stats tool into your Web Site Control Panel. There you can find complete info on the incoming requests to your databases for every single hour, day and month.

Using the amount of daily and per hour queries, it will be straightforward to find out what databases are used the most and then take measures to enhance their load.