MySQL Forums
Forum List  »  Chinese

mysql mgr新成员加入组问题之新成员无法通过二进制日志从其它可用成员同步数据
Posted by: liu my
Date: August 06, 2023 02:21PM

1、我原来只有一个数据库服务A,通过执行数据备份同时刷新二进制日志。
mysqldump --single-transaction --flush-logs --master-data=2 --all-databases > backup_date.sql
这时刷新后的binlog日志名称为mysql000010,位置323,备份后的数据变动都在该新biglog文件后。
然后配置相关mysql mgr变量,A服务作为引导启动,并且启动成功。
2、搭建数据库服务B,并且配置mysql mgr组复制相关配置,导入刚从数据库服务A的备份。清除日志。启动组复制,报错“Plugin group_replication reported: 'This member will start distributed recovery using clone. It is due to no ONLINE member has the missing data for recovering in its binary logs.'” 数据库服务B的组复制中的分布式恢复从数据库服务A的bin.000001 文件开始恢复数据,但数据库服务A这个对应的二进制文件已经转移到其它库了,并且数据库服务B也不需要从bin.000001开始恢复数据,而是需要从这个备份数据后的新二进制文件开始从组中其他成员恢复数据,请问如何解决这个问题?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql mgr新成员加入组问题之新成员无法通过二进制日志从其它可用成员同步数据
1117
August 06, 2023 02:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.