From: Marcus Bointon
Date: February 19 2008 4:21pm
Subject: Stopping replication
List-Archive: http://lists.mysql.com/replication/1133
Message-Id: <23ACF4E0-8B41-4613-A7E7-122ACED32358@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v919.2)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

I have a circular replication setup that I want to stop, leaving just  
one master. The (irreparably out of sync) second master has been  
stopped for a while, and I want to abandon all changes that are  
pending for it, wipe any pending logs, remove its databases prior to  
rebuilding it. How do I safely deactivate secondary master references  
on the primary? On the primary master I can do "stop slave", but I  
want to make sure that it won't attempt to reconnect to the secondary  
master if I restart it and won't execute functions from the secondary  
that are part of the cleanup process (which could be fatal to the real  
DB).

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/