Database Manager

The Database Manager inside our Site Control Panel incorporates an effective nevertheless user–friendly and uncomplicated interface. You are able to configure a whole new MySQL or PostgreSQL database simply by typing a user name and password. Also, you can make a backup file or alter the password of your database with merely a mouse click.

With the Database Manager you’ll possess direct access to the administration area for all of your databases, so that you can make effortless corrections should you need to.

If you have worked with databases, you already know that making a manual database backup just isn’t a basic task. So as to change this, we have made an easy to understand tool that can back up your entire database with merely one click. The backup file shall be available for you in under a minute, depending on the size of the chosen database.

There won’t be any limitations on just how many backup copies you could make for a specific database.

You’ll find PgSQL support in each of our Linux cloud packages packages. PgSQL databases are not as well–known and frequently used as MySQL, nonetheless they supply you with the highest level of stability for your site content. For this reason, many popular brands like Skype and Yahoo apply PgSQL databases. Controlling PgSQL databases is as elementary as MySQL, due to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are included by default inside the most advanced web hosting packages. For the normal packages, they are presented as upgrades.

The MySQL databases on Galloway Web Hosting’s servers employ the latest release of the InnoDB storage engine. InnoDB has been built to ensure the highest efficiency for web sites that work with massive volumes of data. It provides CPU efficiency that can not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, so that you can easily update/insert/create/alter/drop several times for a single "operation" of your web application. Also, it employs row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Keeping track of the load accumulated by the databases for your powerful website will help you reduce all kinds of overload problems that can slow it down and ward off website visitors. For this purpose, we have incorporated a complete Database Stats tool within the Site Control Panel. There you can see in–depth information about the arriving requests to your databases for every hour, day and month.

Depending on the volume of daily and per hour queries, it is possible to find out which databases are being used the most and then consider measures to optimize their load.