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