kb: how-to
Plesk Obsidian for Linux
Applicable to:
- Plesk Obsidian for Linux
Question
Is it possible to replace MySQL with MariaDB and vice versa?
Answer
Yes, it is possible to replace MySQL with MariaDB. MariaDB is considered to be a drop-in replacement for the corresponding MySQL version (i.e MariaDB 10.2 and MySQL 5.7). The vice versa replacement, MariaDB to MySQL is also possible.
- Please review feature differences between MariaDB and MySQL to make sure the switch won't affect applications using database server. If application installation requirements mention that both MySQL/MariaDB are supported like WordPress for example, switch should not make any harm.
- The procedure should be performed by a system administrator. If you need help, Plesk Professional Services can perform this task for you.
- For steps to perform a switch please refer to our blog article MySQL Vs MariaDB – Can One Replace The Other?
NOTE: If it is required to have the different database server type for customers databases, the recommended solution is to use a Docker container to host separate MySQL or MariaDB instance in Plesk and add it as and external SQL database server using IP address 127.0.0.1 and the external Docker port.
Comments
1 comment
We did this, upgraded to the newest Version and we get now an Backup Error. Everything else works.
Unfortunately there is no documentation on how to update your command.
Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: mysqldump: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-dump' instead
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'XXX_DB'': Cannot load from mysql.proc. The table is probably corrupted (1728)
Please sign in to leave a comment.