I set up two-way replication with two servers, A and B. Since all queries go to only one server, it seems not to matter.
Anyway. When A starts it registers itself to B, and vice versa. I thought query "SHOW SLAVE HOSTS" to A should shows only about B and B should do about A, but both show the same result as following. +-----------+------+------+-------------------+-----------+ | Server_id | Host | Port | Rpl_recovery_rank | Master_id | +-----------+------+------+-------------------+-----------+ | 1 | B | 3306 | 0 | 2 | | 2 | A | 3306 | 0 | 1 | +-----------+------+------+-------------------+-----------+ Is it right? Why does the result show both master and slave? Thanks. -- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> --------------------------------------------------------------------- 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
