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


Comments loading...