Date: 2020-03-24
Time: 17:15–18:10
Room: Ballroom
Physical replication, logical replication, synchronous, asynchronous, multi-master, scale-out reads, sharding... so many concepts related to replication. In this talk we will review the fundamental ideas behind each of them, and in which cases you will need one or the other. We will compare different architecture designs, discussing their advantages and disadvantages. The practical part of the talk is focused on how PostgreSQL works. The ideas and concepts can be applied to other database engines.