20

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.

ZygD
  • 377
  • 1
  • 3
  • 11
Imad Touil
  • 303

3 Answers3

32

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.

ceejayoz
  • 33,432
19

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 & SECURITY → Network 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
Alexey Parshikov
  • 191
  • 1
  • 2
-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"

Rohan
  • 1