## Group Replication原理解析与实践经验 徐春阳 ## QCon 全球软件开发大会 10⽉17-19⽇上海·宝华万豪酒店  扫码锁定席位 ## 九 折即将结束 团购还享更多优惠，折扣有效期至9月17日 扫描右方二维码即可查看大会信息及购票 用户线程执行事务（sql）流程  group_replication_trans_before_commit 被唤醒后 将有关事务的日志写入到本地通道。后面的所有任务，例如，将这个事务日志利用paxos协议进行全局一致性广播，验证是否跟其他事务冲突 当心secondary节点变成可写节点 ## Group_replication_bootstrap_group参数须谨慎 规避大事务 DDL操作注意事项 ## Secondary节点变成可写节点 正常情况下，Single primary 模式下，secondary节点只读 不管my.cnf的read_only参数是如何设置， 当节点被执行stop group_replicaiton的命令后，节点马上变成可读写。

## Ozone User Group Summit Nov 10, 2022  We believe that data can make what is impossible today, possible tomorrow ## CLOUDERA don't reinvent the wheel • RAFT replication – http://raft.github.io Open source Java implementation of RAFT - Apache Ratis Library. • Storage Containers – Unit of replication (collection of blocks) . RocksDB backup ☐ Bucket Granularity • Replication and DR ☐ Stable source image for replication ☐ Efficient way to find changes since last replication ☐ Near continuous replication • Compliance • Easy Rollbacks

[Image](/uploads/documents/4/8/4/c/484c9d62390ce6f7d8cf5e435c4c269f/p5_1.jpg) • MySQL Replication 数据冗余存储 • Shared Storage • Group Replication • MySQL Cluster ## MySQL 复制工作流 二进制日志 会话 转储 中继日志  • Group Replication • MySQL Cluster # 主动 接管 共享 存储 被动 版权所有 2015, Oracle 和 / ## 适用于 MySQL 的 Oracle VM 模板 • 预安装且预配置

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 Initializing a Cassandra Cluster on Amazon EC2 Using the DataStax AMI 32 Creating an EC2 Security Group for DataStax Community Edition 33 Launching the DataStax Community AMI 34 Connecting to Your Cassandra

release notes Highlights: • Bug Fixes and improvements as usual • ARTEMIS-4136 Mirror sync replication Mirror now has an option to set sync=true. Blocking operations from clients will wait a round Mirror support improving capabilities on AMQP Mirror for Disaster Recovery • Journal Retention • Replication integrated with Zookeeper • Connection Routers • Concurrency configuration for core bridges. queues • AMQP Server Connectivity "Basic" SecurityManager implementation that supports replication • Consumer window size support for individual STOMP clients • Improved JDBC connection management

Greenplum资源管理器 姚珂男/Pivotal kyao@pivotal.io ## Agenda • Greenplum数据库 • Resource Queue • Resource Group ## Greenplum数据库 • 基于PostgreSQL • 分布式 • OLAP • MPP(Massively Parallel Processing) ## Greenplum数据库 没有严格资源隔离 – 第三方库的malloc ## Resource Group • SQL语句并发控制 => 事务并发控制 ·基于cost的并发控制 • 基于优先级的CPU控制 => 精确CPU比例 • 内存控制 => 严格资源隔离 ## Running Example • CREATE RESOURCE Group rg WITH ( concurrency=1, memory_limit=.6, memory_redzone_limit=.7 ); • CREATE ROLE r1 RESOURCE GROUP rg; • SELECT * FROM gp_toolkit.gp_resgroup_status; ## Resource Group ## • Deadlock – 事务开始时拿slot - Self-deadlock - 事务结束时一定会释放slot

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 ... 102 3. Push-based metrics system ..... 102 Monitoring with Kubernetes ..... 102 Replication ..... 102 Semi-Sync ..... 102 Database Schema Considerations ..... 103 Point In Time

PostgreSQL Global Development Group #### PostgreSQL 9.0.22 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2015 The PostgreSQL Global Development Group ## Legal Notice PostgreSQL PostgreSQL is Copyright © 1996-2015 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright © 1994-5 by the Subqueries ..... 88 7.2.1.4. Table Functions ..... 88 7.2.2. The WHERE Clause ..... 89 7.2.3. The GROUP BY and HAVING Clauses ..... 90 7.2.4. Window Function Processing ..... 92 7.3. Select Lists .

Mirror support improving capabilities on AMQP Mirror for Disaster Recovery • Journal Retention • Replication integrated with Zookeeper • Connection Routers • Concurrency configuration for core bridges. queues • AMQP Server Connectivity "Basic" SecurityManager implementation that supports replication • Consumer window size support for individual STOMP clients • Improved JDBC connection management to use FQON syntax for both security-settings and JNDI lookup • Support pausing dispatch during group rebalance (to avoid potential out-of-order consumption) • Socks5h support #### 2.14. 0 Full release

Mirror support improving capabilities on AMQP Mirror for Disaster Recovery • Journal Retention • Replication integrated with Zookeeper • Connection Routers • Concurrency configuration for core bridges. queues • AMQP Server Connectivity "Basic" SecurityManager implementation that supports replication • Consumer window size support for individual STOMP clients • Improved JDBC connection management to use FQQN syntax for both security-settings and JNDI lookup - Support pausing dispatch during group rebalance (to avoid potential out-of-order consumption) • Socks5h support #### 2.14. 0 Full release