The Hepsia web hosting Control Panel offers a full-featured database administration GUI, which will give you complete command over your databases. You can easily create new MySQL and PostgreSQL databases and manage them through the phpMyAdmin and phpPgAdmin software tools respectively.
An Easy-to-Use Interface
With the Database Manager user interface, you can create a new database 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 alter passwords, to create backup files and to even log in to the phpMyAdmin and phpPgAdmin tools.
Simple Database Backups
It is very essential to make routine backups of your databases to secure your website content and to avoid any unexpected loss of data. With the Database Manager GUI, creating a database backup file is very easy. Just click the Backup button next to the database you would like to back up and you will be immediately taken to the File Manager from where you can download your newly created database backup file.
MySQL and PgSQL Databases
The number of PostgreSQL and/or MySQL databases that you can create differs depending on the hosting plan that you have selected. While MySQL is a very famous database management system employed by 1 000 000's of individuals all around the world, PostgreSQL is regarded as being a more innovative database management system and is mostly utilized by technically proficient webmasters. You can manage your MySQL databases through the phpMyAdmin software tool, whereas PostgreSQL databases can be managed via the phpPgAdmin software tool.
InnoDB is the leading transactional storage engine for the MySQL DBMS, which is aimed at securing users' data and at enhancing multi-user concurrency and performance. When you want to create a new DB table, simply log into the Hepsia hosting Control Panel-incorporated phpMyAdmin database management tool and choose the InnoDB storage engine from the list of available storage engines.
Hepsia's Database Manager also comprises elaborate statistics about your DBs, including the number of hourly database queries. This will give you a clue about how much load is created during a certain time period.