User Tools
resolution_area:watchdog_resolutions:res-w9803
mysqlFailure
Level: Critical
Purpose: To tell us when replication is not working
Scenario: When the results of this query are 0 (EXT example) SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE user='slave' AND host LIKE '${expectedConnectedSlaveHost}%
Resolution: make sure the user exists on the master DB
Manual Action Steps:
- CREATE USER '$USERNAME'@'$HOST' IDENTIFIED BY '$PASSWORD'
- GRANT REPLICATION SLAVE ON *.* TO '$USERNAME'@'$HOST';
Auto Clear: Will clear when the query result is not 0
resolution_area/watchdog_resolutions/res-w9803.txt · Last modified: 2021/07/05 16:44 by 10.91.120.28