I have 2 Linux servers on AWS. Both servers are in the default vpc (aws default vpc). Both of these servers have their own Elastic IP. I also have a webServer which is inside the same vpc.
I want to run a replicated MySQL on these 2 servers, so one server would be master and the other slave.
I need to provide an ip address for each MySQL server, so in my.cnf, there is a setting:
Should I use the public or private IP for the bind-address? (All the computers who need access to MySQL server are in the same vpc).
Note both servers are in the same Security Group and I have opened all the ports within the security group.