Description:
The server has three variables/fields that are identical:
@@global.gtid_executed
SHOW SLAVE STATUS / Executed_Gtid_Set
SHOW MASTER STATUS / Executed_Gtid_Set
These three are identical on *the same* server. However, the manual states it wrongly in two places:
http://dev.mysql.com/doc/refman/5.6/en/show-slave-status.html
"Executed_Gtid_Set
The set of global transaction IDs written in the binary log. This is the same as the master's value for the global gtid_executed system variable (named gtid_done prior to MySQL 5.6.9), as well as the master's value for Executed_Gtid_Set in the output of SHOW MASTER STATUS. Empty if GTIDs are not in use."
http://dev.mysql.com/doc/refman/5.6/en/show-master-status.html
"The Executed_Gtid_Set column was added in MySQL 5.6.5. When global transaction IDs are in use, this column shows the set of GTIDs for transactions that have been executed on the master. This is the same as the master's value for the global gtid_executed system variable (named gtid_done prior to MySQL 5.6.9), as well as the slave's value for Executed_Gtid_Set in the output of SHOW SLAVE STATUS."
Both these formulations suggest that the values are equal when comparing them on different servers. This is not true.
How to repeat:
-
Suggested fix:
http://dev.mysql.com/doc/refman/5.6/en/show-slave-status.html
"Executed_Gtid_Set
The set of global transaction IDs written in the binary log. This is the same as the value for the global gtid_executed system variable (named gtid_done prior to MySQL 5.6.9) on this server, as well as the value for Executed_Gtid_Set in the output of SHOW MASTER STATUS on this server. Empty if GTIDs are not in use."
http://dev.mysql.com/doc/refman/5.6/en/show-master-status.html
"The Executed_Gtid_Set column was added in MySQL 5.6.5. When global transaction IDs are in use, this column shows the set of GTIDs for transactions that have been executed on the master. This is the same as the value for the global gtid_executed system variable (named gtid_done prior to MySQL 5.6.9) on this server, as well as the value for Executed_Gtid_Set in the output of SHOW SLAVE STATUS on this server."