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 connections. I have quoted optimal as your success depends on how you
configure your distribution, but it should still work better than the
previous solution.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Thu, 29 Dec 2005, lee_mezimedia wrote:
> 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
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
