Database Manager

The Database Manager inside our Website Control Panel has an effective but still intuitive user interface. You’re able to set up a brand new MySQL or PostgreSQL database by just entering a user name and security password. What’s more, you can make a backup file or change the password of your database with simply a mouse click.

Via the Database Manager you will get immediate access to the management area for each of your databases, so its possible to make convenient alterations in the event you need to.

Within the Database Manager you’re able to create an archived copy of your database anytime you wish! Therefore, you are going to always have a backup of your operating content in the event your site gets compromised or you erroneously delete a database. To produce a back–up: click the ’clock’ symbol beside a particular database and then wait for a couple of seconds for the backup process to be finished.

There aren’t any limits for the number of databases you are able to back up or the quantity of back–ups you can create for any database.

Most of GalantHost’s shared hosting plans provide PgSQL support. Whilst falling behind MySQL in terms of reputation and usage, PgSQL databases are renowned for offering the greatest level of safety for your site content. That’s the reason why companies like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

With respect to database administration, PgSQL is equally uncomplicated as MySQL.

We have added InnoDB – the new standard MySQL database engine on our servers. InnoDB is good for substantial database web sites that need high levels of effectiveness and scalability. Trials have shown that websites applying InnoDB based tables achieve a 3–fold performance grow for huge joins, in comparison to those applying MyISAM tables.

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

Monitoring the load made by the databases for your active web site will let you avoid any overload problems that could slow it down and ward off visitors. For this specific purpose, we’ve built–in a thorough Database Stats tool in the Website Control Panel. There you can get complete info on the incoming requests to your databases for every single hour, day and month.

In line with the number of daily and hourly queries, it is possible to find out what databases are employed the most and consider steps to optimize their load.