Databases Manager

The Databases Manager in our Site Control Panel provides a powerful nevertheless uncomplicated interface. You’ll be able to configure a brand new MySQL or PostgreSQL database simply by typing a user name and password. In addition, you can make a backup file or alter the security password of any database with just a mouse click.

Through the Databases Manager you’ll possess immediate access to the management area for all of your databases, allowing you to make simple adjustments should you have to.

Provided you have dealt with databases, you already know that making a manual database back–up is not an elementary job. As a way to change this, we have created a simple tool that will back up the entire database with only one click. The data backup file will be all set for you in less than a minute, with regards to the size of the chosen database.

There won’t be any restrictions on the number of copies you may make for any specific database.

Just about all of the Linux hosting packages bundles provide PgSQL support. Although falling behind MySQL when considering reputation and employment, PgSQL databases are famous for presenting the greatest level of safety for your web site content and articles. It is the reason why businesses like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

With respect to database administration, PgSQL is just as straightforward as MySQL.

We’ve added InnoDB – the new default MySQL database engine on every one of our machines. InnoDB is ideal for sizeable database web sites that demand high general performance and scalability. Tests have established that sites utilizing InnoDB based tables achieve a 3–fold efficiency grow for big joins, when compared with those employing MyISAM tables.

InnoDB utilizes row–level locking in an effort to clear away the performance difficulties spotted at the maximum consumption times of the previous variant of the database engine – MyISAM, which employs table–level locking.

Ihcerhost offers you an easy way to observe the database use of your dynamic sites. From your in–depth database stats interface, which is included in the Site Control Panel, you’re able to keep track of the load created through your dynamic websites in real time. The provided information will assist you to evaluate the database load changes on an hourly basis, each day or per month.

You’ll be able to record the database load for all your web sites in the Database Stats part of the Site Control Panel. The table onscreen reveals the database lookups made within the present month. To review information for an earlier month, all you have to do is click on the back arrows placed at the top.