MySQL Master to Master To slave Replication
Posted on 2011-03-11
Ok, I've been looking and can't seem to come up with a answer on this.
Right now I have a Master To Master Replication in place for part of my failover system in place. Though lately the servers have been starting to slow down a lot because we have a lot of reporting that is going on and it's affect the software that powered by the MySQL Database.
So what i want to do with throw in a third computer as a slave just for these reports. Something like this
[M1] <-> [M2]
So if M2 is currently the active computer in my fail over system, what I'm wondering is if the new data sent to M1 is also replicated down to S1.