Futher to my previous question,

Here is what we have

      |       ^
      V       |
S1<---M1      M2
      |       ^
      V       |

what happens is Upon making any drop, create, update or insert on M1, the slave S1 Syncs the changes in M1. But when we are trying to do the same in M2, we are not getting any changes synced to the slave S1. Any suggestions on how to do that?

  • When you do a change on M2 does M1 get this changes? – altmannmarcelo Apr 8 '13 at 12:50
  • @altmannmarcelo:Yes. It happens – Srinath G S Apr 9 '13 at 8:51
  • Then follow what @derek-downey says – altmannmarcelo Apr 9 '13 at 12:50

You need to ensure you have log_slave_updates enabled on M1, so that any changes that M1 makes via replication from M2 gets written to M1's master log (and thus replicated to S1).

Don't worry, the entries in M1's binary log will not get re-replicated to M2. M2 will ignore any updates which originated from its server-id.

  • Hey Derek, I miss your quick-and-dirty answers. +1 !!! – RolandoMySQLDBA Apr 8 '13 at 15:02
  • @Derek: Hey Thanks man. We figured out late in the afternoon – Srinath G S Apr 8 '13 at 16:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.