Make MySQL database replication always use the most free node?
- by Chad Johnson
We started using Multi-Master Replication Manager for MySQL, and I am wondering whether it is possible to to treat this setup like multi-symmetric processing: a process pops off the process queue, and the node (in this case a server) that is most free is selected for the job.
It seems that what happens is, the service switches to a slave ONLY when it mysqld crashes or goes away.
Is there a way to make database replication for MySQL act in more of a distributed manner? Maybe there is other software besides MMM that can do this?
Is there a way to switch the reader role to another server whene mysqld slows down (rather than just when it fails)?