Database Manager

The Database Manager in our Online Control Panel incorporates a refined yet simple to operate interface. It is easy to configure a brand new MySQL or PostgreSQL database by just typing in a username and password. Furthermore, you can make a back–up file or change the security password of the database with simply a mouse click.

Through the Database Manager you’ll possess direct access to the administrator area for each of your databases, so you can make simple alterations if you ever need to.

Through the Database Manager it is simple to produce an archived copy of your database whenever you desire! Therefore, you are going to always have a back–up of your active content material in the event your site gets compromised or if you mistakenly get rid of a database. To make a backup: click the ’clock’ icon beside a certain database and then just wait for a few seconds for the backup process to be carried out.

There are not any limitations on the amount of databases you can back up or the number of backups you may make for a database.

PgSQL databases are less widespread compared to the well–known MySQL databases. Nonetheless, they represent a preferred alternative for designers seeking the greatest stability for their websites and apps. Because of the incredibly user–friendly Database Manager built–into the HostingOn Control Panel, you can administer your PostgreSQL databases with a mouse click.

You are going to find PgSQL databases included by default in the advanced hosting packages. Provided that you are using a basic hosting package, it is possible to request PgSQL databases to be added in your web hosting account as upgrades.

We’ve installed InnoDB – the new standard MySQL database engine on all our machines. InnoDB is perfect for massive database web sites that require high overall performance and scalability. Experiments have established that sites applying InnoDB based tables reach a 3–fold functionality grow for huge joins, when compared to those employing MyISAM tables.

InnoDB takes advantage of row–level locking so as to clear away the operation difficulties detected at the high consumption times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load generated by the databases within your powerful site assists you to reduce all sorts of overload problems that could slow it down and chase away website visitors. For this reason, we’ve bundled a descriptive Database Stats tool directly into the Online Control Panel. There you will find thorough info about the arriving requests to your databases for each hour, day and month.

Based on the amount of day–to–day and per hour queries, you are going to be able to find out what databases are used the most as well as take measures to enhance their work.