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
