Seems helpful when a dba is performing the deletes manually, where he issues an additional command at the beginning to set the tagged GTID. How do we inject tagged gtid on an existing application which is performing deletes? Should we make changes on the application level, or is there a way to specify this tag on database server level which tags all delete operations/ or deletes coming from a specific user or host with the tag ?
Thanks for your query. The git id can be injected as a session with the deletes. Sample Syntax: SET gtid_next='automatic:'; -- Execute the delete operation DELETE FROM WHERE ;
Seems helpful when a dba is performing the deletes manually, where he issues an additional command at the beginning to set the tagged GTID. How do we inject tagged gtid on an existing application which is performing deletes? Should we make changes on the application level, or is there a way to specify this tag on database server level which tags all delete operations/ or deletes coming from a specific user or host with the tag ?
Thanks for your query.
The git id can be injected as a session with the deletes.
Sample Syntax:
SET gtid_next='automatic:';
-- Execute the delete operation
DELETE FROM WHERE ;