MySQL-8.0.18 引入了破坏性变更
变更日志里面有这样一项
When the server is run with --initialize, there is no reason to load non-early plugins. The server now logs a warning and ignores
any--plugin-load or --plugin-load-add options given with --initialize. (Bug #29622406)
也就是说当我们在做初始化的时,像半同步插件这样的非必要插件是不会被加载的,一旦我们在配置文件中加入了相应的配置项,整个初始化就会失败。
场景再现
配置文件(关键部分)
[mysqld]## replication
rpl_semi_sync_master_enabled= 1rpl_semi_sync_slave_enabled= 1rpl_semi_sync_master_timeout= 1000rpl_semi_sync_master_wait_point=AFTER_SYNC
rpl_semi_sync_master_wait_no_slave=ON
rpl_semi_sync_master_wait_for_slave_count= 1master_info_repository=table
sync_master_info= 10000skip_slave_start=OFF
slave_load_tmpdir=/tmp/
plugin_load_add=semisync_master.so
plugin_load_add= semisync_slave.so
初始化命令
/