MariaDB 10
MariaDB 10 is a community-developed fork of MySQL and is one of the most widely used open-source relational database management systems (RDBMS). It is highly compatible with MySQL and allows users to effortlessly migrate databases from MySQL to MariaDB 10. With MariaDB 10, you can easily and efficiently read, update, and manage your data.
Port Setting
You can modify the port number of MariaDB 10 directly on the user interface.
To set the port number:
Fill in the desired port number. Click Apply for the changes to take effect.
InnoDB Buffer Pool
The InnoDB buffer pool is key for caching data and indexes in MariaDB, significantly influencing its performance.
The buffer pool size defaults to 16 MB but can range from 10 MB to 20% of the system's total RAM by configuration. For models with less than 1 GB of RAM, the buffer pool size remains fixed at the default 16 MB. This setting determines the maximum memory allocation for database caching.
Back up and Restore
You can back up MariaDB 10 and restore it to a previous version via Hyper Backup.
To back up MariaDB 10:
- Go to Hyper Backup > Create > Data backup task to create a backup task.
- Follow the Backup Wizard, and choose MariaDB 10 when you are prompted to select applications to back up.
- After the backup task is complete, all the MariaDB 10 databases will be backed up.
To restore MariaDB 10:
- Go to Hyper Backup > Restore > Data to restore the desired backup task.
- After the restore task is complete, the current settings and data of MariaDB 10 will be overwritten.
Note:
- Mandatory backup and restoration will apply to all MariaDB 10 databases.
- Backup and restore operations will fail for database names containing a backslash (\) or backtick (`).