Presented by:
Robert Treat
With almost two decades of building database-backed, mission critical web systems under his belt, Robert currently spends his days running US operations for credativ, an international provider of open source services and support. Both an author and speaker at conferences worldwide, Robert is a recognized expert within the industry on topics such as Open Source, databases, and managing operations at scale. He occasionally blogs at http://xzilla.net.
No video of the event yet, sorry!
Postgres has a lot of ways to do replication and other forms of multi-server environments, but logical replication is one of the most useful. Want to know why? In this talk we'll talk about:
• a (very) brief history of replication in Postgres • the whats and hows of logical replication • differences between Postgres 10, 11, and 12 • good use cases for logical replication • not good use cases and better alternatives
After we talk about logical replication, we'll walk through a live demo of setting up replication between two servers, including setting up a schema and replicating data across the wire. After we cover the basics, we'll do some live, unscripted, audience-led, experimentation with our cluster, looking at things like DDL changes and more esoteric commands like, what happens when you truncate a table, or what happens if you change your schema between servers? To wrap it up, we'll answer some FAQ's around logical replication so attendees will be ready to hit the ground running with their own logical replication experiments.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2020
- Language:
- Track:
- Distributed SQL
- Difficulty:
- Easy