I doubt there's any single "best way" to do it. We used LVS
(http://www.linuxvirtualserver.org/) with good results.
(I'm sure BigIP is fine too, but LVS might be simpler/cheaper to
implement for users who are comfortable managing Linux servers.)
Beware of applications that utilize connection pooling. Unfortunately
it's common to see applications that preserve idle connections for
several hours. With load balancing in place, those connections will be
allocated to real servers as they are created. If you change the
weights of real servers (for instance to direct traffic away from a
heavily-used cluster node) connection pooling tends to delay the effect.
To overcome this we've turned down wait_timeout aggressively on our
mysqld nodes, as low as 60 seconds.
> -----Original Message-----
> From: laehr mistry [mailto:laehr.mistry@stripped]
> Sent: Wednesday, February 16, 2011 5:00 AM
> To: cluster@stripped
> Subject: best load balancing method for MySQL Cluster
> Please suggest me which is the best way or method to Load balance
> mysqld nodes used in production.
> Can we use F5 Big-IP LTM to load balance MYSQL?
> Thanks and Regards