While in the HQ Linux Hosting Web Site Control Panel you will find a fully–featured, intuitive Database Manager! Utilize it in order to enjoy complete control of all your databases. You are able to effortlessly set up new MySQL and PgSQL databases and oversee them via the phpMyAdmin and phpPgAdmin software tools, respectively.
A Simple point and click User interface
The best database managing user interface
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.
Simple and easy Database Backup
Database backup copies are a click away
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.
Support for PgSQL
Assured protection for your databases
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.
The fresh new face of MySQL
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.
Detailed Database Stats
Comprehensive statistics for your databases
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.