In the Host Q Site Control Panel you’ll find a full featured, convenient–to–use Databases Manager! Utilize it to enjoy full command over all of your databases. It is possible to very easily create new MySQL and PgSQL databases and manage them with the phpMyAdmin and phpPgAdmin software programs, respectively.
Clean and Uncomplicated Interface
Be in charge of all your databases from a single place
The Databases Manager inside our Site Control Panel provides a robust but straightforward interface. It is easy to configure a whole new MySQL or PostgreSQL database simply by specifying a user name and password. What’s more, you can make a back–up file or customize the password of a database with just a mouse click.
From the Databases Manager you will possess direct access to the admin area for each of your databases, so its possible to make easy alterations if you happen to need to.
Relatively easy Database Backup
Guard your database content with only a click of the mouse
If you have dealt with databases, you already know that generating a manual database back–up is not a basic job. As a way to change this, we have created a simple tool that can back up your entire database with just a single mouse click. The backup file will be prepared for you in under a minute, based on the size of the selected database.
There are not any limitations on just how many backup copies you may make for any specific database.
The most protected open source databases
Most of our Linux web hosting services plans provide PgSQL support. Whilst dropping behind MySQL with regards to level of popularity and utilization, PgSQL databases are famous for offering up the highest level of safety for your site content and articles. It is the reason why brands like Skype and Yahoo use PgSQL databases as an alternative to MySQL.
With regards to database administration, PgSQL is equally quick as MySQL.
The brand new face of MySQL
The MySQL databases on Host Q’s web servers utilize the latest version of the InnoDB storage engine. InnoDB has been designed to guarantee the highest performance for websites that deal with significant volumes of data. It offers CPU effectiveness that could not be matched by other different disk–based relational database engines.
InnoDB is ACID–compliant and grants complete transaction support, meaning that you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your application. At the same time, it works by using row–level locking and not MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.
Detailed Database Stats
Comprehensive stats for all your databases
Host Q offers you a straightforward technique to keep an eye on the database usage for your dynamic sites. Via the thorough database statistics interface, which is included in the Site Control Panel, you can track the load accumulated by your active web sites in real time. The supplied details will allow you to analyze the database load fluctuations on an hourly basis, on a daily basis or monthly.
You are able to keep an eye on the database load for all of your web sites from the Database Stats section of the Site Control Panel. The table on–screen presents the database queries accumulated during the present month. To look at data for a past month, all you have to do is click on the back arrows positioned at the top.