Hello, We have four Mysql database servers: S1, S2, S3, S4 and we use Mysql replications,
S1 is the master server S2, S3, S4 are the slave servers. Our website use S2, S3, S4 as production databases; But we have no good idea to load balance between three severs. We use php scripts to chose a server by random, but sometimes we found S2 was very very busy but S3 was a little vacancy. Is there any good idea to load balance for our mysql servers? Thanks a lot! Lee
