Hi Mr. Bueno, thnak you for you're response. I knows the way you described how determine if replication is finished.
But doing this I need to make a connection to the slave and a connection to the master and compare the results of this two queries. I'm looking for a way of deciding this with one connect only on the slave ( If the slave is ready with replicating and need to do something with the data on the slave). Best regards > -----Original Message----- > From: Joseph Bueno [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, February 01, 2003 4:24 PM > To: Guddack Thorsten ICM MP SCM GO 21 > Cc: '[EMAIL PROTECTED]' > Subject: Re: Replication Questions 2 > > Hi, > > > Guddack Thorsten ICM MP SCM GO 21 wrote: > > Hi List, > > > > again some Questions to replication in mysql: > > > > I test the replication with following setup: > > > > 1 Server in Europe as the master, 2 servers in Asia and south america as > > slaves. > > > > Both slaves does the replication very fine. > > Every insert, update or delete is replicated very fine, even with binary > > data in blob stored. > > But If I try to stop the slaves > > with stop slave > > it takes a very long time until the shell comes back? > > Any ideas about that? > > No idea. > > > > > Next Questions: > > The connection to asia is very slow. Is there a chance to find out when > the > > slave has all the data replicated? > > > > You can run "SHOW MASTER STATUS" on the master, "SHOW SLAVE STATUS" on the > slave and compare 'Log_File' and 'Pos' fields. > > > Thanks > > > > thorsten guddack > > > > > > Regards, > Joseph Bueno --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
