Comment by vips7L
We’re currently struggling with switching from RDS to aurora. The replica times are absolutely bonkers long for the simplest of writes.
We’re currently struggling with switching from RDS to aurora. The replica times are absolutely bonkers long for the simplest of writes.
I’m going to preface this with I’m not an OPS person. But yes multi region. The main writer instance is us-east-1 it performs excellently when hitting this region. We have read replicas in us-west-2 and some in Europe/emea and Asia/pacific.
When hitting one of these with a write you end up with massive delays. The 7 seconds and below tends to be from us-west-2 and the higher numbers are from our Japanese users.
Our OPS team has struggled to figure out why the delays happen. There’s some code fixes we could probably do (i.e always write to the writer) but as team lead for the development side the deadline is too close and I don’t want to rewrite core parts of the app to split reads and writes. They engaged AWS support so I’m hoping something is just misconfigured or maybe this just isn’t the use case for Aurora.
Aurora has essentially constant replica lag times, it’s one of the best features. Should be around 30-50ms always, are you seeing different?