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
This article only describes the switch from MySQL to MariaDB, but not "vice versa". I think the headline does not match what the article suggests. Please either remove "vice versa" or explain the steps for MariaDB->MySQL.
Please sign in to leave a comment.