I have few questions about AWS RDS disaster recovery when read replication is enabled. 1. What happens when an AWS RDS database has read replication instances configured (in same and different AZ's) and the primary instance goes down, does one of the replication instances becomes primary, also what happens to the ongoing read/write operations? 2. How the failover takes place when cross-region replication has been configured? 3. Is the failover process being same for all kind of RDS databases?

AWS RDS failover with read replica instances

I have few questions about AWS RDS disaster recovery when read replication is enabled.

What happens when an AWS RDS database has read replication instances configured (in same and different AZ's) and the primary instance goes down, does one of the replication instances becomes primary, also what happens to the ongoing read/write operations?
How the failover takes place when cross-region replication has been configured?
Is the failover process being same for all kind of RDS databases?

Topics

Tags

Language

English

asked 2 months ago144 views

1 Answer

Accepted Answer

Hi,

Best,

Didier

EXPERT

answered 2 months ago

EXPERT

reviewed 2 months ago

EXPERT

reviewed 2 months ago

Susmita Sarkar
2 months ago
I suppose this is for Amazon Aurora databases, is it same for all the RDS supported databases, Like Oracle /MySQL/MSSQL?
Didier_Durand EXPERT
2 months ago
Hi, externally (i.e from a user standpoint like you and me). yes. Internally, it's of course dependent of the specific architecture of each dbms. But, those differences are not surfaced.