Boost Your MySQL Replication Efficiency by 50% with Tagged GTID in MySQL 8.4

Поділитися
Вставка
  • Опубліковано 11 січ 2025

КОМЕНТАРІ • 2

  • @nishant_env
    @nishant_env Місяць тому +1

    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 ?

    • @karthik.p.r3574
      @karthik.p.r3574 Місяць тому

      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 ;