基于MGR的强一致性数据库介绍

1、基于MGR的读写强一致性数据库介绍技术创新 变革未来目录现实问题写一致性读一致性规划和展望Whats the reality ?PART ONE1现实中的交易场景2Write ConsistencyPART TWO数据库模型分布式数据库的核心能力0102050304ClusterMultiple replicas01. Scalability弹性的扩展能力05. Availability保证99.99%的可用性02. Fault-Tolerant可以容忍实例、机器、存储 和网络的异常03. Write Consistency数据一旦写入成功， 不会丢失04. Read Consistency保

2、证数据读取的线性一致 性分布式数据库的核心能力写一致性Replicated State MachineConsensus Protocol为什么选择MySQL Group ReplicationMGRMySQL Group Replication01. Consensus ProtocolMencious (Paxos variant) 保证线性一致性全局同序处理03. Multiple Primary多点写入 提升可用性02. Stability官方支持 社区生态完善04. Focus读取的线性一致性 完善一致性语义为什么选择MySQL Group Replication3Read Cons

3、istencyPART THREEMGR的架构和复制方式读一致性read-your-writes consistencymonotonic-readsconsistent prefix reads01. Proxy Route通过Proxy流量 调度的方式W + R NDrawer Principle02. Read convert Write读转换为写 走一遍Paxos协议记录写入点 读取时携带写入点推进到写入点后下放读 HOW03. Quonum Read04 Read with Write-Point05 all sync + read wait until commit读一致性读一致性

4、读一致性ConclusionMake simpleappear as only one copy of data日志的一致性性能20000180001600014000120001000080006000400020000Throughput (tx per second)Single-Pirmary Throughput: Sysbench OLTP RW 1 IDC050000100000150000Throughput (tx per second)Single-Pirmary Throughput: Sysbench OLTP RO 1 IDC140001200010000800060

5、00400020000Throughput (tx per second)Group ReplicationConsistent ReadSingle-Pirmary Throughput: Sysbench OLTP RW 2 IDCGroup ReplicationConsistent Read020000400006000080000100000120000Throughput (tx per second)Group ReplicationConsistent ReadSingle-Pirmary Throughput: Sysbench OLTP RO 2 IDCGroup ReplicationConsistent Read最佳实践内存使用冲突检测库，在途事务，恢复时对增量数据的缓存 Paxos消息缓存，writesets开销节点管理失败节点重新加入3+1容灾读一致性错误节点摘除读流量开启流量控制、大事务限制4BlueprintPART FOUR规划和展望Optimization冲突检测库的gc优化 内存容量管理writesets版本Multiple Primary多写试点整合一致性读 跨机房优化Enhance Consistency Read优化性能 提前回放 版本管理Port with MySQL 8.0.14一致性增