In our production environment at GreatSchools
we have 3 production MySQL database servers: 1 read-write master and 2
read-only slaves. In moving our site from Perl to Java we need to load
balance read-only connections across the read-only slave servers so
that our read-write master doesn't get overwhelmed under heavy load. As
our systems administrators discovered there's a solution to load balancing read-only connection in the MySQL JDBC driver! Read more here, my blog has moved!