How do instances spawned from AMIs work when you have a MySQL database? I think I understand that if you have more than one instance and assign the same Elastic IP to both of them, the incoming traffic gets distributed among both. But what happens when the MySQL database gets updated on one of the instances?
I just need to wrap my mind around what happens when I create an AMI and then launch a new instance to help with traffic.
Thanks for your suggestions.