When the IO state is in the Yes/No state, the below query is working fine, but when the IO state is in the Connecting state, the below query is not working, and we are not able to receive the alerts.
Query: mysql_slave_status_master_server_id > 0 and ON (instance) mysql_slave_status_slave_io_running == 0
But as per the below screenshot, on the Replication Dashboard, the IO thread status is NO.
And on the DB server, the IO thread status
But when I change the query like below, then it’s working fine.
mysql_slave_status_master_server_id == 0 and ON (instance) mysql_slave_status_slave_io_running == 0
NOTE: Even Replication error number also missing on the dashboard.