Differences

This shows you the differences between two versions of the page.

--- resolution_area:watchdog_resolutions:res-w9803 [2021/06/29 17:09] – btobin
+++ resolution_area:watchdog_resolutions:res-w9803 [2021/07/05 16:44] (current) – 10.91.120.28
@@ Line 4: / Line 4: @@
-**Purpose:**
+**Purpose:** To tell us when replication is not working
-**Scenario:**
+**Scenario:** When the results of this query are 0 (EXT example) //SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE user='slave' AND host LIKE '${expectedConnectedSlaveHost}%//
-**Resolution:**
+**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:**
+**Auto Clear:** Will clear when the query result is not 0

Internal Errigal Collaboration Wiki