使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

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

0

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 回答
0

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
AWS
审核人员
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?

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容