List:General Discussion« Previous MessageNext Message »
From:Andy Smith Date:March 12 2009 6:09pm
Subject:Re: Replica questions
View as plain text  

Hi Bryan

   Actually changing the slave setup after a reboot is a very bad  
idea, you will have inconsistent data on your slave because every  
transaction made from when you rebooted the server to when you reset  
the position will not be copied from the master. Thats the point of  
the position information, that MySQL can know what data has been  
replicated and what data has not been.
My understanding is that you should never have to reset the binlog  
position info after initial setup unless you are reinitialising your  
slave with a new copy of the data from the master because the slave  
broke for whatever reason. I have several DBs copied to slaves and  
have never had to reset anything following a reboot of the slave (or  
master for that matter).

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,

thanks Andy.

Quoting Bryan Irvine <sparctacus@stripped>:

> The information is there and the replica can connect on a reboot but
> only if that information has not changed correct?
> e.g. I reboot the slave, and on the master just run "reset master;"
> the bin.000001 could change to bin.000002 and the pos change from 98
> to 15443 or some such.  If I do that do I then need to re-run the "set
> master to" statements when the slave comes back up? or can that be
> handled automatically?
> -Bryan

Replica questionsBryan Irvine12 Mar
  • Re: Replica questionsRob Wultsch12 Mar
  • Re: Replica questionsCui Shijun12 Mar
    • Re: Replica questionsBaron Schwartz12 Mar
      • Re: Replica questionsBryan Irvine12 Mar
        • Re: Replica questionsRob Wultsch12 Mar
          • Re: Replica questionsBryan Irvine12 Mar
            • Re: Replica questionsAndy Smith12 Mar
              • Re: Replica questionsClaudio Nanni13 Mar
            • Re: Replica questionsAndy Smith12 Mar