20 MoveTables ..... 20 Identifying Candidate Tables ..... 20 Query Rewriting ..... 20 Replication Graph ..... 25 Shard ..... 25 Shard Naming ..... 25 Resharding ..... 26 Tablet ..... 26 project ..... 90 Scalability Philosophy ..... 90 Small instances ..... 90 Durability through replication ..... 91 Consistency model ..... 91 Multi-cell ..... 92 Supported Databases ..... 92 MySQL 3. Push-based metrics system ..... 102 Monitoring with Kubernetes ..... 102 Replication ..... 102 Semi-Sync ..... 102 Database Schema Considerations ..... 103 Point In Time Recovery

## Group Replication原理解析与实践经验 徐春阳 ## QCon 全球软件开发大会 10⽉17-19⽇上海·宝华万豪酒店  扫码锁定席位 ## 九 折即将结束 团购还享更多优惠，折扣有效期至9月17日 扫描右方二维码即可查看大会信息及购票 报名时间：9月1日-9月15日 扫描添加E小欧， 邀您进入EGO会员预报名群 立即报名 TECHNOLOGY EGO ## TABLE OF CONTENTS ## MGR原理 MGR vs SEMI-SYNC MRG实践经验 ## MGR的主要特点: - 支持多节点并发执行事务。如何保证从各个节点并发执行的事务在每个节点以相同的顺序被应用/执行.------paxos协议的功能。 - 自动地 用户线程执行事务（sql）流程  group_replication_trans_before_commit 被唤醒后 将有关事务的日志写入到本地通道。后面的所有任务，例如，将这个事务日志利用paxos协议进行全局一致性广播，验证是否跟其他事务冲突等全部

ID ..... 11 Keyspace ..... 11 MoveTables ..... 11 Identifying Candidate Tables ..... 11 Replication Graph ..... 11 Shard ..... 12 Shard Naming ..... 12 Resharding ..... 12 Tablet ..... 12 project ..... 36 Scalability Philosophy ..... 36 Small instances ..... 36 Durability through replication ..... 37 Consistency model ..... 37 Multi-cell ..... 38 Supported Databases ..... 38 MySQL Types ..... 45 Auto Increment ..... 45 Extensions to MySQL Syntax ..... 45 MySQL Replication ..... 46 Semi-Sync ..... 46 Database Schema Considerations ..... 47 Schema Management ..... 47 Reviewing

... 9 Partitions ..... 9 Served From ..... 9 Keyspace ID ..... 10 Keyspace ..... 10 Replication Graph ..... 10 Shard ..... 10 Resharding ..... 10 Tablet ..... 10 Tablet Types ..... 11 project ..... 44 Scalability Philosophy ..... 44 Small instances ..... 44 Durability through replication ..... 44 Consistency model ..... 45 Multi-cell ..... 46 Supported Databases ..... 46 Vitess Data Types 53 Auto Increment 53 Extensions to MySQL Syntax 53 MySQL Replication 54 Semi-Sync 54 Database Schema Considerations 54 Schema Management 55 Reviewing your

ID ..... 12 Keyspace ..... 12 MoveTables ..... 12 Identifying Candidate Tables ..... 13 Replication Graph ..... 13 Shard ..... 13 Shard Naming ..... 13 Resharding ..... 14 Tablet ..... 14 project ..... 42 Scalability Philosophy ..... 42 Small instances ..... 42 Durability through replication ..... 42 Consistency model ..... 42 Multi-cell ..... 43 Supported Databases ..... 44 MySQL 48 Purging 48 Advanced usage 49 Undocumented features 49 Known limitations 49 Replication 49 Semi-Sync 49 Database Schema Considerations 50 Schema Management 50 Reviewing your schema 51

19 MoveTables ..... 19 Identifying Candidate Tables ..... 19 Query Rewriting ..... 19 Replication Graph ..... 24 Shard ..... 24 Shard Naming ..... 24 Resharding ..... 25 Tablet project ..... 81 Scalability Philosophy ..... 81 Small instances ..... 81 Durability through replication ..... 81 Consistency model ..... 81 Multi-cell ..... 82 Supported Databases ..... 83 MySQL 92 3. Push-based metrics system ..... 92 Monitoring with Kubernetes ..... 92 Replication ..... 92 Semi-Sync ..... 93 Database Schema Considerations ..... 93 Point In Time Recovery ..... 93

20 MoveTables ..... 20 Identifying Candidate Tables ..... 20 Query Rewriting ..... 21 Replication Graph ..... 25 Shard ..... 25 Shard Naming ..... 25 Resharding ..... 26 Tablet ..... 26 a CNCF project .54 Scalability Philosophy .54 Small instances ..... 54 Durability through replication ..... 54 Consistency model ..... 54 Multi-cell ..... 55 Supported Databases ..... 56 MySQL Advanced usage ..... 61 Undocumented features ..... 61 Known limitations ..... 61 Replication ..... 61 Semi-Sync ..... 61 Database Schema Considerations ..... 62 Point In Time Recovery ..... 62

21 MoveTables ..... 21 Identifying Candidate Tables ..... 21 Query Rewriting ..... 22 Replication Graph ..... 26 Shard ..... 26 Shard Naming ..... 26 Resharding ..... 27 Tablet project ..... 95 Scalability Philosophy ..... 95 Small instances ..... 95 Durability through replication ..... 95 Consistency model ..... 95 Multi-cell ..... 96 Supported Databases ..... 97 MySQL metrics system 111 3. Push-based metrics system 111 Monitoring with Kubernetes 112 Replication 112 Semi-Sync 112 Database Schema Considerations 113 Point In Time Recovery 113 Point in Time Recovery

Partitioner Types 12 About the Random Partitioner 12 About Ordered Partitioners 13 About Replication in Cassandra 13 About Replica Placement Strategy 14 SimpleStrategy 14 NetworkTopologyStrategy Partitioner Settings 25 Snitch Settings 26 Configuring the PropertyFileSnitch 26 Choosing Keyspace Replication Options 27 Installing and Initializing a Cassandra Cluster 27 Installing Cassandra Using the Cluster 95 Calculating Tokens For the New Nodes 96 Adding Nodes to a Cluster 96 Changing the Replication Factor 97 Replacing a Dead Node 97 Backing Up and Restoring Data 98 Taking a Snapshot 98

23 MoveTables ..... 23 Identifying Candidate Tables ..... 24 Query Rewriting ..... 24 Replication Graph ..... 28 Shard ..... 28 Shard Naming ..... 29 Resharding ..... 29 Tablet project ..... 114 Scalability Philosophy ..... 114 Small instances ..... 114 Durability through replication ..... 115 Consistency model ..... 115 Multi-cell ..... 116 Supported Databases ..... 116 Resharding ..... 147 Tablet throttler ..... 147 Why throttler: maintaining shard health via low replication lag ..... 147 Throttler overview ..... 148 Custom metrics & queries ..... 149 Configuration