Presented by:

Robert treat chelnik square

Robert Treat

xzilla.net

Working on database-backed, internet-based systems for over a decade, Robert is a long-time user, developer, and advocate for open source technologies. Best known for his work in the Postgres community, he has contributed to numerous industry groups and is currently a co-organizer for both Baltimore and DC DevOpsDays conferences. An international speaker on databases, open source, and web operations at scale, he occasionally blogs at https://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