Skip to:
Hi Team,
If we mention socket in the following table then slave/replica don't detected:
master [localhost:23420] {msandbox} (percona) > select * from dsns; +----+-----------+--------------------------------------------------------+ | id | parent_id | dsn | +----+-----------+--------------------------------------------------------+ | 2 | NULL | h=192.168.1.5,u=rpl_user,p=msandbox,S=/tmp/mysql_sandbox23421.sock | | 3 | NULL | h=192.168.1.5,u=rpl_user,p=msandbox,S=/tmp/mysql_sandbox23422.sock | +----+-----------+--------------------------------------------------------+ 2 rows in set (0.001 sec) Example cmd as following: :~/percona-toolkit-3.5.5/bin$ ./pt-table-checksum --user=rpl_user --password=msandbox --host=xx.xx.xx.xx --databases=test --port 23420 --replicate=percona.checksum_"$(date +%Y%m%d%H%M)" --ignore-databases mysql --create-replicate-table --no-check-replication-filters --no-check-plan --recursion-method=dsn=xx.xx.xx.xx,D=percona,t=dsns,u=rpl_user,p=msandbox,P=23420 --no-check-binlog-format --chunk-time 40 --chunk-size-limit 1000 --chunk-index-columns 4 --max-lag 50 Checking if all tables can be checksummed ... Starting checksum ... Diffs cannot be detected because no slaves were found. Please read the --recursion-method documentation for information. TS ERRORS DIFFS ROWS DIFF_ROWS CHUNKS SKIPPED TIME TABLE 11-27T11:39:53 0 0 39 0 1 0 0.009 test.bill_groups 11-27T11:39:53 0 0 4 0 1 0 0.009 test.t1 11-27T11:39:53 0 0 0 0 1 0 0.009 test.t2 Slave could not be detected. This should be detected via socket connection as well.
Hi Team,
If we mention socket in the following table then slave/replica don't detected:
master [localhost:23420] {msandbox} (percona) > select * from dsns; +----+-----------+--------------------------------------------------------+ | id | parent_id | dsn | +----+-----------+--------------------------------------------------------+ | 2 | NULL | h=192.168.1.5,u=rpl_user,p=msandbox,S=/tmp/mysql_sandbox23421.sock | | 3 | NULL | h=192.168.1.5,u=rpl_user,p=msandbox,S=/tmp/mysql_sandbox23422.sock | +----+-----------+--------------------------------------------------------+ 2 rows in set (0.001 sec) Example cmd as following: :~/percona-toolkit-3.5.5/bin$ ./pt-table-checksum --user=rpl_user --password=msandbox --host=xx.xx.xx.xx --databases=test --port 23420 --replicate=percona.checksum_"$(date +%Y%m%d%H%M)" --ignore-databases mysql --create-replicate-table --no-check-replication-filters --no-check-plan --recursion-method=dsn=xx.xx.xx.xx,D=percona,t=dsns,u=rpl_user,p=msandbox,P=23420 --no-check-binlog-format --chunk-time 40 --chunk-size-limit 1000 --chunk-index-columns 4 --max-lag 50 Checking if all tables can be checksummed ... Starting checksum ... Diffs cannot be detected because no slaves were found. Please read the --recursion-method documentation for information. TS ERRORS DIFFS ROWS DIFF_ROWS CHUNKS SKIPPED TIME TABLE 11-27T11:39:53 0 0 39 0 1 0 0.009 test.bill_groups 11-27T11:39:53 0 0 4 0 1 0 0.009 test.t1 11-27T11:39:53 0 0 0 0 1 0 0.009 test.t2 Slave could not be detected. This should be detected via socket connection as well.