Is it possible to replace MySQL with MariaDB and vice versa?

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. 

1. 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.
2. The procedure should be performed by a system administrator. If you need help, Plesk Professional Services can perform this task for you.
3. 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.