使用 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 個月前檢視次數 216 次
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?

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容