is it possible to configure the replication from AWS RDS mysql 5.7 read replica to AWS RDS mysql 8.0 by using CALL mysql.rds_set_external_master ()

Hi Team,

I explain here briefly, I will stop the replication from read replica to Rds mysql 5.7 master db. and take a backup and note the binlog position and restore the backup in rds mysql 8.0. then after by using this sp CALL mysql.rds_set_external_master (); I able to configure the replication from master RDS Mysql 5.7 to RDS mysql 8.0 but my question is I able to create a read replica from read replica so shall i able to do the same thing? like take backup from read replica after stop the replica from read replica to read replica and note the binlog position then from RDS mysql 5.7 read replica to rds mysql 8.0. if not then I want to know a technical explanation.

Thanks & Regards Aravind

トピック

データベース

タグ

MySQL

言語

English

Aravind

質問済み 3ヶ月前215ビュー

1回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

It is possible. But why would you not just use the managed service to create a read replica within RDS? You can just create a managed read replica from the 5.7 source and upgrade it to 8.0

create-db-instance-read-replica

モデレーター

philaws

回答済み 3ヶ月前

Aravind
3ヶ月前
but mysql.rds_set_external_master () this stored procedure created for master to slave configuration right so if i try to configure the replication from slave to slave how it will work? please briefly explain about the this stored procedure. master user should include in the stored procedure so how i add that master user for read replica?

is it possible to configure the replication from AWS RDS mysql 5.7 read replica to AWS RDS mysql 8.0 by using CALL mysql.rds_set_external_master ()

関連するコンテンツ