qinxm 发表于 2023-5-21 01:35:42

利用Ansible快速构建MGR,集群创建不成功

错误日志如下:


tailf /data/GreatSQL/error.log

2023-05-21T01:29:50.982142+08:00 0 Plugin group_replication reported: 'The member with address 192.168.137.13:3306 was declared online within the replication group.'
2023-05-21T01:30:50.641887+08:00 90 Aborted connection 90 to db: 'unconnected' user: 'repl' host: '192.168.137.13' (failed on flush_net()).
2023-05-21T01:30:50.641937+08:00 89 Aborted connection 89 to db: 'unconnected' user: 'repl' host: '192.168.137.12' (failed on flush_net()).


--ansible编排没有任何问题



yejr 发表于 2023-5-21 09:35:43

The member with address 192.168.137.13:3306 was declared online within the replication group

只看这条日志,看起来是健康的,没什么问题。
请提供更多详细日志,以及完整操作过程。

qinxm 发表于 2023-5-21 11:18:46

已经处理好了,解决方法如下:

--请不要提前设置环境变量,否则集群将会创建不成功
# cat /etc/profile.d/mysql.sh
#export PATH=/usr/local/GreatSQL-8.0.25-15-Linux-glibc2.17-x86_64-minimal/bin:$PATH

# source /etc/profile.d/mysql.sh

qinxm 发表于 2023-5-22 02:12:00

yejr 发表于 2023-5-21 09:35
The member with address 192.168.137.13:3306 was declared online within the replication group

只看这 ...

建议作者把epel源也加上,不然在编排jemelloc安装时出错

yejr 发表于 2023-5-22 09:58:36

qinxm 发表于 2023-5-22 02:12
建议作者把epel源也加上,不然在编排jemelloc安装时出错

jemalloc不是必须的,有最好,没有也行
页: [1]
查看完整版本: 利用Ansible快速构建MGR,集群创建不成功