Database Manager

Overseeing your databases is much easier than ever, on account of the Web Hosting Control Panel interface for MySQL and PgSQL management! Even though you may not have extensive expertise in utilizing databases, it will be an easy task to handle GGMBSI.NET’s Database Manager.

You could make a new database just by entering the username and security password or create a database back–up with simply a mouse click. Additionally, via the Data Manager you’ll get direct access to the admin area for every database, meaning you can almost instantly alter it.

We’ve evolved the manual database backup generation into a very simple activity. To do so: inside of the Database Manager, click the ’clock’ icon on the side of the database that you want to back up and wait for a few seconds for the backup process to take place. Depending upon the size of the database, the building of a backup file will require somewhere between a few seconds and a minute.

You may make as many backup copies per database as you would like. We have not specified any boundaries for the volume of databases you could back up too.

Just about all of GGMBSI.NET’s Linux web hosting plans grant PgSQL support. Although dropping behind MySQL when considering acceptance and employment, PgSQL databases are famous for delivering the best level of safety for your site content material. That’s the key reason why businesses like Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

When considering database administration, PgSQL is equally hassle–free as MySQL.

The MySQL databases on GGMBSI.NET’s machines utilize the most recent version of the InnoDB storage engine. InnoDB has been designed to ensure the maximum performance for sites that process massive volumes of data. It supplies CPU efficiency that can not be equalled by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means that it’s possible to update/insert/create/alter/drop several times for a single "operation" of your web app. Furthermore, it takes advantage of row–level locking and not MyISAM’s table–level locking, that improves multi–user concurrency and performance.

Checking the load generated by the databases in your active web site will help you prevent all sorts of overload problems that can slow it down and chase away website visitors. For this specific purpose, we have bundled a descriptive Database Stats tool directly into the Web Hosting Control Panel. There you shall find all–inclusive information about the arriving requests to your databases for each hour, day and month.

Using the volume of daily and by the hour queries, it is possible to determine which databases are utilized the most as well as take steps to enhance their work.