Database Manager

The Database Manager in our Web Control Panel features a powerful but convenient to use user interface. You can set up a new MySQL or PostgreSQL database simply by typing a user name and security password. Moreover, you may create a backup file or customize the password of any database with only a mouse click.

With the Database Manager you will possess direct access to the administration area for all of your databases, so its possible to make easy adjustments should you have to.

Provided you have worked with databases, you are aware that making a manual database backup isn’t an elementary job. So as to change this, we have developed an easy to understand tool that will back up the entire database with simply a single click of the mouse. The back–up file shall be available for you in less than a minute, with regards to the size of the selected database.

There are no confines on the actual number of backups you can make for a selected database.

PgSQL databases are less popular than the standard MySQL databases. Then again, they are a preferred selection for web developers who are looking for the uttermost stability for their sites and apps. Because of the intuitive Database Manager built–into the BYOHOST Control Panel, you can manage all your PostgreSQL databases with only a click of the mouse.

You’re going to find PgSQL databases bundled by default within the top Linux hosting packages. Assuming that you are with a standard hosting package, it is easy to request PgSQL databases to be included in your hosting account as upgrades.

We have added InnoDB – the new default MySQL database engine on our servers. InnoDB is perfect for large database web sites which need high overall performance and scalability. Tests indicate that web sites employing InnoDB based tables attain a 3–fold operation grow for substantial joins, when compared to those applying MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to remove the effectiveness difficulties spotted at the peak usage times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Keeping tabs on the load made by the databases within your powerful web site makes it possible to stop all kinds of overload troubles that could slow it down and chase away visitors. As a result, we have built–in a detailed Database Stats tool into the Web Control Panel. There you can see comprehensive information about the inbound requests to your databases for every hour, day and month.

Depending on the amount of daily and by the hour queries, you will be able to find out which databases are used the most and then consider steps to enhance their work.