Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1034170
  2. Comment #5

Comment 5 for bug 1034170

Revision history for this message
Daniel Nichter (daniel-nichter) wrote : Re: --defaults-file is ignored for slave(s) in pt-table-checksum

Ryan, you're correct. Explicit host=foo in the DSN override whatever is in the defaults file. I think my previous problem with this was related to the recursion method. If master host DSN is just F=/tmp/12345/my.sandbox.cnf, then MasterSlave doesn't see that it's a non-standard port, so it uses proclist rather than SHOW SLAVE HOSTS, and proclist shows the slave on localhost, so the tool tries to connect to it like

# MasterSlave:3186 33943 Recursing from F=/tmp/12345/my.sandbox.cnf,h=localhost,t=HASH(0x100ac0690) to F=/tmp/12345/my.sandbox.cnf,h=127.0.0.1

which doesn't work--it needs the slave's special port, 12346. When I add --recursion-method hosts, then it works:

# MasterSlave:3186 33946 Recursing from F=/tmp/12345/my.sandbox.cnf,h=localhost,t=HASH(0x100abfa90) to F=/tmp/12345/my.sandbox.cnf,P=12346,h=127.0.0.1

So, I'll set copy: yes on F (like Raghu said) and test and make sure it doesn't blow up. If it does, you know who gets all the blame. :-D