Hi Frank,
That's true. My both nodes have the same server-id, when I change it in another node, it worked.
[root@percona-pxc55-1 ~]# pt-table-checksum --recursion-method=cluster --user=root --password=root Not checking replica lag on percona-pxc55-2 because it is a cluster node. TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE 09-09T23:44:45 0 0 0 1 0 0.367 mysql.columns_priv 09-09T23:44:45 0 0 2 1 0 0.129 mysql.db 09-09T23:44:45 0 0 0 1 0 0.096 mysql.event 09-09T23:44:45 0 0 0 1 0 0.092 mysql.func 09-09T23:44:45 0 0 40 4 0 0.431 mysql.help_category 09-09T23:44:46 0 0 467 4 0 0.405 mysql.help_keyword 09-09T23:44:46 0 0 1048 1 0 0.110 mysql.help_relation 09-09T23:44:46 0 0 510 1 0 0.106 mysql.help_topic 09-09T23:44:46 0 0 0 1 0 0.086 mysql.host 09-09T23:44:46 0 0 0 1 0 0.131 mysql.ndb_binlog_index 09-09T23:44:46 0 0 0 1 0 0.100 mysql.plugin 09-09T23:44:47 0 0 0 1 0 0.126 mysql.proc 09-09T23:44:47 0 0 0 1 0 0.104 mysql.procs_priv 09-09T23:44:47 0 0 2 1 0 0.105 mysql.proxies_priv 09-09T23:44:47 0 0 0 1 0 0.095 mysql.servers 09-09T23:44:47 0 0 0 1 0 0.107 mysql.tables_priv 09-09T23:44:47 0 0 0 1 0 0.107 mysql.time_zone 09-09T23:44:47 0 0 0 1 0 0.092 mysql.time_zone_leap_second 09-09T23:44:47 0 0 0 1 0 0.100 mysql.time_zone_name 09-09T23:44:47 0 0 0 1 0 0.088 mysql.time_zone_transition 09-09T23:44:47 0 0 0 1 0 0.087 mysql.time_zone_transition_type 09-09T23:44:48 0 1 9 1 0 0.107 mysql.user 09-09T23:44:49 0 0 100000 6 0 1.325 sbtest.sbtest 09-09T23:44:49 0 0 110064 1 0 0.443 sbtest.sbtest1 09-09T23:44:50 0 0 0 1 0 0.104 test.black 09-09T23:44:50 0 0 1 1 0 0.102 test.inno 09-09T23:44:50 0 0 0 1 0 0.110 test.mem 09-09T23:44:50 0 0 0 1 0 0.118 test.nil 09-09T23:44:54 0 0 2097152 9 0 3.633 test.t1 09-09T23:44:54 0 0 2 1 0 0.101 test.tb1 09-09T23:44:54 0 0 3 1 0 0.104 test2.t2 [root@percona-pxc55-1 ~]#
Hi Frank,
That's true. My both nodes have the same server-id, when I change it in another node, it worked.
[root@percona- pxc55-1 ~]# pt-table-checksum --recursion- method= cluster --user=root --password=root binlog_ index zone_leap_ second zone_name zone_transition zone_transition _type pxc55-1 ~]#
Not checking replica lag on percona-pxc55-2 because it is a cluster node.
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-09T23:44:45 0 0 0 1 0 0.367 mysql.columns_priv
09-09T23:44:45 0 0 2 1 0 0.129 mysql.db
09-09T23:44:45 0 0 0 1 0 0.096 mysql.event
09-09T23:44:45 0 0 0 1 0 0.092 mysql.func
09-09T23:44:45 0 0 40 4 0 0.431 mysql.help_category
09-09T23:44:46 0 0 467 4 0 0.405 mysql.help_keyword
09-09T23:44:46 0 0 1048 1 0 0.110 mysql.help_relation
09-09T23:44:46 0 0 510 1 0 0.106 mysql.help_topic
09-09T23:44:46 0 0 0 1 0 0.086 mysql.host
09-09T23:44:46 0 0 0 1 0 0.131 mysql.ndb_
09-09T23:44:46 0 0 0 1 0 0.100 mysql.plugin
09-09T23:44:47 0 0 0 1 0 0.126 mysql.proc
09-09T23:44:47 0 0 0 1 0 0.104 mysql.procs_priv
09-09T23:44:47 0 0 2 1 0 0.105 mysql.proxies_priv
09-09T23:44:47 0 0 0 1 0 0.095 mysql.servers
09-09T23:44:47 0 0 0 1 0 0.107 mysql.tables_priv
09-09T23:44:47 0 0 0 1 0 0.107 mysql.time_zone
09-09T23:44:47 0 0 0 1 0 0.092 mysql.time_
09-09T23:44:47 0 0 0 1 0 0.100 mysql.time_
09-09T23:44:47 0 0 0 1 0 0.088 mysql.time_
09-09T23:44:47 0 0 0 1 0 0.087 mysql.time_
09-09T23:44:48 0 1 9 1 0 0.107 mysql.user
09-09T23:44:49 0 0 100000 6 0 1.325 sbtest.sbtest
09-09T23:44:49 0 0 110064 1 0 0.443 sbtest.sbtest1
09-09T23:44:50 0 0 0 1 0 0.104 test.black
09-09T23:44:50 0 0 1 1 0 0.102 test.inno
09-09T23:44:50 0 0 0 1 0 0.110 test.mem
09-09T23:44:50 0 0 0 1 0 0.118 test.nil
09-09T23:44:54 0 0 2097152 9 0 3.633 test.t1
09-09T23:44:54 0 0 2 1 0 0.101 test.tb1
09-09T23:44:54 0 0 3 1 0 0.104 test2.t2
[root@percona-