List:Replication« Previous MessageNext Message »
From:Luis Torres Date:February 20 2008 12:28am
Subject:Re: Stopping replication
View as plain text  
Marcus,

if you rebuild your secondary server from scratch then the primary won't have permissions
to connect to it and replicate.

You can also get rid of the master.info file, all relay-bin.xxx files and the
relay-bin-index file.

Of course there's better ways to accomplish what you need but that'll do the trick.

Luis

----- Original Message ----
From: Marcus Bointon <marcus@stripped>
To: replication@stripped
Sent: Tuesday, February 19, 2008 10:21:53 AM
Subject: Stopping replication


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/



-- 
MySQL 
Replication 
Mailing 
List
For 
list 
archives: 
http://lists.mysql.com/replication
To 
unsubscribe:  
  
http://lists.mysql.com/replication?unsub=1







      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search. 
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
Thread
Stopping replicationMarcus Bointon19 Feb
  • Re: Stopping replicationAugusto Bott20 Feb
    • Re: Stopping replicationMarcus Bointon20 Feb
  • Re: Stopping replicationEd W26 Feb
    • Re: Stopping replicationJed Reynolds26 Feb
      • Re: Stopping replicationEd W26 Feb
Re: Stopping replicationLuis Torres20 Feb