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

Showing messages 1 through 2 of 2.