Folks, Since ELB is not available for load balancing RDS instances, what methodology do you recommend to load balance read replicas? RR Route53 DNS entries? Or something more clever?
Thanks
-
Have you considered the load balancing built in to RDS via RD Connection Broker using Farms?– Scott ChamberlainMar 28, 2013 at 17:36
-
@ScottChamberlain thanks! but the question was more towards AWS :)– CMagMar 29, 2013 at 13:52
Add a comment
|
2 Answers
You should check out using HAProxy in TCP mode to load balance the RDS instances.
HAProxy: http://haproxy.1wt.eu/
Lots of guides available by searching "HAProxy MySQL", etc.
answered Mar 29, 2013 at 16:12
The MySQL project has their own proxy for MySQL as well: http://dev.mysql.com/downloads/mysql-proxy/
