Improving MySQL® Cluster Uptime: Designing Advanced Detection, Mitigation, and Consensus with Group Replication

Improving MySQL® Cluster Uptime: Designing Advanced Detection, Mitigation, and Consensus with Group Replication

摘要

Uber采用MySQL Group Replication（MGR）构建高可用数据库集群，通过三节点共识组实现秒级故障切换，解决旧架构依赖外部系统、恢复慢的问题。新方案利用Paxos协议确保数据强一致性，内置流量控制防止节点过载，读写分离设计使读性能无损。基准测试显示写入延迟仅增加微秒级，但故障恢复时间从2分钟缩短至10秒内，显著提升服务可靠性。单主模式简化了冲突处理，更适合Uber的业务场景。