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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
--
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/[EMAIL PROTECTED]