1

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?

3
  • When you do a change on M2 does M1 get this changes? Commented Apr 8, 2013 at 12:50
  • @altmannmarcelo:Yes. It happens Commented Apr 9, 2013 at 8:51
  • Then follow what @derek-downey says Commented Apr 9, 2013 at 12:50

1 Answer 1

3

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.

2
  • Hey Derek, I miss your quick-and-dirty answers. +1 !!! Commented Apr 8, 2013 at 15:02
  • @Derek: Hey Thanks man. We figured out late in the afternoon Commented Apr 8, 2013 at 16:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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