3 ms·
Read replicas come with their own complexity as you have to account for the lag time on the replica for UX. This leads to a lot of unexpected quirks if it’s not
by brightball 2y ago
Read replicas come with their own complexity as you have to account for the lag time on the replica for UX. This leads to a lot of unexpected quirks if it’s not planned for.
- cqqxo4zV46cp 2y agoA hot standby / failover still meets this definition. That’s how I interpreted what was being described.
- danmaz74 2y agoThat's true, but you can use your replica only for non-realtime reporting, or even just as a hot standby. Edit: Careful for the non-realtime reporting though if you want to run very slow queries - those will pause replication and can be a PITA.