暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

万里数据库GreatDB集中式故障诊断:组复制问题处理-9

原创 Dbb 2024-03-01
40

集群初始化及脑裂问题-3



connect 13000: greatdb> set global group_replication_group_name='11223344-1122-1122-1122-112233445566'; Query OK, 0 rows affected (0.00 sec) greatdb> set global group_replication_local_address='127.0.0.1:33060'; Query OK, 0 rows affected (0.00 sec) greatdb> set global group_replication_group_seeds='127.0.0.1:33060,127.0.0.1:33061,127.0.0.1:33062'; Query OK, 0 rows affected (0.00 sec) greatdb> SET GLOBAL group_replication_bootstrap_group=ON; Query OK, 0 rows affected (0.00 sec) greatdb> start group_replication; Query OK, 0 rows affected (3.09 sec) greatdb> SET GLOBAL group_replication_bootstrap_group=OFF; Query OK, 0 rows affected (0.00 sec) connect 13001: greatdb> set global group_replication_group_name='11223344-1122-1122-1122-112233445566'; Query OK, 0 rows affected (0.00 sec) greatdb> set global group_replication_local_address='127.0.0.1:33061'; Query OK, 0 rows affected (0.00 sec) greatdb> set global group_replication_group_seeds='127.0.0.1:33060,127.0.0.1:33061,127.0.0.1:33062'; Query OK, 0 rows affected (0.00 sec) greatdb> SET GLOBAL group_replication_bootstrap_group=ON; Query OK, 0 rows affected (0.00 sec) greatdb> start group_replication; Query OK, 0 rows affected (3.27 sec) greatdb> SET GLOBAL group_replication_bootstrap_group=OFF; Query OK, 0 rows affected (0.00 sec) +-------------+-------------+--------------+-------------+ | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | +-------------+-------------+--------------+-------------+ | 127.0.0.1 | 13001 | ONLINE | PRIMARY | +-------------+-------------+--------------+-------------+ 1 row in set (0.02 sec) 重新 connect 13000: greatdb> SELECT MEMBER_HOST,MEMBER_PORT,MEMBER_STATE,MEMBER_ROLE FROM performance_schema.replication_group_members; +-------------+-------------+--------------+-------------+ | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | +-------------+-------------+--------------+-------------+ | 127.0.0.1 | 13000 | ONLINE | PRIMARY | +-------------+-------------+--------------+-------------+ 1 row in set (0.00 sec)
复制

当出现脑裂问题时,会导致数据的异常行为,避免脑裂问题的关键是需要保证 group_replication_bootstrap_group 参数在初始化集群后处于 OFF 状态。

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

文章被以下合辑收录

评论