# Peoples opinion of GTID replication

**URL:** <https://forums.percona.com/t/peoples-opinion-of-gtid-replication/31084>\
**Category:** Percona Distribution for MySQL\
**Created:** [June 18, 2024, 5:24pm UTC](https://forums.percona.com/t/peoples-opinion-of-gtid-replication/31084 "2024-06-18T17:24:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jamie\_Downs](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jamie_downs/32/5836_2.png) [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\
**Post date:** [June 18, 2024, 5:24pm UTC](https://forums.percona.com/t/peoples-opinion-of-gtid-replication/31084/1 "2024-06-18T17:24:29Z")

</div>

Hello,  
We are thinking of changing over from traditional replication to gtid replication.  
I would be interested in peoples opinion on gtid replication are there any gotchas we should be aware of?  
Thanks for your thoughts.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [June 18, 2024, 7:37pm UTC](https://forums.percona.com/t/peoples-opinion-of-gtid-replication/31084/2 "2024-06-18T19:37:22Z")

</div>

Hello @Jamie_Downs,  
GTID makes things pretty simple as you no longer have to worry about binlog files and positions. I’d say the #1 issue I run into is missing GTIDs when promoting a replica. Let’s say you have a simple S-\>R setup. You run something seemingly harmless on the R like creating a new user. Your GTID set now contains GTIDs from S and separate GTID from the R itself. Now, S goes down and R becomes the new S (S’). The new S’ continues running the app. S comes back online and tries to connect to S’ as a R (R’). But S’ cannot replicate to R’ because there’s missing GTIDs as those events are no longer in S’ binlogs.

Check out this blog: [Errant transactions: Major hurdle for GTID-based failover](https://www.percona.com/blog/errant-transactions-major-hurdle-for-gtid-based-failover-in-mysql-5-6/)

Any customer that I configure replication for I use GTIDs as they are slowly becoming the new standard.

---

<div class="post-metadata">

**Author:** ![Jamie\_Downs](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jamie_downs/32/5836_2.png) [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\
**Post date:** [June 19, 2024, 9:00am UTC](https://forums.percona.com/t/peoples-opinion-of-gtid-replication/31084/3 "2024-06-19T09:00:13Z")

</div>

Thanks @matthewb ,  
This is good to know. Especially:  
“_Any customer that I configure replication for I use GTIDs as they are slowly becoming the new standard._”

Does anyone have any experiences to share? Thanks.