# Remove obsolette servers UID from Executed\_Gtid\_Set

**URL:** <https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [July 28, 2022, 12:12pm UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794 "2022-07-28T12:12:16Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deniska80](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Deniska80](https://forums.percona.com/u/Deniska80)\
**Post date:** [July 28, 2022, 12:12pm UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/1 "2022-07-28T12:12:16Z")

</div>

Hello. On my master server _show master status_ returns bunch of servers uuid in **Executed\_Gtid\_Set** field. Mosft of this servers are not exist anymore, so transcation id increases only for this server uid.  
But if i want to create another slave i have to copy all this old servers uid in GTID\_PURGED, otherwise i’get error, that master has not binary logs for this ild uids. So, the question - is there a way to cut off these old uid’s ?

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [July 28, 2022, 12:32pm UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/2 "2022-07-28T12:32:34Z")

</div>

Unfortunately there is no way to do this easily at the moment. You need to run RESET MASTER but that will break any replicas, so you will need to develop a plan to run it on a rolling fashion.

---

<div class="post-metadata">

**Author:** ![Deniska80](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Deniska80](https://forums.percona.com/u/Deniska80)\
**Post date:** [July 28, 2022, 12:46pm UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/3 "2022-07-28T12:46:02Z")

</div>

> [@Ivan\_Groenewold](#):
>
> You need to run RESET MASTER

I’m i understand right, that it needs to be done on master? If “yes” then broken replicas is not the worse things 🙂 This implies stop master for a while, and then set GTID\_PURGED on master with existing servers uid only?

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [July 28, 2022, 1:18pm UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/4 "2022-07-28T13:18:18Z")

</div>

Correct, you need to stop the master and after replicas are up-to-date, then run reset master on primary and all the replicas as well, to start fresh. I recommend you to test this process on a non-prod environment first.

---

<div class="post-metadata">

**Author:** ![Deniska80](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Deniska80](https://forums.percona.com/u/Deniska80)\
**Post date:** [July 29, 2022, 5:14am UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/5 "2022-07-29T05:14:59Z")

</div>

Ok, and what about this approach, is it safely ?  
Suppose, i’ve master with Executed\_Gtid\_Set like this “A:1-100, B:1-000”, where B is uuid of master and A is uid of old server that not exists any more. So, i will create copy of this master with xtrabackup, but before start this copy on new slave i manually create auto.conf with uid A, and my new slave will have uid A and not auto-generated.  
Sounds like plan, but im not absolutelly sure.

---

<div class="post-metadata">

**Author:** ![Deniska80](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Deniska80](https://forums.percona.com/u/Deniska80)\
**Post date:** [August 1, 2022, 6:52am UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/6 "2022-08-01T06:52:46Z")

</div>

Can i ask you opinion about my last post?

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [August 1, 2022, 3:43pm UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/7 "2022-08-01T15:43:38Z")

</div>

That approach should work but it doesn’t really help you get rid of all the extra GTID sets you already have

---

<div class="post-metadata">

**Author:** ![Deniska80](https://avatars.discourse-cdn.com/v4/letter/d/db5fbb/32.png) [@Deniska80](https://forums.percona.com/u/Deniska80)\
**Post date:** [August 2, 2022, 6:59am UTC](https://forums.percona.com/t/remove-obsolette-servers-uid-from-executed-gtid-set/16794/8 "2022-08-02T06:59:07Z")

</div>

Yes, but at least this stop growing Executed\_Gtid\_Set with old servers UUID
