1

I believe I have an issue of sorts with MySQL Replication on the slaves. Instead of there being one clean GTID under 'Executed GTID Set' there are multiple GTIDs.

Retrieved_Gtid_Set: 54206435-24c7-11e5-bd59-1458d055bee8:354806-354826
Executed_Gtid_Set: 54206435-24c7-11e5-bd59-1458d055bee8:1-354826, cd975336-24c7-11e5-bd5c-1458d04f9808:1-24

I've tried a slave reset all but this doesn't seem to clear it.

Has anyone seen this before? What might be the best way of resolving this?

Thanks in advance

fancyPants
  • 50,732
  • 33
  • 89
  • 96
user2841861
  • 423
  • 2
  • 8
  • 22

1 Answers1

1

There's nothing to solve here. These are just GTIDs of different servers.

The first part of a GTID is the UUID (unique universal ID, or something like that, IIRC).

54206435-24c7-11e5-bd59-1458d055bee8:354806-354826
<........host......................>:<...GTIDs...>

I'd guess, that these are GTIDs from the master and the localhost in your executed GTID set.

When you do show slave status\G on the slave there's also a line like this:

Master_UUID: ee624d91-76da-11e4-8f3a-ecf4bbce03bc

which tells you the UUID of the master. On the master you can do

root@localhost:(none) > show slave hosts;
+-----------+------+------+-----------+--------------------------------------+
| Server_id | Host | Port | Master_id | Slave_UUID                           |
+-----------+------+------+-----------+--------------------------------------+
|         2 |      | 3306 |         1 | c5ca7103-2eb7-11e5-be29-0050569b085a |
+-----------+------+------+-----------+--------------------------------------+

In summary, everything's normal. These are most likely GTIDs from your master and some statements you executed on the slave.

fancyPants
  • 50,732
  • 33
  • 89
  • 96
  • Thanks for your comments. So I've just taken another look at this. On one of my slaves I have....Executed_Gtid_Set: 54206435-24c7-11e5-bd59-1458d055bee8:1-354833, d6dd8872-2c09-11e5-acb1-fa163eed3b8d:352187-352189, fc6f4679-24c7-11e5-bd5e-1458d04fca70:1-13 On the master when I run 'show slave hosts' there isn't an entry returned for d6dd8872-2c09-11e5-acb1-fa163eed3b8d:352187-352189. So not sure where this ID is from. It doesn't seem to be in the replication topology. Someone here thinks it's from cloning??? – user2841861 Jun 21 '16 at 08:38
  • The answer is correct. In my case, I had run a query directly on the replica server, which resulted in two gtid sets. Also, I did ```RESET REPLICA``` on the replica server, before ```START REPLICA``` , but it did not seem to reset the gtid – Madhur Bhaiya Jan 26 '23 at 11:34