- Le plus récent
- Le plus de votes
- La plupart des commentaires
Hi, the proper Recovery Failure using Read Replicas is detailled in section "Implement Failure Recovery" of https://aws.amazon.com/blogs/aws/amazon-rds-for-mysql-promote-read-replica/ and in final sections of https://aws.amazon.com/blogs/database/implementing-a-disaster-recovery-strategy-with-amazon-rds/
I also highly recommend the reading of this foundational wp "Disaster recovery options in the cloud": https://docs.aws.amazon.com/pdfs/whitepapers/latest/disaster-recovery-workloads-on-aws/disaster-recovery-workloads-on-aws.pdf#disaster-recovery-options-in-the-cloud
All AWS-recommended DR models are in there
Best,
Didier
Once you promote a read replica it is no longer related to the old source instance.
Yes, but can we have the sync back again? Before promoting the read replica note the binary_log_file_name, and binary_log_file_location of the master and then once the read replica becomes a standalone master, can we re-establish the replication sync using the mysql.rds_set_external_master stored proc?
Contenus pertinents
- demandé il y a 2 ans
- demandé il y a 2 mois
- demandé il y a 2 ans
AWS OFFICIELA mis à jour il y a 2 ans- AWS OFFICIELA mis à jour il y a 4 ans
- AWS OFFICIELA mis à jour il y a 2 ans
The document just shows how to promote the read replica but I'm looking at how to re-establish the sync back with old master.