Module: Replication & Partitioning

Learning Outcomes

Understand database partitioning and replication

You understand

• why is replication needed
• consistency requirements for replication
• replication protocols for maintaining consistency
• synchronous versus asynchronous replication
• leader-based versus distributed/leaderless replication
• other factors in replication such as transparency, distribution of master copy etc.
• how replication is done using different techniques (WAL,change capture)
• problems associated with replication lag
• conflict resolution in replication systems
• how causal ordering of operations is used for conflict resolution
• how to use data partitioning and replication together
• different ways of partitioning data (hash and range)
• the problem of skew in partitions
• how partitioning affect indexing
• how to rebalance partitions

Readings