Database Manager

Taking control of your databases is easier than ever, thanks to the Site Control Panel user interface for MySQL and PgSQL management! Assuming you do not have thorough experience of dealing with databases, you will find it simple to handle our Database Manager.

You can create a brand new database merely by typing the user name and password or generate a database backup with simply a click of the mouse. Additionally, from the Data Manager you’ll have direct access to the administrator area for each and every database, so you can efficiently modify it.

With the Database Manager it is easy to produce an archived copy of your database anytime you want! For this reason, you’ll always have a data backup of your dynamic content in the event your web site gets hacked or you incorrectly erase a database. To create a backup: click on the ’clock’ icon on the side of any database and then wait for a few seconds for the backup process to be finalized.

There are no limits about the amount of databases you can back up or the amount of backup copies you can create for a database.

You will find PgSQL support in our Linux cloud web hosting bundles. PgSQL databases aren’t as sought after and widespread as MySQL, nevertheless they deliver the highest level of protection for your website content. Because of this, many popular companies such as Skype and Yahoo implement PgSQL databases. Controlling PgSQL databases is as easy as MySQL, thanks to the user–friendly user interface of the Database Manager.

PgSQL databases are provided by default inside the most sophisticated web hosting bundles. For the regular packages, they’re featured as upgrades.

We have set up InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is made for huge database web sites which need high levels of general performance and scalability. Tests demonstrate that sites using InnoDB based tables reach a 3–fold overall performance grow for very large joins, in comparison to those employing MyISAM tables.

InnoDB employs row–level locking as a way to remove the effectiveness difficulties detected at the maximum usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

With the thorough database stats tool incorporated into the Site Control Panel, it is possible to keep track of the stress generated by your busy websites twenty–four hours a day. Virtually any overload problem with your web sites can reduce the loading speeds and have a damaging impact on the overall experience of your respective website visitors. Therefore, by having data for the database load right away, it will be easier to eliminate overload problems right away.

The database stats interface displays data of the number of daily, hourly and monthly queries, allowing you to evaluate how the load is distributed over various time periods.