User Tools

Site Tools


resolution_area:watchdog_resolutions:res-w9803

mysqlFailure

Level: Critical FIXME

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:

  1. CREATE USER '$USERNAME'@'$HOST' IDENTIFIED BY '$PASSWORD'
  2. 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