mysql database differences in 5.7 with GTID

[monty solomon]

Update pt-table-checksum to deal with dynamic tables in MySQL 5.7 when using GTID. The tables are likely to contain different values.

Consider automatically excluding the dynamic mysql.gtid_executed table.

For example,

% pt-table-checksum --no-check-binlog-format --function murmur_hash -h empty-sun --recursion-method hosts
            TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
04-30T02:31:59 0 0 1 1 0 0.060 heartbeat.heartbeat
04-30T02:31:59 0 0 0 1 0 0.061 mysql.columns_priv
04-30T02:31:59 0 0 18 1 0 0.059 mysql.db
04-30T02:31:59 0 0 2 1 0 0.057 mysql.engine_cost
04-30T02:31:59 0 0 0 1 0 0.060 mysql.event
04-30T02:31:59 0 0 3 1 0 0.062 mysql.func
04-30T02:32:00 0 1 1 1 0 0.059 mysql.gtid_executed
04-30T02:32:00 0 0 40 1 0 0.057 mysql.help_category
04-30T02:32:00 0 0 671 1 0 0.059 mysql.help_keyword
04-30T02:32:00 0 0 1307 1 0 0.058 mysql.help_relation
04-30T02:32:00 0 0 630 1 0 0.061 mysql.help_topic
04-30T02:32:00 0 0 0 1 0 0.059 mysql.ndb_binlog_index
04-30T02:32:00 0 0 3 1 0 0.058 mysql.plugin
04-30T02:32:00 0 0 47 1 0 0.060 mysql.proc
04-30T02:32:00 0 0 0 1 0 0.059 mysql.procs_priv
04-30T02:32:00 0 0 6 1 0 0.060 mysql.proxies_priv
04-30T02:32:00 0 0 6 1 0 0.060 mysql.server_cost
04-30T02:32:01 0 0 0 1 0 0.312 mysql.servers
04-30T02:32:01 0 0 1 1 0 0.058 mysql.tables_priv
04-30T02:32:01 0 0 1765 1 0 0.060 mysql.time_zone
04-30T02:32:01 0 0 0 1 0 0.057 mysql.time_zone_leap_second
04-30T02:32:01 0 0 1765 1 0 0.061 mysql.time_zone_name
04-30T02:32:01 0 0 118426 4 0 0.519 mysql.time_zone_transition
04-30T02:32:02 0 0 8296 1 0 0.324 mysql.time_zone_transition_type
04-30T02:32:02 0 0 25 1 0 0.063 mysql.user
04-30T02:32:02 0 0 6 1 0 0.060 sys.sys_config

% pt-table-checksum --no-check-binlog-format --function murmur_hash -h empty-sun --recursion-method hosts --replicate-check-only
Differences on shrill-limit
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
mysql.gtid_executed 1 0 1

Differences on bold-band
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
mysql.gtid_executed 1 0 1

Comparing dumps of the two tables

275c275
< INSERT INTO `gtid_executed` VALUES ('7ace11db-0cec-11e6-a720-0a926162b38d',1,169669);
---
> INSERT INTO `gtid_executed` VALUES ('7ace11db-0cec-11e6-a720-0a926162b38d',1,170176);

[monty solomon (monty+launchpad)]

pt-table-checksum 2.2.17

mysql Ver 14.14 Distrib 5.7.11-4, for Linux (x86_64) using 6.0
Server version: 5.7.11-4-log Percona Server (GPL), Release 4, Revision 5c940e1
CentOS release 6.7 (Final)

[monty solomon (monty+launchpad)]

Status please?

[monty solomon (monty+launchpad)]

The bug status is still Undecided. Has this bug been triaged?

[Jericho Rivera (jericho-rivera)]

https://bugs.launchpad.net/percona-toolkit/+bug/1642994

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-830