Upgrading from MySQL 5.7 to MariaDB 10.2

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}