Database Manager

Overseeing your databases is much simpler than in the past, because of the Online Control Panel interface for MySQL and PgSQL control! Assuming you do not have detailed experience in utilizing databases, it will be simple to manage the Database Manager.

You can create a new database by merely keying in the username and password or create a database backup with simply a mouse click. In addition, from the Data Manager you have direct access to the administrative area for every single database, so that you can immediately manage it.

If you have dealt with databases, you know making a manual database backup is just not a basic job. In order to change this, we have developed very simple tool that can back up your whole database with merely one click. The back–up file is going to be set for you in less than a minute, depending on the size of the selected database.

There aren’t any confines on the actual number of backups you may make for any chosen database.

Nearly all of GNet Hosting’s Linux shared hosting packages present PgSQL support. Although dropping behind MySQL with regard to reputation and usage, PgSQL databases are renowned for giving the greatest level of protection for your web site content material. That is the reason why businesses like Skype and Yahoo employ PgSQL databases instead of MySQL.

In terms of database management, PgSQL is equally easy to use as MySQL.

We’ve incorporated InnoDB – the brand new standard MySQL database engine on each of our web servers. InnoDB is made for massive database sites that demand high efficiency and scalability. Trials have demonstrated that sites working with InnoDB based tables reach a 3–fold performance grow for big joins, compared with those applying MyISAM tables.

InnoDB takes advantage of row–level locking as a way to take away the performance issues seen at the top consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

Through the thorough database statistics tool built–into the Online Control Panel, you are going to be able to keep track of the stress generated by your dynamic websites 24 hour a day. Virtually any overload trouble with your sites can slow the loading speeds and have a damaging influence over the overall impression of your respective site visitors. Thus, having information about the database work right away, you are able to fix overload troubles in a timely manner.

The database stats user interface reveals info of the amount of daily, hourly and monthly lookups, in order to analyze how the load is spread over different time frames.