I have 6 servers. A & B are master<->master replicates. A1 and A2 are slaves from A. B1 and B2 are slaves from B.
I want to run pt-table-checksum to compare tables between A & B. I don’t care about the read only slaves, A1, A2, B1, and B2. (In fact, from A the 3306 port to A1 is not open so I cannot even get to A1 from A but obviously I can reach A from A1.) I cannot seem to figure out how to restrict pt-table-checksum from considering A1 and A2 and everytime I run the utility it generates errors trying to reach A1 and A2 yet never seems to do the compare to B. I’m sure this is operator error.