I am new to AWS in general so this might be a noob question. I have set up an RDS instance with a readreplica & connected my VMs to the the Master DB for now via AWS Opsworks. Ideally I want the reads balanced between master and slave and the writes to only go to the master.
Ofcourse I do this in code but that will be messy especially if I want to add more RDS Slaves or if I delete one or more of my instances.
So is there something I have missed? Is there some configuration that AWS provides that I have not come across yet to seamlessly do this?