pt-table-checksum on master with slaves behind VPN

[Daantie]

Hello!

I’m working with a master with several slaves. Some of those slaves are in a VPN and can’t be reached from the outside. The master is not in this VPN, so obviously when I run pt-table-checksum on the master the program is not able to connect to those slaves. So my question is: is it in any way possible to run pt-table-checksum and find differences on those slaves in the VPN? Will it work to run the command on a server inside this VPN and use --recursion-method option and provide DSNs with IPs inside the VPN?

Thanks in advance!

[carlos.salguero]

Hi,

You can use --recursion-method=dsn: https://www.percona.com/doc/percona-toolkit/LATEST/pt-table-checksum.html#cmdoption-pt-table-checksum-recursion-method and put in the dsns table only the host you can access.

Regards

[Daantie]

Hello Carlos,

Thanks for your reply. Using only --recursion-method=dsn won’t help me checksum the slaves I can’t access from the master. Luckily I already fixed the problem. The solution I found was to setup a reverse SSH tunnel from the slaves in the VPN to the master, and then use --recursion-method=dsn to connect via this tunnel.

I hope this solution will be helpful for other people facing this problem!

Cheers!