Choosing a logical replication system: Slony vs Bucardo

on YouTube ↗47m

" summary

Slony implements a serialized, trigger-driven event log and enforces replica immutability with deny-write triggers on replicas, plus useful features like cascaded subscriptions and scripted, serialized DDL and formal failover. Bucardo runs a single daemon, records only keys not full tuples so it uses primary-key-only delta logging and allows writable targets; Bucardo 5 adds true multimaster so (multimaster in Bucardo 5 (beta)) is real. A migration from Slony/Postgres 8.2 to a Postgres 9 streaming cluster using Bucardo finishes with minutes of downtime and works.

AI-written summary · about

" chapters (41)

1. 0:00Introduction
2. 0:27Overview
3. 0:49Start up
4. 1:07Replication in general
5. 1:28Physical vs logical replication
6. 2:58Physical replication benefits
7. 4:37Logical replication
8. 6:03Limitations of logical replication
9. 7:04Masterslave replication
10. 8:56Node paths
11. 11:08Subscriptions
12. 11:35Cascaded subscriptions
13. 12:33Slony triggers
14. 15:05Bucardo
15. 15:59Bucardo strengths
16. 17:04Bucardo limitations
17. 19:23Bucardo v
18. 19:55Bucardo use cases
19. 21:46Bucardo terminology
20. 22:46Bucardo architecture
21. 25:01Bucardo multimaster
22. 26:32Bucardo masterslave
23. 27:29Custom selects
24. 28:11Comparisons
25. 29:30Differences in logging
26. 32:39DDL changes
27. 33:31Stop replication
28. 35:31Failover
29. 36:36Monitoring
30. 37:09What Logical Replication System
31. 37:46Example Bucardo Migration
32. 38:36Creating a new cluster
33. 39:09Setting up a local install
34. 40:44Case study 2 Data Center Migration
35. 41:21Case study 3 Data Center Migration
36. 42:36Slony Information
37. 43:02Multimaster replication
38. 43:22How Bucardo avoids conflicts
39. 44:37Running the conflict resolution code
40. 45:09Bucardo 5 round robin approach
41. 45:48Preventing further changes

" related talks

• 50mEvolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%)Stacy Scoggins · PGConf NYC 2021
• 31mPast, Present, and Future: Logical Decoding and Replication in PostgreSQLHari P Kiran · POSETTE: An Event for Postgres 2026
• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 26mIntroducing YugabyteDB for PostgreSQL UsersBo Peng · Distributed SQL Summit Asia 2023
• 22mSecuring Postgres with streaming replicationJan Karremans · POSETTE: An Event for Postgres 2025
• 50mSparta’s Dual Kingship and PostgreSQL Active-ActiveBoriss Mejias · PostgreSQL Conference Europe 2024
• 42mlesser known Superpower of Postgres Logical ReplicationKevin Biju · PGConf India 2025
• 50mReplication based Multi-Master solutions and design patternsTom Kincaid · PostgresOpen Silicon Valley 2017