> 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>
I don't think this is correct. A quick look at the source shows that it iterates over slave_list to generate the output. I don't think that A should be in it's own slave list. I don't know why it is. I'll look into this further. Is this causing problems for your application? What version are you using? Nick -- For technical support contracts, visit https://order.mysql.com/?ref=mnle __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Nicholas Leippe <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Spanish Fork, Utah USA <___/ www.mysql.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