CODEWITHSUNDEEP
amazon-rds
os111
os111

Reputation: 154

Obtain public IP from which RDS instance will connect to an external master?

To configure RDS MySQL as a slave to an external master (for minimal downtime migrations, as described here) I need to determine which IP the instance will connect from (to allow traffic from it to my external master).

How can I determine the IP address if the instance isn't publicly accessible?

Upvotes: 3

Views: 1439

Answers (2)

user8582294
user8582294

Reputation: 1

well create a test replication user at the external master that can connect from '%' and use that one as user at the RDS instance once connected , you will see the iP in the processlist and then you will be able to restrict the access to only that IP, dropping the '%' test replication user

Upvotes: 0

os111
os111

Reputation: 154

It turns out there's no way to do external master replication with an RDS instance that doesn't have the publicly accessible option enabled--no outbound traffic will be allowed outside the VPC.

Further, there's no way to modify an instance's publicly accessible setting--a new instance must be launched (e.g., from a snapshot).

Upvotes: 2

Related Questions