- quick intro into logical decoding - Intro into BDR/UDR - differences - patches - development/maintenance - How to setup UDR - configure source system - configure replica - subscribe to node - execute DDL across nodes - How to setup BDR - configure source system - configure replica(s) - execute DDL - Usecases - easier failover - mostly separate data - insert mostly - global sequences - conflict resolution - show conflicts table - node removal - Advanced topics: - replication sets - every table can be in multiple ones - subscriber can subscribe to multiple overlapping sets - two implicit sets - Where is this going: - both: more granular cloning options, recloning of tables - UDR: ddl replication to be integrated for 9.5+ - UDR: Nicer failover, that's to much work by hand right now - UDR: sequences - both: automated failover? - both: bdr_upgrade employing pg_upgrade