Database Manager

The Database Manager inside our Online Control Panel comes with a refined yet user friendly user interface. You’re able to set up a whole new MySQL or PostgreSQL database simply by typing a user name and password. Also, you can make a back–up file or customize the security password of a database with simply a mouse click.

Via the Database Manager you have direct access to the administrator area for every one of your databases, so its possible to make uncomplicated alterations in case you need to.

Provided you have dealt with databases, you already know that generating a manual database backup just isn’t an elementary job. As a way to change this, we’ve developed very simple tool that will back up the entire database with simply one mouse click. The back–up file will be prepared for you in less than a minute, based on the size of the selected database.

There are not any confines on the number of back–ups you may make for any specific database.

Most of our shared hosting plans deliver PgSQL support. While dropping behind MySQL regarding global recognition and application, PgSQL databases are renowned for supplying the greatest level of protection for your web site content. This is the basic reason why companies such as Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

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

We have added InnoDB – the new default MySQL database engine on our servers. InnoDB is perfect for massive database web sites that need high levels of overall performance and scalability. Tests show that websites employing InnoDB based tables attain a 3–fold overall performance grow for huge joins, compared with those utilizing MyISAM tables.

InnoDB makes use of row–level locking in order to be able to eliminate operation issues found at the peak consumption times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Tracking the load accumulated by the databases for your dynamic website will let you reduce any overload troubles that can slow it down and ward off visitors. Therefore, we have designed a complete Database Stats tool into your Online Control Panel. There you will find in–depth information about the incoming requests to your databases for every single hour, day and month.

In line with the number of day–to–day and by the hour queries, it is possible to find out what databases are utilized the most and then consider measures to enhance their work.