Hello.
>Is there any good idea to load balance for our mysql servers?
I'm not sure, but have a look at "High Performance MySQL" by
Jeremy D. Zawodny. This is a snip from it's publically available
chapter.
###
Real-time data
Less optimal solution:
Create a DNS round-robin alias, say
mydatabase.myinternaldomain.com, that point to S2-4.
"Optimal" solution:
Set up a real load balancer, hardware based or software based
(http://www.linuxvirtualserver.org/), and have it configured to distribute
your connecti
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
