I have run into replication errors and eventually just rebuilt the replica. I then had to skip some more transactions and now see there is a large Retrieved_Gtid_Set, and also Executed_Gtid_Set.
I don't really know what that means or why it is like that now - do I ignore it, or is it an indicator of a problem?
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.20.10.13
Master_User: slave_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.008210
Read_Master_Log_Pos: 513971969
Relay_Log_File: db01-relay-bin.000226
Relay_Log_Pos: 191424385
Relay_Master_Log_File: mysql-bin.008210
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 513971969
Relay_Log_Space: 242539308
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 9
Master_UUID: 298e8887-e4be-11e7-8b05-901b0ee415ba
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set: 298e8887-e4be-11e7-8b05-901b0ee415ba:225788633-225902618,
d117fcd4-6238-11e8-8264-901b0eff5c1d:15948357010-15967472486
Executed_Gtid_Set: 298e8887-e4be-11e7-8b05-901b0ee415ba:225788634-225788816:225788821-225788822:225788826-225793296:225793333-225793911:225793914-225793918:225793938-225793970:225793972-225793975:225793979:225793983-225795895:225795897-225797614:225797618:225797620-225797961:225797963-225797964:225797966-225797971:225797973-225798012:225798015:225798018:225798020-225798748:225798754-225798765:225798767-225805055:225805057-225884856:225884859-225884862:225884865-225885026:225885028-225891138:225891142-225891144:225891147-225892668:225892677-225892910:225892912-225893211:225893218-225896744:225896746-225896753:225896755-225900672:225900676-225900985:225900987:225900989-225900990:225900992-225900993:225900995-225901035:225901038-225901661:225901665-225901672:225901674:225901676:225901678-225902156:225902158-225902618,
b46d1a13-ad76-11ed-a0a5-0025b5000013:1-142,
d117fcd4-6238-11e8-8264-901b0eff5c1d:15948357010-15948504521:15948504523-15948520555:15948520557-15948533384:15948533386-15948556197:15948556199-15948565765:15948565767-15948574769:15948574771-15948582994:15948582996-15948592649:15948592651-15948636262:15948636264-15948679600:15948679602-15948723922:15948723924-15948764067:15948764069-15948801994:15948801996-15948851588:15948851590-15948897833:15948897835-15948943629:15948943631-15948951525:15948951527-15949580463:15949580465-15949580481:15949580483-15949815271:15949815273-15949815281:15949815283-15949868265:15949868267-15949922715:15949922717-15949977242:15949977244-15950031764:15950031766-15950079679:15950079681-15950124617:15950124619-15950170466:15950170468-15950196241:15950196243-15950196504:15950196506-15950196876:15950196878-15950197218:15950197220-15950197789:15950197791-15950198223:15950198225-15950198634:15950198636-15950198925:15950198927-15950199176:15950199178-15950199481:15950199483-15950199823:15950199825-15950200041:15950200043-15950200356:15950200358-15950200626:15950200628-15950200890:15950200892-15950201098:15950201100-15950201399:15950201401-15950201610:15950201612-15950201801:15950201803-15950202025:15950202027-15950202212:15950202214-15950202435:15950202437-15950202663:15950202665-15950202914:15950202916-15950203157:15950203159-15950203576:15950203578-15950203837:15950203839-15950204140:15950204142-15950205657:15950205659-15950206474:15950206476-15950207156:15950207158-15950257277:15950257279-15950260222:15950260224-15950260854:15950260856-15950339574:15950339576-15951735992:15951735994-15951736023:15951736025-15965402406:15965402408-15965562520:15965562522-15966184521:15966184523-15966191051:15966191053-15966486814:15966486816-15967472486
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.01 sec)
