I think you should also check hardware load balancers like Foundry, Alteon.
They are very reliable.
As now in mysql 5 you can have a master to master relation between mysql servers, so i guess now load balancing of read/write queries is same.
Later in mysql 4 people used to setup one master DB and other Slaves(read-only), so only read queries were load balanced.
|