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.


Baron Schwartz wrote:
> What do you mean by "falls out of sync?"
>
> LOAD DATA INFILE hasn't been a problem for me, and I use it a LOT.
> It's so simple that I suspect something else. But then again, I don't
> know what you mean by "out of sync"
>
> On Nov 28, 2007 4:32 PM, B. Keith Murphy <bmurphy@paragon-cs.com> wrote:
>
>> What versions of MySQL are you using on both the master adn the slaves?
>>
>> Keith
>>
>> Michael Stearne wrote:
>>
>>> We have replication set up for 1 master and 4 slaves. When resynced
>>> everything appears to work fine. Come back a couple hours later and
>>> the machines are out of sync. The only thing I can think of that could
>>> cause this is that we are inserting some data on the master
>>> (updates,inserts,deletes) using LOAD DATA INFILE. Does this cause a
>>> problem for replication?
>>>
>>> Thanks,
>>> Michael
>>>
>>>
>> --
>> Keith Murphy
>>
>>
>> editor: MySQL Magazine
>> http://www.mysqlzine.net
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=baron@xaprb.com
>>
>>
>>
>
>


--
Keith Murphy


editor: MySQL Magazine
http://www.mysqlzine.net