Database Manager

Database management may appear like a complicated job to newbie cloud hosting clients, nevertheless with HQ Linux Hosting’s Database Manager, it’s in fact really simple! To configure a whole new database, you only need to enter your username and password. Database back–ups are only a mouse click away as well.People who would like to examine their databases as well as update them can use the phpMyAdmin and phpPgAdmin tools.

Through the Database Manager you can easily make an archived duplicate of your database anytime you desire! Therefore, you’ll always have a backup of your active information in case your web site gets compromised or if you accidentally erase a database. To produce a backup: click on the ’clock’ image beside a particular database and then just wait for a few seconds for the process to be finished.

There are no limits for the number of databases you can back up or the quantity of back–ups you can create for a database.

PgSQL databases are significantly less sought after compared to the standard MySQL databases. Nevertheless, they represent a favorite option for designers who are looking for the utmost stability for their sites and apps. Via the incredibly user–friendly Database Manager built into the HQ Linux Hosting Control Panel, you can administer all of your PostgreSQL databases with a mouse click.

Yow will discover PgSQL databases provided by default inside the top Linux shared website hosting services packages. Assuming that you are with a standard hosting package, you can easily ask for PgSQL databases to be added to your hosting account as upgrades.

We’ve installed InnoDB – the new standard MySQL database engine on all of our servers. InnoDB is designed for significant database web sites which require high levels of effectiveness and scalability. Tests have shown that web sites working with InnoDB based tables achieve a 3–fold general performance grow for massive joins, in comparison with those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to clear away the operation issues noticed at the maximum usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Tracking the load caused by the databases on your powerful website assists you to prevent any kind of overload difficulties that could slow it down and ward off visitors. Therefore, we have provided a detailed Database Stats tool within the Web Site Control Panel. There you can see in–depth info about the inbound requests to your databases for every single hour, day and month.

Using the amount of day–to–day and by the hour queries, you are able to determine which databases are being used the most and also take steps to optimize their work.