AWS re:Postを使用することにより、以下に同意したことになります AWS re:Post 利用規約
AWS re:Postre:Post

How to re-sync back after MySQL read replica is promoted

0

We have a cross-region MySQL RDS replication and I believe if we promote the replica server it becomes a standalone master server. Now how to bring back the sync between them again, Instead of creating new read replicas for the new master, is there any other possibilities? Can we use mysql.rds_set_external_master to sync back? any supporting document would be much appreciated.

トピック
データベース
タグ
MySQL
言語
English
Sravan
質問済み 10ヶ月前220ビュー
2回答
0

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

profile pictureAWS
エキスパート
Didier_Durand
回答済み 10ヶ月前
  • Sravan
    10ヶ月前

    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.

0

Once you promote a read replica it is no longer related to the old source instance.

AWS
モデレーター
philaws
回答済み 10ヶ月前
  • Sravan
    10ヶ月前

    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?

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ