ERROR 1123 (HY000): Can't initialize function 'group_replication'; Plugin initialization function fa

最新推荐文章于 2024-05-25 22:39:17 发布

原创

最新推荐文章于 2024-05-25 22:39:17 发布 · 5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #MGR #Group Replication

MySQL Group Replication安装group_replication.so报错

mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
ERROR 1123 (HY000): Can't initialize function 'group_replication'; Plugin initialization function failed.

mysql版本5.7.24，支持Group Replication功能，plugin目录中存在"group_replication.so"文件

[root@node1 logs]# ls -rtlh /app/mysql5.7/lib/plugin/ | grep group*
-rwxr-xr-x. 1 mysql mysql  21M May 17 16:06 group_replication.so

查看日志node.err

2019-05-21T08:39:24.050325Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-21T08:39:24.050480Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-05-21T08:39:24.050545Z 0 [Note] /app/mysql5.7/bin/mysqld (mysqld 5.7.24) starting as process 11564 ...
2019-05-21T08:39:24.108727Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-05-21T08:39:24.108774Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-05-21T08:39:24.108782Z 0 [Note] InnoDB: Uses event mutexes
2019-05-21T08:39:24.108789Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-05-21T08:39:24.108796Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-21T08:39:24.108803Z 0 [Note] InnoDB: Using Linux native AIO
2019-05-21T08:39:24.109331Z 0 [Note] InnoDB: Number of pools: 1
2019-05-21T08:39:24.109540Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-05-21T08:39:24.112278Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2019-05-21T08:39:24.168366Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-05-21T08:39:24.178496Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-05-21T08:39:24.209811Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-21T08:39:24.269905Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-05-21T08:39:24.269987Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-05-21T08:39:24.325815Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-05-21T08:39:24.326728Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-05-21T08:39:24.326745Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-05-21T08:39:24.327934Z 0 [Note] InnoDB: 5.7.24 started; log seque