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 ()

관련 콘텐츠