The Hepsia hosting Control Panel includes a full-featured database administration graphical user interface, which will give you full command over your databases. You can easily create brand new MySQL and PostgreSQL DBs and administer their content through the phpMyAdmin and phpPgAdmin tools respectively.
With the Database Manager GUI, you can create a brand new DB in a matter of seconds - simply fill in its name and that's all. You will see a list of all your DBs and their respective sizes. You will be able to modify passwords, to create backup files and to even log into the phpMyAdmin and phpPgAdmin database administration tools.
It is very essential to make periodic backups of your DBs to secure your website content and to steer clear of any incidental loss of data. With the Database Manager graphical user interface, creating a database backup is very easy. Simply press the Backup button next to the database you want to back up and you will be instantly taken to the File Manager from where you can download your newly created backup file.
The number of PostgreSQL and/or MySQL databases that you can set up varies based on the hosting plan that you have selected. While MySQL is a very popular database management system employed by 1 000 000's of users around the globe, PostgreSQL is thought of as being a more advanced database management system and is primarily utilized by technically accomplished website administrators. You can manage your MySQL DBs through the phpMyAdmin tool, while PostgreSQL DBs can be administered through the phpPgAdmin tool.
InnoDB is the leading database engine for the MySQL database management system, which is aimed at securing user data and at enhancing multi-user concurrency and performance. When you need to create a new DB table, simply log into the Hepsia hosting Control Panel-integrated phpMyAdmin database management tool and pick the InnoDB storage engine from the list of available database engines.
Hepsia's Database Manager also includes elaborate stats about your databases, including the number of hourly queries. This will give you a clue about how much load is created over a given period.