SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:02 AM
| ||||
| ||||
 Replication Falls Out Of Sync With LOAD DATA 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      |
|
02-28-2008, 07:02 AM
| |||
| |||
| 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 |
|
02-28-2008, 07:02 AM
| |||
| |||
| Re: Replication Falls Out Of Sync With LOAD DATA 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 > > |
|
02-28-2008, 07:02 AM
| |||
| |||
| Re: Replication Falls Out Of Sync With LOAD DATA 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 |
|
02-28-2008, 07:02 AM
| ||||
| ||||
| 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 |
 |
« MySQL University session on November 29
|
RE: MySQL Customer Survey :: an exercise in frustration »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:28 AM.
