digoal
2024-03-11
PostgreSQL , PolarDB , DuckDB , Spock , Multi-Master , 逻辑复制
https://github.com/pgedge/spock
Spock
Multi-Master Replication with Conflict Resolution & Avoidance
This SPOCK extension provides multi-master replication for PostgreSQL 14+ We leveraged the BDR2 Open Source project as a solid foundation to build upon for this enterprise-class extension.
Our production version is 3.2 and includes the following important enhancements beyond Spock 3.1:
- Support for pg14
- Support for pg17devel
- Support for Snowflake Sequences
- Support for setting a database to ReadOnly
- Prelim support for Hidden Columns
- A couple small bug fixes from pgLogical
- Native support for Failover Slots via integrating pg_failover_slots extension
参考:
- 《PostgreSQL 16 devel preview - 内部multi-master多主逻辑复制: 防重复复制、防数据打环无限复制能力》
- 《DB吐槽大会,第57期 - PG multi-master 支持不友好》
- 《PostgreSQL multi-master 逻辑集群 - krahodb》
- 《双向复制,多向复制,multi-master - 多主 - 多写 - 如何在多写中避免数据复制打环(死循环)》
- 《使用PostgreSQL逻辑订阅实现multi-master》
- 《表级复制(base on trigger) -- PostgreSQL general sync and async multi-master replication trigger function》
- 《表级复制(base on trigger) -- multi master replication & performance tuning》