Databases Manager

The Databases Manager within our Site Control Panel has an effective but intuitive interface. You can configure a whole new MySQL or PostgreSQL database by simply typing a username and password. Also, you can create a back–up file or change the password of a database with simply a mouse click.

With the Databases Manager you will possess direct access to the administration area for each of your databases, so you’re able to make uncomplicated adjustments if you ever have to.

We have changed the manual database back–up creation into a quite easy task. To execute this: in the Databases Manager, click the ’clock’ icon near the database that you intend to back up and then wait around for a few seconds for the process to take place. Depending upon the size of the database, the generation of any backup file will take between a few seconds and a minute.

You can make as many backups of a database as you wish. We haven’t specified any limits about the volume of databases that you could back up either.

The majority of Harries Web Hosting’s shared web hosting plans plans feature PgSQL support. Although falling behind MySQL in terms of acceptance and application, PgSQL databases are renowned for presenting the greatest level of protection for your website content material. That’s the primary reason why companies such as Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

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

The MySQL databases on Harries Web Hosting’s web servers utilize the newest build of the InnoDB storage engine. InnoDB is meant to guarantee the max functionality for sites that operate with sizeable amounts of data. It grants CPU performance that could not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, meaning that you’re able to update/insert/create/alter/drop many times for one "operation" of your application. In addition, it makes use of row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.

Tracking the load produced by the databases within your powerful website makes it possible to avoid virtually any overload troubles that can slow it down and ward off visitors. For this specific purpose, we’ve designed a detailed Database Stats tool in the Site Control Panel. There you can get comprehensive info about the arriving requests to your databases for each hour, day and month.

In line with the number of daily and by the hour queries, you’re going to be able to find out which databases are utilized the most and then consider measures to enhance their work.