Databases Manager

Administering your databases is much easier than ever before, as a result of Web Control Panel interface for MySQL and PgSQL management! Provided you do not have considerable expertise in dealing with databases, you will find it an easy task to work with Champion Web Hosting’s Databases Manager.

You may create a whole new database by merely entering the username and security password or produce a database backup with a click of the mouse. Additionally, from the Data Manager you’ll possess direct access to the administrator area for each individual database, meaning you can quickly edit it.

We have made the manual database backup formation into a quite easy job. To do this: inside the Databases Manager, click the ’clock’ symbol on the side of the database that you would like to back up and then wait for a few seconds for the process to take place. Depending upon the size of the database, the creation of a back–up file will require somewhere between a few seconds and a minute.

You may make as many copies per database as you wish. We’ve not fixed any limitations on the volume of databases you could back up either.

You’ll find PgSQL support in all of our shared web hosting services plans. PgSQL databases are not as sought after and widespread as MySQL, but they provide you with the top level of safety for your site content and articles. Due to this, many well–known companies such as Skype and Yahoo employ PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, because of the easy–to–use interface of the Databases Manager.

PgSQL databases are included automatically within the most sophisticated web hosting packages. For the basic bundles, they are included as upgrades.

We have installed InnoDB – the brand new default MySQL database engine on each of our servers. InnoDB is good for large database web sites that demand high levels of efficiency and scalability. Tests demonstrate that web sites employing InnoDB based tables reach a 3–fold performance boost for very big joins, as opposed to those working with MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to eliminate the efficiency issues observed at the maximum usage times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.

From the all–inclusive database stats tool built–into the Web Control Panel, you will be able to keep a record of the load created by your dynamic websites twenty–four hours a day. Virtually any overload issue with your web sites can reduce the loading rates and have a bad influence over the online experience of your respective website visitors. Thus, by having data for the database work immediately, it is also possible to fix overload difficulties as fast as possible.

The database stats interface reveals information of the amount of daily, hourly and monthly lookups, in order to review how the load is distributed over different periods of time.