Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

rbr模式冷备设计 #12

Open
jd-zhang opened this issue Apr 19, 2022 · 1 comment
Open

rbr模式冷备设计 #12

jd-zhang opened this issue Apr 19, 2022 · 1 comment

Comments

@jd-zhang
Copy link
Contributor

Issue migrated from trac ticket # 590

component: DBA GUI | priority: major

2022-04-19 18:04:44: barney created the issue


  1. shard主备切换时,如果选的新主为冷备节点,需要先执行sql将冷备关闭,然后在将该节点设置为主
  2. 如果主备切换后,冷备节点发生变化,需要重新调用xtrabackup生成冷备
  3. 主备切换或者shard搭建后,根据配置(即备机延迟小于多少时)选延迟小备机为冷备节点
  4. 如果备机延迟一直很大,需要前台通过元数据表获取延迟信息告警。
@jd-zhang
Copy link
Contributor Author

2022-04-19 18:08:47: snow@zettadb.com commented


MySQL 上执行 set global binlog_backup_open_mode = on/off; 标识开启或者关闭 binlog 流式备份。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant