I setup an auto scaling group on EC2 along with an RDS Postgres instance. I am not using ELB. Maybe I should be...
The challenge is that every time a new EC2 instance is created it assigns a unique public IP address. This means that a new inbound rule needs to be applied to the security group for RDS that allows this new EC2 instance to connect to RDS via port 5432 (postgresql).
I also run into a Route 53 issue since the new ip address needs to be added to the DNS "A Record" in order to properly resolve the url.
Is there a way to setup AWS to do this for me, or do I need to write some python code using boto?