18

I moved my Master/slave database architecture to Amazon RDS and everything works fine.

But I have a slave out of the RDS service which should keep sync with the new Master server, to do so I have to point my DB domain name master-db.myawsserver.com on the Master (RDS) private address IP.

AWS console didn't provide this information and I am connected directly to the MySQL database.

3 Answers 3

29

RDS instances can change their IPs unexpectedly, so they should not be used nor are they provided in the console or API (although you can technically dig for them). The DNS endpoint provided in the AWS console will resolve to the internal IPs from within Amazon's network.

17

You can find a required info in the EC2 console.

  1. Go to RDS Console
  2. Select Databases and find required DB Instance. Open it and find details
  3. Go to Connectivity & security and find VPC security groups
  4. Go to EC2 Console
  5. Select NETWORK & SECURITYNetwork Interfaces
  6. Filter by Security Group or just find an interface by Security group from 3rd point
  7. Select found interface and look at Primary private IPv4 IP. This is internal ip-address which you required
-2

its pretty easy, telnet your RDS endpoint using command prompt on windows or through unix terminal

for example: telnet "you RDS endpoint" "Port"

trying to connect "You get your RDS internal IP here"

2
  • See my answer. You should never directly use the IP, as it can change without warning.
    – ceejayoz
    Sep 27, 2016 at 14:16
  • 2
    There are simpler ways to do reach the same thing (even more so since telnet is not installed in default installations of windows nowadays if I'm not mistaken). If you want to get the IP address associated with a hostname or FQDN you'd be better off using ping or nslookup which are default even on newer Windows systems.
    – pacey
    Sep 27, 2016 at 17:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .