View Single Post

   
  #5 (permalink)  
Old 02-28-2008, 08:02 AM
Michael Stearne
 
Posts: n/a
Default Re: Replication Falls Out Of Sync With LOAD DATA

On Nov 28, 2007 11:18 PM, B. Keith Murphy <bmurphy@paragon-cs.com> wrote:
> The reason I asked about version is that it looks like there is problem
> replcating a load data infile command from some versions of 4.x to 5.x
> slaves.


Master and Slaves are 5.x. Hopefully I've figured out the issue.
When the slave would fall out of sync, I would resync using rsync. In
that rsync command I was using the --delete option which would delete
the relay log from the slave machine. Since the relay log was being
removed constantly, the replication was in a strange state. That
problem is fixed so hopefully things should stay in sync.

Michael
Reply With Quote