refer https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-cross-region-replica/ for a better understanding,
RDS supports creating cross-region read replica for MariaDB across all regions. You can use AWS console to quickly provision a cross-region read replica. RDS uses asynchronous replication to replicate the changes from source database to the cross-region read replica database.
In case the primary database goes down, you can "promote" this cross-region read replica to a stand-alone instance and use this database's endpoint in your application. Please note that "promoting" operation is same for both in-region read replicas (source and replica in same region) and cross-region read replicas. Please note that once the read-replica is "promoted", it will no longer replicate the changes even if the previous primary database recovers.
In short, as mentioned in our documentation, the suggested "failure recovery" strategy is:
- Promote the read replica.
- Direct database traffic to the promoted DB instance.
- Create a replacement read replica with the promoted DB instance as its source.
For more information, please refer the below links: RDS Cross region read replicas - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.XRgn Promoting a read-replica (applicable for both in-region and cross-region read replicas) - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.Promote How Amazon RDS does cross-Region replication - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.XRgn.Process
How to ensure replica is in sync between AWS RDS PSQL primary DB and Aurora RDS PSQL replica cluster?asked 7 months ago
2 RDS writable databases, in different regions, synchronized between each other.Accepted Answerasked 2 months ago
RDS UI missing Jakarta for read replicaasked 4 months ago
Can i create a cross-region read-write replica with Amazon RDS?
Aurora Create cross-region read replica vs Add RegionAccepted Answerasked 2 years ago
Aurora Replica Sizing vs. Source DB Sizing - Do they need to match?Accepted Answerasked 4 years ago
Is it possible to tap into a Multi-AZ DB cluster read replica binlog?asked 22 days ago
How do i make a read replica of a database with a custom parameter group in a different region?
Amazon RDS for MariaDB instance read replica between regionsasked 4 months ago
will RDS auto create a new instance whenever the primary instance failover in Aurora Cluster?asked 3 months ago