Link to home
Create AccountLog in
Avatar of headzoo
headzoo

asked on

PHP: Selecting MySQL Slave

Hi,
I'm learning to use MySQL replication in my applications. I gather I'm supposed to write to the master, and read from the slaves. Here's the question: How do I pick a slave?

More specifically, if I have three MySQL slave servers, how should an application go about selecting one of them to read from? Just pick one at random? Is there a better way than that?
ASKER CERTIFIED SOLUTION
Avatar of mattaob
mattaob
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account