Databases Manager

The Databases Manager in our Control Panel contains a refined yet easy to navigate user interface. It is possible to configure a brand new MySQL or PostgreSQL database by simply typing a username and password. Additionally, you can make a backup file or alter the security password of your database with simply a mouse click.

With the Databases Manager you will possess direct access to the admin area for each of your databases, meaning you can make effortless changes when you need to.

We’ve changed the manual database back–up generation into a very easy activity. To do this: inside the Databases Manager, click the ’clock’ symbol near the database that you intend to back up and wait for a couple of seconds for the process to take place. With regards to the size of your database, the building of any back–up file is going to take between a few seconds and a minute.

You can make as many back–ups of a database as you desire. We’ve not set any confines for the amount of databases that you could back up either.

Just about all of Hosting Gators’s Linux shared packages packages offer PgSQL support. Although falling behind MySQL with regard to reputation and usage, PgSQL databases are renowned for offering the best level of safety for your web site content material. This is the main reason why businesses like Skype and Yahoo make use of PgSQL databases and not MySQL.

In relation to database administration, PgSQL is equally easy to use as MySQL.

With Hosting Gators, you’ll regularly find the most recent build of MySQL and also the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more dependable when compared to the past storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it includes total transaction support. Furthermore, it employs row–level locking, in lieu of MyISAM’s table–level locking, that seemed to result in functionality problems at peak usage times.

Monitoring the load generated by the databases within your powerful site makes it possible to stop any sort of overload troubles that could slow it down and chase away visitors. For that reason, we’ve designed a in depth Database Stats tool directly into the Control Panel. There you can find detailed information on the arriving requests to your databases for every single hour, day and month.

Using the quantity of day–to–day and by the hour queries, it will be easy to find out which databases are used the most and take steps to optimize their load.