I have a Aurora PostgresSQL cluster with read replicas.
I want to find out (preferably in AWS docs) if it gives strong consistency for reads from RO replicas after writes or is it "eventually consistent" meaning that RO replicas can return stale data during ongoing replication?
Unfortunately, this is not super clear from the documentation.
What I have found here is:
As a result, all Aurora Replicas return the same data for query results with minimal replica lag.
This lag is usually much less than 100 milliseconds after the primary instance has written an update.
However, I am not sure how to interpret this - does it return always the same data at a cost of higher latency with an added replication lag or can it return stale data during the replication?
Also, I am not sure if it depends on the underlying DB engine (Postgres in my case).
It is asynchronous replication as written in the docs. This means that Aurora replicas can return old data even though the new one has already been written in the writer instance.