18 reputation
5
bio website jimenezconsult.com/blog
location South San Francisco, CA
age 26
visits member for 2 years, 6 months
seen 2 days ago

[about me]


Mar
28
awarded  Autobiographer
Mar
28
awarded  Scholar
Mar
28
accepted pt-table-checksum with slaves using non-standard ports
May
16
awarded  Popular Question
Feb
1
comment pt-table-checksum with slaves using non-standard ports
I am not using the flag to write the results to a table, they are just going to stdout.
Feb
1
comment pt-table-checksum with slaves using non-standard ports
Thanks Baron, that is super helpful!!
Feb
1
awarded  Supporter
Feb
1
comment pt-table-checksum with slaves using non-standard ports
@atxdba Im skeptical that it doesn't need to connect, one because of that error it prints out when it runs, and two because I performed it on a slave that was at least 5000 seconds behind the master, so there would be no way for the slave to have gotten to that part in the binlogs in the time the tool ran. It also shows there to be know diffs between all my tables which I know for other reasons probably isn't true :-)
Feb
1
comment pt-table-checksum with slaves using non-standard ports
Thanks, I am using 2.02 of the toolkit. So for the DSN table, it should be in a separate database on the master mysql server? Also, should all the slaves DSN information be in one column in that table (h=0.0.0.0,P=3388,p=password)?
Feb
1
comment pt-table-checksum with slaves using non-standard ports
Thanks for the further detail on that. So what I am seeing happening is the tool is connecting to the master mysql, but it is not connecting to the slave. When I run it I see the following error: 'Cannot connect to P=3306,h=,p=...' Which makes me think that it is trying to connect to the slaves on the standard port and is not able. It can in fact connect to the master on the special port because it is listing the tables as it runs through the check-sums. I did notice the SHOW SLAVE HOSTS command on the master has the same faulty information about the port of the connected slave.
Feb
1
comment pt-table-checksum with slaves using non-standard ports
Thanks that's super helpful. Maybe I am not understanding something fundamental here, but if you don't use the --replicate option to have it replicate through your slaves, how would you be able to compare the check-sums between master and slave hosts? Wouldn't that defeat the purpose? Or can it still perform checksums on the slaves without using the --replicate option?
Feb
1
awarded  Student
Feb
1
asked pt-table-checksum with slaves using non-standard ports