Database Manager

Overseeing your databases is much easier than before, due to the Online Control Panel user interface for MySQL and PgSQL administration! Even though you may not have in depth experience in dealing with databases, it will be an easy task to work with Cheap Hosting’s Database Manager.

You can make a completely new database by merely specifying the user name and security password or generate a database backup with just a click of the mouse. In addition, via the Data Manager you will get direct access to the administrator area for each individual database, so you’re able to easily edit it.

With the Database Manager it is simple to produce an archived backup of your database when you need! Therefore, you’ll always have a data backup of your active content material in case your web site gets broken into or if you erroneously eliminate a database. To make a back–up: click the ’clock’ icon next to any database and then just wait for a few seconds for the backup process to be executed.

There are not any limits for the amount of databases you can back up or the volume of backup copies you can make for a database.

You’re going to find PgSQL support in every one of our web hosting plans packages. PgSQL databases may not be as sought after and widespread as MySQL, nevertheless they provide you with the best level of security for your website content. Because of this, several popular companies like Skype and Yahoo make use of PgSQL databases. Controlling PgSQL databases is as easy as MySQL, as a result of the intuitive user interface of the Database Manager.

PgSQL databases are incorporated automatically within the most sophisticated web hosting bundles. For the normal packages, they are featured as upgrades.

The MySQL databases on Cheap Hosting’s servers use the newest version of the InnoDB storage engine. InnoDB was designed to guarantee the highest performance for websites that work with substantial amounts of data. It provides CPU efficiency that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, so that you are able to update/insert/create/alter/drop several times for one "operation" of your app. Furthermore, it employs row–level locking instead of MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

Through the comprehensive database stats tool integrated into the Online Control Panel, you are able to keep track of the stress generated by your busy sites 24 hour a day. Every overload difficulty with your websites could lower the loading speeds and have a bad effect on the online experience of your site visitors. Which means that, having data about the database work instantly, you’ll be able to resolve overload problems right away.

The database stats user interface displays info of the number of daily, hourly and monthly queries, so its possible to review just how the load is distributed over various periods of time.