Home / server / Questions / 458778
Accepted
chris
Asked: 2012-12-18 09:31:12 +0800 CST

How do I handle mysql replication in EC2 using private IPs?

  • 772

I am trying to set up a mysql master/slave configuration in two EC2 instances.

However, every time I reboot an instance, the IP address (and hostname) changes. I could assign an Elastic IP address, but would prefer to use the internal IP address.

I can't be the first person to do this, but I can't seem to find a solution. There are a lot of "getting started" guides, but none of them mention how to handle changing IP addresses. So what are the best practices to manage master/slave replication in EC2?

mysql

2 Answers

  1. Best Answer

    Use an elastic IP address. Make sure to refer to the server by the elastic IP address's public hostname, not the actual IP address.

    Elastic IP addresses will resolve to the internal IP address when the resolution request comes from the availability zone's internal network. Otherwise, it will resolve to the public IP address.

    So when one EC2 instance resolves the elastic IP address's public hostname of another instance that is in the same Availability Zone, it will use the internal address.

    • 3

  2. Use a VPC, where instances retain their internal IPs through reboots.

    Or, create a script on your DB instances that adjusts a Route53 DNS record with their internal IP on bootup, and use that DNS record to connect.

    • 2