How to Set Up RDS Proxy for Read/Write Splitting?

I get your worry about failover—which is a valid concern. But don't fret too much! Aurora automatically manages this for you with its writer and reader endpoints. When a promotion occurs, your application just needs to be aware of potential dropped connections. Implementing logic to handle reconnects or errors is key. Check out the AWS docs for more info on how these endpoints work.

You're right that you can't balance writes. If your transactions need both read and write capabilities, they have to go to the writer. The ideal setup would have the RDS proxy configured with distinct endpoints directing to both reader and writer instances. Just make sure your code uses the right endpoint depending on whether it's a read or write operation.

Remember that a proxy isn't a load balancer—it's more like a funnel for your requests. If your proxy is only being used for read operations, it might be better to set up a dedicated read endpoint. However, if your workload also needs to write, the existing setup isn't necessarily a problem unless you really need to separate everything out.