The Hepsia web hosting Control Panel includes a full-featured database administration interface, which will grant you total command over your databases. You can easily create brand new MySQL and PostgreSQL databases and manage them through the phpMyAdmin and phpPgAdmin database management tools respectively.
An Easy-to-Use Interface
With the Database Manager user interface, you can set up a new DB in a matter of seconds - just specify its name and that's it. You will notice a list of all your DBs and their corresponding sizes. You will be able to change passwords, to create backups and to even log in to the phpMyAdmin and phpPgAdmin database management tools.
Simple Database Backups
It is quite essential to create routine backups of your databases to protect your website content and to steer clear of any unexpected data loss. With the Database Manager user interface, creating a database backup is very easy. Simply click the Backup button next to the database you wish to back up and you will be instantly taken to the File Manager from where you can download your freshly created backup file.
MySQL and PgSQL Databases
The number of PostgreSQL and/or MySQL databases that you can set up differs depending on the web hosting plan that you have picked. While MySQL is a very famous database management system used by 1 000 000's of users all over the globe, PostgreSQL is thought of as being a more innovative database management system and is chiefly used by technically knowledgeable webmasters. You can manage your MySQL databases via the phpMyAdmin software tool, whereas PostgreSQL DBs can be administered through the phpPgAdmin tool.
InnoDB is the leading transactional storage engine for MySQL, which is aimed at protecting user data and at enhancing multi-user concurrency and performance. When you wish to create a new database table, just log in to the Hepsia Control Panel-integrated phpMyAdmin database management tool and choose the InnoDB storage engine from the list of available storage engines.
Hepsia's Database Manager section also contains comprehensive statistics about your DBs, including the amount of hourly queries. This will give you a clue about how much load is created over a specific period of time.