Replication based Multi-Master solutions and design patterns

Date: 2017-09-08
Time: 13:30 - 14:20
Room: Cyril Magnin
Level: Intermediate

Postgres multi-master solutions are almost exclusively loosely coupled replication based architectures. Some other clustered database management systems are built on a tightly coupled shared everything architecture. This talk will start by discussing the advantages and disadvantages of these two multi-master architectures and the appropriate use cases for both. The remainder of the talk will cover loosely coupled multi-master deployment scenarios and the application design patterns for these deployment scenarios. Examples of topics to be covered are: globally distributed databases, fast failover and write availability. The talk will also cover application design patterns such as generating primary keys and conflict resolution in a loosely coupled multi-master architecture.


Tom Kincaid