'Is there any replication lag for aws Aurora cluster or can we ever read the stale data due to replication lag?
Similar question but did not clear my doubt: AWS Aurora cluster: strong or eventual consistency?
According to aws doumentation, replication is done asychronously and there could be a replication lag of around 10th of miliseconds.
But aurora uses qouroms for read and write. There are 6 copies of data and write is aknowledged only when data is written to 4 storage nodes and read is done from 3 storage nodes. So there will always be one storage node which will have latest data.
Article: AWS Aurora cluster: strong or eventual consistency?
So I have following questions:
- What is meaning of replication lag in Aurora Mysql, since stale data can never be read?
- Will there be ever any chance of data loss during failover due to replication lag? (when primary instance crashes due to some reason and replica takes over as primary instance)
Please note that all instnaces are on same region and there is single master db instance.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|