Understand Database Replication The Good and Ugly

What Is Database Replication?

Advantages of replication

Improved reliability and availability

Improved network performance:

Increased data analytics support

Replication types

leader-follower replication

How does this model work?

Problems with leader-follower replication

Leader failure

Follower failure

Multi leader replication

How does this model work?

Some Use Cases for Multi-Leader Replication

Clients with offline operation

Collaborative editing

Problems with Multi leader replication

Write Conflicts

leaderless replication

How does this model work?

Problems with Multi leader replication

Writing to the Database When a Node Is Down

Disadvantages of replication

Conclusion

I’m an experienced senior tech professional with vast experience in a lot of technologies aside from Backend being my specialization.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store