Women in Technology

Hear us Roar



Article:
  Advanced MySQL Replication Techniques
Subject:   fail-over infinite looping problem
Date:   2007-03-09 09:00:49
From:   chazByrne
The scenario is that four servers A, B, C, and D (with server ids 1, 2, 3, and 4 respectively) replicate in a topology { A->B, B->C, C->D, D->A }. Server A crashes. The DBA wants slave B to connect to master D instead and continue with the circular replication.


The normal loop detection that MySQL has discards events that are generated on the same server, but since A is no longer in the circle, the generated events will loop forever. My current problem is an update statement from the downed server that is replicated in an infinite loop...


Is there a work around for this? Or a command I am missing.



Thank you very much,
Chaz Byrne

Full Threads Newest First

Showing messages 1 through 2 of 2.

  • fail-over infinite looping problem
    2007-04-12 05:42:45  v_v_nataraj [View]

    Hi,

    I too am facing the same problem and am not able to find a solution anywhere on net.

    Does anyone know if a solution exists? Otherwise it is a show stopper for circular replication.

    Thanks a lot,
    Nataraj
  • fail-over infinite looping problem
    2007-04-12 21:13:11  v_v_nataraj [View]

    There is a proposed solution here http://forums.mysql.com/read.php?26,110341,110341
    But I am not sure if/when it would be incorporated in the server.

    Regards,
    Nataraj