# How safe is it to turn on GTID after x time?

**URL:** <https://forums.percona.com/t/how-safe-is-it-to-turn-on-gtid-after-x-time/11553>\
**Category:** Percona XtraDB Cluster 5.x\
**Tags:** mysql, percona\
**Created:** [July 27, 2021, 2:07pm UTC](https://forums.percona.com/t/how-safe-is-it-to-turn-on-gtid-after-x-time/11553 "2021-07-27T14:07:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![b.roland96](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/b.roland96/32/4055_2.png) [@b.roland96](https://forums.percona.com/u/b.roland96)\
**Post date:** [July 27, 2021, 2:07pm UTC](https://forums.percona.com/t/how-safe-is-it-to-turn-on-gtid-after-x-time/11553/1 "2021-07-27T14:07:29Z")

</div>

Hi guys!

I have 2 percona galera cluster with 3-3 node. My config is very simple because i learn time to time, and now i finded GTID. I read now some blog post, docs about that and i read somewhere that it is avoid to turn on after x time. In my first cluster i have 200 gb data and the second cluster i have 40x gb data.  
Can i turn on normally GTID or not?  
where can there be a mistake?

(mysql Ver 14.14 Distrib 5.7.33-36, for debian-linux-gnu (x86\_64) using 7.0)

Thank you very much any link, blog post or explanation.

---

<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:** [July 27, 2021, 5:08pm UTC](https://forums.percona.com/t/how-safe-is-it-to-turn-on-gtid-after-x-time/11553/2 "2021-07-27T17:08:39Z")

</div>

Are you replicating between these clusters, or are the clusters independent? If your clusters are independent, then GTID makes no difference here. GITD is only used for async replication (ie: master/slave, source/replica). Since you are using PXC/Galera, there is no async replication.

---

<div class="post-metadata">

**Author:** ![b.roland96](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/b.roland96/32/4055_2.png) [@b.roland96](https://forums.percona.com/u/b.roland96)\
**Post date:** [July 28, 2021, 6:45am UTC](https://forums.percona.com/t/how-safe-is-it-to-turn-on-gtid-after-x-time/11553/3 "2021-07-28T06:45:23Z")

</div>

Independent.  
I want to setup 1 slave for DR and i think it is easier to setup with GTID, just i need to turn on first.

---

<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:** [July 28, 2021, 2:19pm UTC](https://forums.percona.com/t/how-safe-is-it-to-turn-on-gtid-after-x-time/11553/4 "2021-07-28T14:19:19Z")

</div>

@b.roland96 Yes, GTID will be much easier. You can certainly turn on GTID and you can do it in progressive stages online, like this: Do each command on each node in the cluster before going to the next command.

```
SET GLOBAL gtid_mode=OFF_PERMISSIVE;
SET GLOBAL gtid_mode=ON_PERMISSIVE;
SET GLOBAL gtid_mode=ON;

```