Database Manager

Managing your databases is much simpler than in the past, due to the Control Panel user interface for MySQL and PgSQL management! Even if you do not have in depth experience in handling databases, you will find it simple to handle our Database Manager.

You can make a new database merely by typing the user name and password or create a database backup with a click of the mouse. Additionally, within the Data Manager you’ll get direct access to the management area for every database, which enables you to easily manage it.

We’ve developed the manual database backup generation into a very simple activity. To do so: in the Database Manager, click on the ’clock’ icon on the side of the database that you want to back up and after that hang on for a few seconds for the process to take place. Depending upon the size of your database, the generation of any back–up file will require somewhere between a couple of seconds and a minute.

You may create as many back–ups of a database as you would like. We have not specified any restrictions on the volume of databases you can back up as well.

You are going to find PgSQL support in each of our website hosting offers. PgSQL databases might not be as famous and widespread as MySQL, but they give the best level of safety for your web site content. Because of this, several famous companies such as Skype and Yahoo employ PgSQL databases. Controlling PgSQL databases is as elementary as MySQL, on account of the intuitive interface of the Database Manager.

PgSQL databases are bundled automatically inside the most innovative web hosting bundles. For the regular packages, they’re suggested as upgrades.

We’ve set up InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is ideal for large database websites which require high levels of effectiveness and scalability. Experiments demonstrate that web sites using InnoDB based tables attain a 3–fold functionality increase for significant joins, in comparison to those applying MyISAM tables.

InnoDB takes advantage of row–level locking so as to eliminate effectiveness problems found at the maximum usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

We provide you a surprisingly simple approach to monitor the database use on your powerful sites. Through the descriptive database stats interface, which is built–into the Control Panel, you’ll be able to track the load made from your active web sites in real time. The supplied information will help you analyze the database load variations by the hour, per day or monthly.

You can track the database load for your websites in the Database Stats section of the Control Panel. The table onscreen shows the database lookups accumulated during the present month. To inspect information for an earlier month, simply click on the back arrows situated at the top.