Upgrading from MySQL 5.7 to MariaDB 10.2

Outdated page regarding migrating from MySQL to MariaDB Server. While potentially outdated, these resources may offer historical context or insights for specific scenarios.

Following compatibility report was done on 10.2.4 and may get some fixing in next minor releases

• MySQL unix socket plugin can be different. MariaDB can get similar usage via INSTALL PLUGIN unix_socket SONAME 'auth_socket.so'; you may have to enable this plugin in config files via load plugin.

• When using data type JSON , one should convert type to TEXT, virtual generated column works the same after.

• When using InnoDB FULLTEXT index one should not use innodb_defragment

• MySQL re-implemented partitioning in 5.7, thus you cannot perform in-place upgrades for partitioned tables. They will require mysqldump/import to work correctly in MariaDB.

_{This page is licensed: CC BY-SA / Gnu FDL}