I'm very new to this,so please correct if I'm wrong. I've understood that with Amazon RDS one can create read replicas and use those for all read-only operations. This helps scaling the application a lot.
Unfortunately, I have a PHP application that does not support separate read-write and read-only connections.
Is there a way around this, other than modifying the application?