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

MySQL & MariaDB Percona XtraDB Cluster 5.x
,
1

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.

1 Like
2

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.

1 Like
3

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.

1 Like
4

@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;