-
Hi. I’ve also come across this on 17/May/22 and the answer and explanation are still confusing…
“You can set up replication between an Amazon RDS MySQL
(or MariaDB DB instance) that is running in AWS and a MySQL (or MariaDB
instance) to your on-premises data center. Replication to an instance of
MySQL running external to Amazon RDS is only supported during the time
it takes to export a database from a MySQL DB instance.“The answer should also be clear how many DBs there are, 2 or 3 (AWS RDS MySQL source, on-prem mySQL replica, AWS RDS MySQL Replica?)…
“Create an IPSec VPN connection
using either OpenVPN or VPN/VGW through the Virtual Private Cloud
service. Prepare an instance of MySQL running external to Amazon RDS.
Configure the MySQL DB instance to be the replication source. Use
mysqldump to transfer the database from the Amazon RDS instance to the
on-premises MySQL instance and start the replication from the Amazon RDS
Read Replica.”ta, Brad.
