The Hepsia hosting Control Panel includes a full-featured database management GUI, which will give you complete authority over your databases. You can easily set up brand new MySQL and PostgreSQL DBs and manage their settings through the phpMyAdmin and phpPgAdmin software tools respectively.
An Easy-to-Use Interface
With the Database Manager interface, you can create a new database in seconds - just specify its name and that's all. You will notice a list of all your databases and their respective sizes. You will be able to alter passwords, to create database backup files and to even log in to the phpMyAdmin and phpPgAdmin database management tools.
Simple Database Backups
It is quite important to make routine backups of your databases to secure your web site content and to prevent any incidental data loss. With the Database Manager user interface, creating a database backup is very easy. Simply click on the Backup icon next to the database you want to back up and you will be immediately taken to the File Manager section from where you can download your newly created backup file.
MySQL and PgSQL Databases
The number of PostgreSQL and/or MySQL databases that you can set up differs based on the hosting plan that you have picked. While MySQL is a very popular database management system used by 1 000 000's of users around the globe, PostgreSQL is considered a more advanced database management system and is primarily utilized by technically competent website administrators. You can administer your MySQL DBs via the phpMyAdmin software tool, while PgSQL DBs can be administered via the phpPgAdmin software tool.
InnoDB is the leading storage engine for the MySQL DBMS, which is aimed at protecting user data and at increasing multiuser concurrency and performance. When you would like to create a new DB table, simply log in to the Hepsia Control Panel-incorporated phpMyAdmin database management tool and select the InnoDB storage engine from the list of available engines.
Hepsia's Database Manager also contains thorough stats about your databases, including the number of hourly queries. This will give you a clue about how much load is generated during a certain period.