Database Manager

Taking control of your databases is easier than in the past, on account of the Web Hosting Control Panel interface for MySQL and PgSQL administration! Even though you may not have in depth knowledge of utilizing databases, it will be very easy to deal with the Database Manager.

You can make a completely new database simply by specifying the username and security password or produce a database back–up with a simple click of the mouse. Likewise, from the Data Manager you’ll have direct access to the administrator area for each database, which means you can instantly modify it.

From the Database Manager it is simple to create an archived copy of your database whenever you desire! For this reason, you will always have a data backup of your active content material if your website gets hacked or if you accidentally erase a database. To create a back–up: click on the ’clock’ symbol beside a particular database and afterwards just wait for a couple of seconds for the backup process to be done.

There aren’t any restrictions about the volume of databases you would be able to back up or the amount of backup copies you can create for a database.

Almost all of Cheap-PHP-Hosting’s shared website hosting plans bundles feature PgSQL support. Whilst dropping behind MySQL with respect to global recognition and usage, PgSQL databases are famous for providing the highest level of security for your web site content and articles. It is the reason why companies such as Skype and Yahoo employ PgSQL databases and not MySQL.

In terms of database administration, PgSQL is identically quick as MySQL.

The MySQL databases on Cheap-PHP-Hosting’s machines make use of the latest build of the InnoDB storage engine. InnoDB is intended to guarantee the highest possible effectiveness for web sites that work with large amounts of data. It offers CPU effectiveness that could not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, meaning that you can update/insert/create/alter/drop more than once for one "operation" of your web application. At the same time, it takes advantage of row–level locking and not MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.

Cheap-PHP-Hosting offers you a quick option to keep tabs on the database usage of your busy web sites. Through the descriptive database stats user interface, which is included in the Web Hosting Control Panel, it’s possible to keep an eye on the load generated through your busy sites in real time. The offered data will help you to assess the database load variations by the hour, per day or each month.

You can easily observe the database load for your web sites from the Database Stats section of the Web Hosting Control Panel. The table onscreen features the database queries accumulated within the present month. To inspect information for an earlier month, simply click on the back arrows located at the top.