Re: Question on mySQL replication

2001-12-17 Thread Peter M. Perchansky
Hi Jeremy: Thank you. At 02:05 AM 12/16/2001 -0800, you wrote: >On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote: > > Greetings everyone: > > > > RE: http://www.mysql.com/doc/R/e/Replication.html > > > > How frequently does each slave get data from the master? > >The slaves h

Re: Question on mySQL replication

2001-12-16 Thread Scott Vanderweyst
be one problem when the master rotates its transaction > logs, the slave does not pick it up and you need to manually issue "reset > slave" to get it to go to the start of the first transaction log > > Tim > - Original Message - > From: Peter M. Perchansky

Re: Question on mySQL replication

2001-12-16 Thread Jeremy Zawodny
On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote: > Greetings everyone: > > RE: http://www.mysql.com/doc/R/e/Replication.html > > How frequently does each slave get data from the master? The slaves have a thread running (the "slave thread") which is always connected to the m

Re: Question on mySQL replication

2001-12-16 Thread Jeremy Zawodny
On Sat, Dec 15, 2001 at 12:55:28PM +1100, Tim Wood wrote: > Hi Peter > > We use the mysql replication stuff here. Its very reliable, and the > synchronization between master & slave is pretty much instant. > > There does seem to be one problem when the master rotates its > transaction logs, the

Re: Question on mySQL replication

2001-12-14 Thread Tim Wood
set slave" to get it to go to the start of the first transaction log Tim - Original Message - From: Peter M. Perchansky <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 10:36 AM Subject: Question on mySQL replication > Greetings everyone:

Question on mySQL replication

2001-12-14 Thread Peter M. Perchansky
Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? If the server the master was on went down unexpectedly, how much data would still be on the master that the slave(s) may not have picked up? Thank you. ---