|
|
|
|
|
by zsoltkacsandi
659 days ago
|
|
Well, the problem is a little bit more complicated than just having replicas. You cannot build operational procedures based on “hope”. High replication lag occurs for many many reasons (and they are not a rare event, or something that you can prevent). As well as network partitions. Replication and binary logs can get corrupted, there can be deadlocks, duplicated row errors, etc. The thing is that database administration is a broad and complicated topic, a small mistake or the lack of understanding how these systems work can easily lead to huge data losses. |
|