AnsweredAssumed Answered

How do we resolve a problem with DatabaseReplicationMonitor error?

Question asked by jcrivkin on Dec 6, 2016
Latest reply on Mar 4, 2017 by RLT

We are experiencing the DatabaseReplicationMonitor problem described in Knowledge Base Articles.  We followed the steps described in the article, but the problem persists.  Shown below are the user grants from our two servers, after having followed the instructions and restarting the servers.  What steps should we take next?  How badly does this issue affect performance?

 

xx-apiprod1

+----------+-------------------------+-------------------------------------------+
| user | host | password |
+----------+-------------------------+-------------------------------------------+
| root | localhost | *78377EDD3733CC2048B9FBB4B0E0299C8720D4FA |
| gateway | xx-apiprod2.thebank.com | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | % | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost6 | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost.localdomain | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost6.localdomain6 | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| repluser | xx-apiprod2.thebank.com | *D98280F03D0F78162EBDBB9C883FC01395DEA2BF |
| repluser | xx-apiprod1.thebank.com | *D98280F03D0F78162EBDBB9C883FC01395DEA2BF |
| gateway | xx-apiprod1.thebank.com | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
+----------+-------------------------+-------------------------------------------+

MN_APIPROD2

+----------+-------------------------+-------------------------------------------+
| user | host | password |
+----------+-------------------------+-------------------------------------------+
| root | localhost | *78377EDD3733CC2048B9FBB4B0E0299C8720D4FA |
| gateway | xx-apiprod1.thebank.com | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | % | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost6 | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost.localdomain | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| gateway | localhost6.localdomain6 | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
| repluser | xx-apiprod1.thebank.com | *D98280F03D0F78162EBDBB9C883FC01395DEA2BF |
| repluser | xx-apiprod2.thebank.com | *D98280F03D0F78162EBDBB9C883FC01395DEA2BF |
| gateway | xx-apiprod2.thebank.com | *B3A15E4C40504F2D5B03FC184F764CB791BBCA02 |
+----------+-------------------------+-------------------------------------------+

Outcomes