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 |