Database Manager

Overseeing your databases is less complicated than ever, because of the Website Control Panel interface for MySQL and PgSQL administration! Provided you do not have detailed experience in handling databases, it will be effortless to manage Host Plenty UK’s Database Manager.

You can make a brand new database just by specifying the user name and security password or make a database back–up with simply a click of the mouse. Additionally, via the Data Manager you’ll get direct access to the administrative area for every database, so you’re able to effectively modify it.

We’ve developed the manual database backup generation into a very easy task. To execute that: inside the Database Manager, click the ’clock’ symbol on the side of the database that you plan to back up and after that hang on for a few seconds for the backup process to take place. With respect to the size of your database, the creation of a back–up file will require somewhere between a couple of seconds and a minute.

You can make as many backups of a database as you want. We haven’t fixed any confines for the quantity of databases that you can back up either.

Most of our Linux shared web hosting plans grant PgSQL support. Whilst falling behind MySQL with regard to reputation and utilization, PgSQL databases are famous for delivering the top level of stability for your website content material. That is the primary reason why companies like Skype and Yahoo rely upon PgSQL databases as opposed to MySQL.

With regards to database management, PgSQL is equally straightforward as MySQL.

We’ve set up InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is good for significant database websites that require high functionality and scalability. Trials show that sites working with InnoDB based tables attain a 3–fold performance boost for very large joins, compared with those applying MyISAM tables.

InnoDB works by using row–level locking in order to be able to eliminate functionality problems noticed at the peak consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load accumulated by the databases in your active site makes it possible to reduce any sort of overload difficulties that can slow it down and chase away visitors. As a result, we’ve integrated a detailed Database Stats tool into your Website Control Panel. There you can find all–inclusive info about the inbound requests to your databases for every hour, day and month.

Based on the amount of daily and hourly queries, you are able to determine which databases are utilized the most and then take actions to optimize their load.