Databases Manager

The Databases Manager in the Hosting Control Panel boasts a powerful but user–friendly user interface. You can configure a new MySQL or PostgreSQL database by just typing in a user name and security password. What’s more, you could make a back–up file or change the security password of an database with a mouse click.

With the Databases Manager you’ll possess immediate access to the administration area for every one of your databases, so you can make effortless changes when you have to.

We have changed the manual database back–up generation into a quite easy job. To do this: within the Databases Manager, click the ’clock’ symbol next to the database that you plan to back up and then wait for a couple of seconds for the process to take place. Depending on the size of your database, the creation of a backup file will need somewhere between a few seconds and a minute.

You may create as many backups per database as you wish. We’ve not fixed any confines on the number of databases that you could back up either.

PgSQL databases are much less popular as opposed to the common MySQL databases. Having said that, they are a preferred selection for programmers who are looking for the uttermost safety for their web sites and web apps. Via the incredibly user–friendly Databases Manager integrated into the Be2Host.com Control Panel, you can control all your PostgreSQL databases with a simple mouse click.

You’re going to find PgSQL databases bundled automatically inside of the advanced Linux web hosting services packages. Provided that you are using a regular hosting package, it’s possible to request PgSQL databases to be added in your web hosting account as upgrades.

We have incorporated InnoDB – the brand new default MySQL database engine on each of our web servers. InnoDB is perfect for substantial database web sites which need high levels of functionality and scalability. Trials have demonstrated that sites applying InnoDB based tables attain a 3–fold efficiency boost for massive joins, in contrast to those making use of MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to eliminate overall performance difficulties found at the high usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load generated by the databases for your busy web site will help you reduce any kind of overload problems that could slow it down and chase away website visitors. As a result, we’ve built in a comprehensive Database Stats tool into your Hosting Control Panel. There you will find extensive information on the arriving requests to your databases for every hour, day and month.

In line with the number of day–to–day and by the hour queries, you are able to find out what databases are employed the most and also take steps to optimize their work.