The Ultimate Guide to High Availability with MariaDB

Comments - Is there any way to know if the replication thread is executing the DML?

5 years, 4 months ago Manu Anttila
Re: Is there any way to know if the replication thread is executing the DML? [Answer]

Okay. In the trigger I check if it is a local process that has executed the DML by querying the ID+HOST in information_schema.processlist and comparing them to CONNECTION_ID()+USER(). I can make the decision based on that.

MariaDB [xxx]> select LocalProcess();
+----------------+
| LocalProcess() |
+----------------+
|              1 |
+----------------+

This question can be removed or marked as answered on my behalf.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.