Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Thursday, May 13 • 16:00 - 17:00
THE MANY FLAVORS OF REPLICATION

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


This talk presents an overview of the many forms of replication currently supported in Postgres.

Here's a breakdown of the topics that will be covered:
- We start with the replication configurations and which includes:
- multi node PRIMARY-STANDBY replication cluster
- Cascading Replication
- Other:
- Replicating to another READ-WRITE host
- active-active
- analytics
- Replicating to a READ-ONLY host using a time delay
- Working with detached READ-ONLY systems

- There are three (3) forms of replicating technologies that have been developed for database systems:
- statement replication
- trigger replication
- binary (the most commonly used solution)

- There are two types, or classifications, of replication which is used by Postgres:
- asynchronous replication
- synchronous replication

Of course this is by no means a complete list as there are so many methods and their variations which are possible in Postgres.

Speakers
avatar for Robert Bernier

Robert Bernier

PostgreSQL Consultant, Percona
Robert's experience extends several decades. His first experience was playing hangman on a DECwriter shortly after man first landed on the moon. His foray into commercial applications was programming Fortran, via punchcards, on an IBM 360 which in those days had 4MB RAM. Over the... Read More →


Thursday May 13, 2021 16:00 - 17:00 EDT
Room #5
Feedback form isn't open yet.