Re: Replication problems involving time

2001-09-04 Thread Michael Eklund
> > Also my master.info ends up being wrong whenever the > server is > > rebooted. (binlog.100 becomes binlog.100\n). > > Can you expand on that problem a bit? When I do a "show slave status" before a reboot I have this: +-+-+-+---+-+-

Re: Replication problems involving time

2001-09-03 Thread Jeremy Zawodny
On Wed, Aug 29, 2001 at 12:18:02PM -0400, Michael Eklund wrote: > > Am I the only one that thinks that mysql ought to replicate NOW, > CURRENT_DATE, etc. as the time when those actual inserts happened > not as NOW,CURRENT_DATE,etc. Probably not. > If you are replicating accross a distance (12,15

Replication problems involving time

2001-08-29 Thread Michael Eklund
Am I the only one that thinks that mysql ought to replicate NOW, CURRENT_DATE, etc. as the time when those actual inserts happened not as NOW,CURRENT_DATE,etc. If you are replicating accross a distance (12,15,20 hops) and there is a connectivity problem, then you end up with data that is out of s