GTID Replication failure - see transaction and user?
Posted by: Van Stokes
Date: August 01, 2018 07:01AM
OS: Ubuntu 16.04
MySQL Server: 5.7.22 (MySQL APT repository)
We have a round-robin master-slave GTID replication. Each application has is suppose to have its own master server. Occasionally we have a replication stoppage because a table is missing a record. Usually it's a DELETE or UPDATE transaction. We have been trying to track down the source of this issue and we suspect one of our applications is erroneously using the wrong master server. Is there a way to view the transaction in the relay log and the user that initiated it? The user will help us narrow down the application as each application uses a unique user login.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.