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
