Which toolkit version for both 5.7.29 and 5.1.73?

[Gibble]

Hi. We’re slowly migrating from 5.1.73 to 5.7.29 (and then later to 8, but need an intermediate step for compatibility).

Is there a toolkit version which supports both, or are all the toolkit versions backwards compatible for older versions of mysql, I can’t dig out that info anywhere.

Mainly we want to update some fields without locking, so hoping pt-online-schema-change will be working for those versions ?

Thanks in advance.

[igroene]

Hello @Gibble the latest percona toolkit should still work fine with 5.1 as well as 5.7. That being said, there might be some edge cases. So make sure to run it on a testing environment first and let us know if you find any issues.

[VesaK]

We’re trying to first replicate (with intent to upgrade) from MySQL 5.0 to 5.7 and current pt-table-checksum gives errors about utf8mb4, which is not used in our database because it was not supported in 5.0. Any idea which older toolkit version we should go back to?