Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-29 Thread Michael Stearne
On Nov 28, 2007 11:18 PM, B. Keith Murphy [EMAIL PROTECTED] 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

Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread Michael Stearne
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

Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread B. Keith Murphy
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

Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread Baron Schwartz
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 [EMAIL PROTECTED] wrote: What versions

Re: Replication Falls Out Of Sync With LOAD DATA

2007-11-28 Thread B. Keith Murphy
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