Description:
Dear experts,
I have Stopped Master server and used:
[root@linuxsrv3 ~]# mysqlrplshow --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
# master on localhost: ... FAILED.
ERROR: Cannot connect to the master server.
Error Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
Also Stopped slave server:
[root@linuxsrv3 ~]# mysqlrplshow --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
# master on localhost: ... connected.
# Finding slaves for master: localhost:3306
Error connecting to a slave as remote2@192.168.1.88: Cannot connect to the slave server.
Error Can't connect to MySQL server on '192.168.1.88:3306' (111 Connection refused)
WARNING: There are slaves that had connection errors.
# Replication Topology Graph
No slaves found.
On both sutiations it shows "Connection refused" instead of Master MySQL has stopped or Slave Server has stopped etc.
How to repeat:
Stop Master server and use:
mysqlrplshow --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
Stop Slave server:
mysqlrplshow --master=root:12345@localhost --discover-slaves-login='remote2':'Pass@123#' -vvv
Suggested fix:
Maybe, detecting if master server running or not and slave server is running or not and show an informative error message instead of "Connection refused".