Database Manager

The Database Manager in the Hosting Control Panel includes a powerful yet well designed interface. It is easy to set up a whole new MySQL or PostgreSQL database by just typing a user name and security password. Also, you could make a back–up file or customize the security password of any database with only a click of the mouse.

With the Database Manager you will have immediate access to the management area for each of your databases, allowing you to make simple and easy adjustments when you need to.

Via the Database Manager you can easily make an archived duplicate of your database whenever you want! That way, you are going to always have a backup of your active content material in the event your website gets broken into or you accidentally get rid of a database. To generate a back–up: click the ’clock’ image next to any database and then just wait for a couple of seconds for the process to be performed.

There are not any confines for the volume of databases you can back up or the number of backups you can make for a database.

Just about all of the website hosting services bundles offer PgSQL support. While dropping behind MySQL in terms of popularity and utilization, PgSQL databases are famous for offering the highest level of safety for your web site content. It is the main reason why businesses like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

When it comes to database management, PgSQL is just as uncomplicated as MySQL.

We’ve incorporated InnoDB – the brand new standard MySQL database engine on every one of our servers. InnoDB is perfect for huge database websites that require high effectiveness and scalability. Tests have demonstrated that websites applying InnoDB based tables attain a 3–fold functionality grow for substantial joins, as compared to those employing MyISAM tables.

InnoDB uses row–level locking in an effort to take away the operation difficulties observed at the peak usage times of the prior release of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load accumulated by the databases within your active website assists you to avoid all sorts of overload troubles that might slow it down and chase away visitors. For this reason, we’ve bundled a thorough Database Stats tool directly into the Hosting Control Panel. There you can see extensive information on the inbound requests to your databases for each hour, day and month.

In line with the number of daily and per hour queries, it is possible to find out what databases are utilized the most and also consider procedures to optimize their work.