MySQL Bugs: #83236: How to see mysqlrouter membership status?

Bug #83236	How to see mysqlrouter membership status?
Submitted:	1 Oct 2016 21:00	Modified:	18 Apr 2018 15:51
Reporter:	Kenny Gryp	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Router	Severity:	S4 (Feature request)
Version:	5.7.15-labs-gr090-log	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
How to look into mysqlrouter status other than some basic information found in the mysqlrouter log?

The documentation does not mention anything.

How to repeat:
my mysqlrouter does not accept connections:

[root@mysql1 ~]# telnet mysql1 3306
Trying 192.168.56.11...
Connected to mysql1.
Escape character is '^]'.
8Can't connect to remote MySQL server on 'mysql1:3306'Connection closed by foreign host.

In the error log I get:
2016-10-01 20:54:53 INFO    [7f6239ffb700] Connected with metadata server running on mysql3:3306
2016-10-01 20:54:53 WARNING [7f6239ffb700] Member 0ec26995-880c-11e6-b615-08002718d305 defined in metadata not found in actual replicaset
2016-10-01 20:54:53 WARNING [7f6239ffb700] Member 3d36134b-87ef-11e6-93be-08002718d305 defined in metadata not found in actual replicaset
2016-10-01 20:54:59 WARNING [7f6241bf9700] No available RW servers found for 'default'
2016-10-01 20:54:59 WARNING [7f6241bf9700] Routing: Can't connect to remote MySQL server on 'mysql1:3306' (error 0)
2016-10-01 20:54:59 WARNING [7f62397fa700] No available RW servers found for 'default'
2016-10-01 20:54:59 WARNING [7f62397fa700] Routing: Can't connect to remote MySQL server on 'mysql1:3306' (error 0)
2016-10-01 20:54:59 WARNING [7f6238ff9700] No available RW servers found for 'default'
2016-10-01 20:54:59 WARNING [7f6238ff9700] Routing: Can't connect to remote MySQL server on 'mysql1:3306' (error 0)
2016-10-01 20:54:59 WARNING [7f6227fff700] No available RW servers found for 'default'
2016-10-01 20:54:59 WARNING [7f6227fff700] Routing: Can't connect to remote MySQL server on 'mysql1:3306' (error 0)
2016-10-01 20:55:00 WARNING [7f6227fff700] No available RW servers found for 'default'

Suggested fix:
I want to see the status of router.

This just demonstrates how basic mysqlrouter is at the moment (the amount of bugs I can think of right now... posting a bug brings 2 new ones...)

Hi,

At the moment you get the info only trough the log file. It's by design. If in future we add more features we'll update the documentation.

Also, please note that bugs system is not a place to ask questions on how to use MySQL products. For that either use MySQL support system or MySQL forum available free to the community.

best regards

I changed it to a S4 Feature Request.

It was closed as not a bug, opening so it can be handled as feature request instead.

verifying as "We could use more reporting" Feature Request :D

all best
Bogdan