From: Claudio Nanni
Date: March 13 2009 3:19am
Subject: Re: Replica questions
List-Archive: http://lists.mysql.com/mysql/216701
Message-Id: <53bcf3a60903122019r3ff351bcye52655e32b6cb2c7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001636c5b27c4486760464f791bc

--001636c5b27c4486760464f791bc
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

>
>
> If you are finding replication stops after a reboot then I think you have a
> serious problem, but don't know what that might be. Post some more info and
> someone on the list can probably help,
>
> just a 'skip-slave-start' in my.cnf does the trick.


2> Is there a way to get a slave to automatically re-connect as the
slave without having to know the masters binlog and position?  Each
time it reboots I have to manually add it back in with the change
master to ... command.

if you do NOT have 'skip-slave-start' in the my.cnf replication starts
automatically,
what is the output of SHOW SLAVE STATUS\G after a reboot?
if you do not have an empty set and SQL and IO thread are NOT running you
probably have 'skip-slave-start' in the config file.


Claudio

--001636c5b27c4486760464f791bc--