Database Manager

The Database Manager in the Site Control Panel has a powerful but still uncomplicated user interface. You can easily configure a brand new MySQL or PostgreSQL database by just entering a username and password. Additionally, you may create a back–up file or customize the password of any database with a mouse click.

Via the Database Manager you’ve got direct access to the administrator area for all of your databases, so that you can make simple and easy corrections when you have to.

Assuming you have worked with databases, you already know that generating a manual database backup is simply not a basic task. In order to change this, we’ve made an easy to understand tool that can back up the entire database with a single click. The backup file is going to be prepared for you in less than a minute, with regards to the size of the selected database.

There aren’t any limits on the total number of copies you can create for any particular database.

You’re going to find PgSQL support in all our shared web hosting packages. PgSQL databases might not be as well–known and widespread as MySQL, nonetheless they supply the highest level of protection for your site content and articles. For this reason, several widely known companies like Skype and Yahoo take advantage of PgSQL databases. Dealing with PgSQL databases is as easy and simple as MySQL, thanks to the user–friendly user interface of the Database Manager.

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

We have added InnoDB – the new standard MySQL database engine on every one of our servers. InnoDB is ideal for big database sites that require high efficiency and scalability. Trials show that web sites working with InnoDB based tables achieve a 3–fold performance increase for significant joins, in comparison with those employing MyISAM tables.

InnoDB uses row–level locking in order to get rid of the efficiency issues spotted at the high consumption times of the prior variant of the database engine – MyISAM, which uses table–level locking.

GiantHosts offers you a painless way for you to monitor the database usage of your powerful websites. From the descriptive database stats user interface, which is included in the Site Control Panel, you can keep track of the load generated by your busy websites in real time. The provided details will enable you to assess the database load variations every hour, daily or monthly.

It is easy to monitor the database load for your web sites within the Database Stats area of the Site Control Panel. The table on–screen reveals the database lookups created within the present month. To assess details for an earlier month, all you have to do is click on the back arrows positioned at the top.