0

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

Jason Floyd
  • 1,792
  • 1
  • 13
  • 18
CMag
  • 707
  • 2
  • 11
  • 32
  • Have you considered the load balancing built in to RDS via [RD Connection Broker using Farms](http://www.virtualizationadmin.com/articles-tutorials/vdi-articles/general/remote-desktop-server-farms-explained-part1.html)? – Scott Chamberlain Mar 28 '13 at 17:36
  • @ScottChamberlain thanks! but the question was more towards AWS :) – CMag Mar 29 '13 at 13:52

2 Answers2

0

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.

Jason Floyd
  • 1,792
  • 1
  • 13
  • 18
-1

The MySQL project has their own proxy for MySQL as well: http://dev.mysql.com/downloads/mysql-proxy/

sqlreader
  • 281
  • 1
  • 3
  • 8