Databases Manager

Supervising your databases is much simpler than in the past, as a result of Site Control Panel user interface for MySQL and PgSQL management! In case you do not have thorough knowledge in handling databases, it will be an easy task to handle the Databases Manager.

You could make a whole new database by only keying in the user name and security password or produce a database back–up with simply a click of the mouse. Furthermore, within the Data Manager you will possess direct access to the administrative area for every single database, meaning you can almost instantly alter it.

Provided you have dealt with databases, you are aware that creating a manual database backup is just not a basic task. So as to change this, we’ve developed a simple tool that will back up the entire database with one mouse click. The back–up file shall be all set for you in under a minute, depending on the size of the selected database.

There won’t be any limitations on exactly how many backup copies you could make for any specific database.

You can find PgSQL support in our cloud website hosting plans plans. PgSQL databases may not be as sought after and frequently used as MySQL, nonetheless they provide the maximum level of stability for your site content and articles. Because of this, a number of famous companies like Skype and Yahoo work with PgSQL databases. Taking care of PgSQL databases is as elementary as MySQL, because of the easy–to–use user interface of the Databases Manager.

PgSQL databases are integrated automatically inside of the most innovative web hosting plans. For the regular packages, they are featured as upgrades.

We have installed InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is made for large database web sites that require high levels of effectiveness and scalability. Experiments show that sites employing InnoDB based tables attain a 3–fold operation boost for significant joins, when compared with those making use of MyISAM tables.

InnoDB uses row–level locking as a way to remove the performance difficulties noticed at the peak usage times of the previous variant of the database engine – MyISAM, which employs table–level locking.

We provide you a straightforward route to keep track of the database usage on your active websites. From your detailed database stats interface, that is built into the Site Control Panel, you can observe the load produced by your busy websites in real time. The offered data will enable you to analyze the database load fluctuations by the hour, daily or monthly.

You’re able to record the database load for your websites from the Database Stats portion of the Site Control Panel. The table onscreen features the database queries accumulated during the present month. To inspect information for an earlier month, click on the back arrows situated at the top.