As Postgres logical replication matures, the possibility of advanced architectures such as low-latency multi-master clusters becomes more appealing. As the first of these, Postgres-BDR exposes the reality of conflict management to Postgres.
Conflicts are not a concept unique to Postgres, and the tactics for identifying and circumventing them are generally well established.
In this talk, we’ll explore the types of conflict that may arise in a multi-master cluster, and how to mitigate each. If you’re planning to integrate multi-master technology into your database stack, it’s important to adapt the application layers accordingly.