Databases Manager

The Databases Manager in our Hosting Control Panel boasts a robust nevertheless intuitive user interface. It’s possible to configure a brand new MySQL or PostgreSQL database by just specifying a user name and password. What’s more, you can create a backup file or customize the security password of an database with a click of the mouse.

Through the Databases Manager you’ll possess immediate access to the administrative area for all of your databases, which means you can make hassle–free modifications if you happen to need to.

Via the Databases Manager you are able to make an archived duplicate of your database when you would like! Thus, you will always have a back–up of your operating content material if your site gets hacked or if you erroneously get rid of a database. To create a backup: click the ’clock’ icon next to any database and afterwards just wait for a few seconds for the process to be finalized.

There aren’t any restrictions for the volume of databases you are able to back up or the number of backups you can make for a database.

PgSQL databases are significantly less famous than the popular MySQL databases. Then again, they represent a favorite option for programmers who seek the utmost security for their sites and web applications. Through the intuitive Databases Manager included in the Dedicated Control Panel, you can administer all of your PostgreSQL databases with a click of the mouse.

You will find PgSQL databases integrated by default with the best Linux website hosting packages packages. If you are with a standard hosting package, you are able to ask for PgSQL databases to be added in your website hosting account as upgrades.

We have integrated InnoDB – the new standard MySQL database engine on all of our web servers. InnoDB is perfect for huge database sites that need high effectiveness and scalability. Tests indicate that sites applying InnoDB based tables reach a 3–fold overall performance boost for very large joins, compared with those making use of MyISAM tables.

InnoDB utilizes row–level locking in an effort to take away the overall performance problems found at the high usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load made by the databases on your active web site makes it possible to reduce virtually any overload troubles that can slow it down and chase away site visitors. As a result, we’ve integrated a complete Database Stats tool into the Hosting Control Panel. There you can find in depth info on the incoming requests to your databases for each and every hour, day and month.

Using the volume of daily and by the hour queries, it will be easier to determine which databases are utilized the most and also consider measures to enhance their load.