Databases Manager

Overseeing your databases is easier than before, on account of the Website Control Panel user interface for MySQL and PgSQL control! Even if you do not have considerable expertise in working with databases, you will find it easy to use BrillHost’s Databases Manager.

You can make a whole new database by simply typing the username and security password or produce a database back–up with just a click of the mouse. Likewise, through the Data Manager you’ll have direct access to the admin area for each individual database, allowing you to quickly edit it.

If you have dealt with databases, you are aware that making a manual database back–up isn’t a basic task. As a way to change this, we have made very simple tool that can back up your whole database with just one click. The backup file will be available for you in under a minute, depending on the size of the chosen database.

There aren’t any limits on the actual number of back–ups you may make for any selected database.

You can find PgSQL support in every one of our cloud hosting packages. PgSQL databases might not be as famous and commonly used as MySQL, nevertheless they provide the greatest level of protection for your website content. For this reason, several widely known companies like Skype and Yahoo take advantage of PgSQL databases. Managing PgSQL databases is as elementary as MySQL, thanks to the user–friendly interface of the Databases Manager.

PgSQL databases are provided by default inside the most innovative web hosting plans. For the normal packages, they are offered as upgrades.

We’ve incorporated InnoDB – the new standard MySQL database engine on our web servers. InnoDB is designed for sizeable database websites which require high effectiveness and scalability. Experiments indicate that web sites working with InnoDB based tables achieve a 3–fold operation increase for very large joins, in comparison to those using MyISAM tables.

InnoDB employs row–level locking in order to be able to eliminate the general performance issues seen at the high consumption times of the previous version of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load made by the databases on your powerful website assists you to reduce all kinds of overload issues that might slow it down and ward off website visitors. As a result, we’ve provided a detailed Database Stats tool into the Website Control Panel. There you can find in–depth info about the arriving requests to your databases for every single hour, day and month.

Depending on the volume of daily and by the hour queries, it will be easier to find out what databases are utilized the most and take procedures to optimize their work.