Interview Bootcamp
Ask Author
Back to course home

0% completed

Vote For New Content
Kushidhar Reddy
How does databases sync in multiple servers ?

Kushidhar Reddy

Oct 16, 2024

Hi, how does all the databases are in sync when the load balancer (before api gateway) distributes the requests to multiple servers. There can be conflicts, how they are resolved.

0

0

Comments
Comments
Raunak Baliyan
Raunak Baliyan5 months ago

All servers are connected to a single database, which may have internal replicas or clusters. The DBMS manages synchronization and conflict resolution, ensuring data consistency.

Raunak Baliyan
Raunak Baliyan5 months ago

Conflicts arises when multi master or eventual consistency, comes in databases. Various ways to solved this: 1. Last-write-wins (LWW)

  1. Time-Stamp or version based conflict resolution

etc.