mysql replication & load balancing

view story

http://www.linuxquestions.org – Hello everybody ,, i have a couples of questions ,as i always get help when i need from this great forum discussion , i'm going to implement mysql replication for the first time on two servers through master-to-master in active-passive mode and i want to use a load balancer software with this replication system this load balancing software have the ability to configure easily without making any troubles to point or direct database writes to the active server not to the passive server mean that i want a load balancer software which can direct apache web server read requests to server B (HowTos)