Database Manager

The Database Manager inside the Site Control Panel incorporates a powerful but convenient to use interface. It is possible to configure a completely new MySQL or PostgreSQL database by just typing in a username and security password. What’s more, you could make a backup file or customize the security password of any database with only a mouse click.

With the Database Manager you will possess direct access to the administrative area for all of your databases, allowing you to make easy corrections if you ever have to.

We’ve designed the manual database back–up generation into a quite easy job. To execute this: inside of the Database Manager, click the ’clock’ symbol beside the database that you would like to back up and then hang on for a few seconds for the backup process to take place. Depending upon the size of your database, the building of a backup file is going to take between a couple of seconds and a minute.

You can create as many back–ups of a database as you wish. We’ve not specified any limitations about the amount of databases you can back up either.

PgSQL databases are significantly less widespread as opposed to the prevalent MySQL databases. Even so, they’re a favorite selection for developers who seek the finest protection for their sites and apps. Thanks to the incredibly user–friendly Database Manager built into the HostingBox.biz Control Panel, you can administer your PostgreSQL databases with just a mouse click.

You will find PgSQL databases bundled automatically inside the best Linux shared web hosting packages packages. Provided that you are using a standard hosting package, you’re able to request PgSQL databases to be added in your account as upgrades.

We have set up InnoDB – the brand new default MySQL database engine on every one of our web servers. InnoDB is perfect for sizeable database sites which require high levels of overall performance and scalability. Tests show that sites employing InnoDB based tables attain a 3–fold operation increase for very large joins, as compared to those making use of MyISAM tables.

InnoDB utilizes row–level locking in an effort to eliminate the efficiency problems detected at the peak usage times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load produced by the databases on your dynamic website will let you reduce any sort of overload troubles that might slow it down and ward off site visitors. For that reason, we have incorporated a thorough Database Stats tool straight into the Site Control Panel. There you will find broad info about the inbound requests to your databases for each hour, day and month.

Depending on the number of daily and by the hour queries, you are able to find out what databases are employed the most and then consider procedures to optimize their load.