GreatSQL社区

搜索

[已解决] 停止了主库后,从库绑定VIP后又解绑了VIP导致没有VIP

250 5 2024-7-17 20:56
GreatSQL 8.0.32-25,这个是从库的日志



VIP配置:

plugin-load-add = "greatdb_ha.so"
loose-group_replication_single_primary_mode = ON
loose-group_replication_enforce_update_everywhere_checks = 0
loose-greatdb_ha_enable_mgr_vip = ON
loose-greatdb_ha_mgr_vip_ip = "192.168.0.100"
loose-greatdb_ha_mgr_vip_mask = "255.255.255.0"
loose-greatdb_ha_mgr_vip_nic = "eno0"
loose-greatdb_ha_port = 33062
loose-greatdb_ha_mgr_read_vip_ips = "192.168.0.100"
loose-greatdb_ha_mgr_read_vip_floating_type = "TO_ANOTHER_SECONDARY"
loose-greatdb_ha_send_arp_packge_times = 5

全部回复(5)
yejr 2024-7-17 22:05:38
loose-greatdb_ha_mgr_vip_ip = "192.168.0.100"
loose-greatdb_ha_mgr_read_vip_ips = "192.168.0.100"

读写VIP设置成相同导致的,请把这两个VIP设置为不同
zjf440222 2024-7-18 09:03:16
本帖最后由 zjf440222 于 2024-7-18 09:10 编辑
yejr 发表于 2024-7-17 22:05
loose-greatdb_ha_mgr_vip_ip = "192.168.0.100"
loose-greatdb_ha_mgr_read_vip_ips = "192.168.0.100"

设置不同后,两个VIP都解绑了
2024-07-18T09:00:40.808321+08:00 34 [System] [MY-011510] [Repl] Plugin group_replication reported: 'This server is working as primary member.'
2024-07-18T09:00:40.808325+08:00 12 [Note] [MY-011485] [Repl] Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection.'
2024-07-18T09:00:41.384748+08:00 0 [Warning] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.0.100 success'
2024-07-18T09:00:41.994712+08:00 0 [Warning] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to bind vip : 192.168.0.101 success'
2024-07-18T09:00:42.002257+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'kill connections binding to vip: 192.168.0.100'
2024-07-18T09:00:42.002648+08:00 0 [Warning] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to unbind vip : 192.168.0.100 success'
2024-07-18T09:00:42.007549+08:00 0 [ERROR] [MY-000000] [Server] Plugin greatdb_ha reported: 'kill connections binding to vip: 192.168.0.101'
2024-07-18T09:00:42.007723+08:00 0 [Warning] [MY-000000] [Server] Plugin greatdb_ha reported: 'try to unbind vip : 192.168.0.101 success'
yejr 2024-7-18 10:57:05
zjf440222 发表于 2024-7-18 09:03
设置不同后,两个VIP都解绑了
2024-07-18T09:00:40.808321+08:00 34 [System] [MY-011510] [Repl] Plugin  ...

请补充几个信息
1. MGR的详细配置
2. 各成员节点的拓扑结构
3. 如何切换,执行了哪些动作,预期结果是什么,实际结果是什么
zjf440222 2024-7-18 20:40:32
yejr 发表于 2024-7-18 10:57
请补充几个信息
1. MGR的详细配置
2. 各成员节点的拓扑结构

我知道什么问题了,是我的/etc/hosts ip和节点配置错了
yejr 2024-7-18 21:11:15
zjf440222 发表于 2024-7-18 20:40
我知道什么问题了,是我的/etc/hosts ip和节点配置错了

好的,找到原因就好
如果还有其他问题还请提供更详细信息才好排查哈
zjf440222

2

主题

0

博客

6

贡献

新手上路

Rank: 1

积分
10

合作电话:010-64087828

社区邮箱:greatsql@greatdb.com

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