Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
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

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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