GreatSQL社区

搜索

[已解决] 利用Ansible快速构建MGR,集群创建不成功

489 4 2023-5-21 01:35
错误日志如下:


tailf /data/GreatSQL/error.log

2023-05-21T01:29:50.982142+08:00 0 [System] [MY-011492] [Repl] 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 [Note] [MY-010914] [Server] 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 [Note] [MY-010914] [Server] Aborted connection 89 to db: 'unconnected' user: 'repl' host: '192.168.137.12' (failed on flush_net()).


--ansible编排没有任何问题



全部回复(4)
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
已经处理好了,解决方法如下:

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

[root@mglinux01 ~]# 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不是必须的,有最好,没有也行
qinxm

3

主题

0

博客

21

贡献

新手上路

Rank: 1

积分
39

月度求知人物月度博学人物助人为乐(铜)

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

社区公众号
社区小助手
QQ群
GMT+8, 2024-4-27 16:41 , Processed in 0.016685 second(s), 12 queries , Redis On.
快速回复 返回顶部 返回列表