33061端口没有监听

MGR要启动起来才会监听33061端口

部署MGR请跟着这份手册走 https://greatsql.cn/docs/8.0.32- ... install-deploy.html 有问题提供错误日志等

KAiTO 发表于 2024-9-23 14:54
部署MGR请跟着这份手册走 https://greatsql.cn/docs/8.0.32-26/8-mgr/2-mgr-install-deploy.html 有问题提 ...

主库start group_replication;成功。
从库start group_replication;失败。
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

主要日志错误：
.。。。
2024-09-23T15:00:47.259201+08:00 0 [ERROR] [MY-011526] [Repl] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: 98425a04-795d-11ef-b785-000c29a17bea:1 > Group transactions: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1:1-3, d8a7617e-7955-11ef-976d-000c298411fc:1'
2024-09-23T15:00:47.259257+08:00 0 [ERROR] [MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.'

。。。

my666666 发表于 2024-9-23 15:03
主库start group_replication;成功。
从库start group_replication;失败。
ERROR 3092 (HY000): The serv ...

报错很明显了，看错误日志显示“此成员执行的事务比组中存在的事务多”[1]
在操作的时候，手册操作中有使用 set session sql_log_bin=0; 目的就是为了防止这个问题。
解决方法
如果都是空实例
直接清空PRIMARY 和 SECONDARY 节点 reset master
然后PRIMARY 节点在起set global group_replication_bootstrap_group=ON;  start group_replication;
接着SECONDARY 节点start group_replication;

如果有数据，要用克隆的方式解决

[1]：FAQ - MGR运维部署 | GreatSQL用户手册