MySQL replication - Should I handle load balancing from my client code (PHP) ?

Posted by pirostraktor on Stack Overflow See other posts from Stack Overflow or by pirostraktor
Published on 2010-05-10T22:49:28Z Indexed on 2010/05/10 22:54 UTC
Read the original article Hit count: 255

Filed under:
|
|
|
|

In a MySQL master-slave replication enviroment if I have 4 slave servers how can I execute load balanced select queries?

Should I write a PHP class to dealing with the 4 slaves or it is possible to address queries to MySQL's own load balancer solution? Is there a MySQL load balancing solutions?

Can I use some other tool to distribute my queries? What is the typical set up in situations like this?

Thanks for all answers!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about php