MySQL replication - Should I handle load balancing from my client code (PHP) ?
- by pirostraktor
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!