Differences

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

--- resolution_area:watchdog_resolutions:res-w9803 [2021/06/25 10:09] – external edit 127.0.0.1
+++ resolution_area:watchdog_resolutions:res-w9803 [2021/07/05 16:44] (current) – 10.91.120.28
@@ Line 1: / Line 1: @@
 =====mysqlFailure=====
-**Level:** __Critical__
+**Level:** __Critical__ FIXME
-**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