The Hepsia Control Panel comprises a full-featured database administration GUI, which will give you full command over your databases. You can easily set up new MySQL and PostgreSQL DBs and administer their content through the phpMyAdmin and phpPgAdmin tools respectively.
With the Database Manager, you can set up a new DB in no time - simply specify its name and that's it. You will notice a list of all your databases and their corresponding sizes. You will be able to alter passwords, to create database backups and to even log in to the phpMyAdmin and phpPgAdmin software tools.
It is quite essential to make frequent backups of your databases to protect your website content and to steer clear of any accidental data loss. With the Database Manager user interface, creating a database backup file is extremely easy. Just press the Backup button next to the database you wish to back up and you will be immediately taken to the File Manager from where you can download your newly created backup file.
The number of PgSQL and/or MySQL DBs that you can set up differs depending on the web hosting plan that you have picked. While MySQL is a very popular database management system employed by 1 000 000's of users all over the globe, PostgreSQL is regarded as being a more advanced database management system and is mainly employed by technically proficient webmasters. You can manage your MySQL databases via the phpMyAdmin tool, whereas PostgreSQL DBs can be managed through the phpPgAdmin tool.
InnoDB is the leading storage engine for the MySQL DBMS, which is aimed at securing users' data and at enhancing multi-user concurrency and performance. When you need to create a new database table, simply log into the Hepsia hosting Control Panel-integrated phpMyAdmin database administration tool and select the InnoDB storage engine from the list of available engines.
Hepsia's Database Manager section also includes thorough stats about your DBs, including the amount of hourly queries. This will give you a clue about how much load is generated during a specific time period.