View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 07:02 AM
B. Keith Murphy
 
Posts: n/a
Default Re: Replication Falls Out Of Sync With LOAD DATA

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

Reply With Quote