Toolkit - pt-table-checksum - MariaDB 10.5

Polyglot Projects Percona Toolkit
1

I am trying to perform a replication audit between two MariaDB 10.5 instances using pt-table-checksum....
I am encountering errors, despite the options to bypass the checks.
I created a percona.dsns table with the following entries:

h=IP_MASTER,P=3306,u=checksum_user,p=PWD
h=IP_SLAVE,P=3306,u=checksum_user,p=PWD
D=percona,u=checksum_user,p=RepL7J,t=dsns

My command is as follows:

pt-table-checksum --no-check-binlog-format --host=IP_MASTER --ignore-databases mysql,percona,performance_schema,information_schema --user=checksum_user --password=PWD --recursion-method=dsn=h=IP_MASTER,D=percona,t=dsns

Is there an incompatibility issue between Percona and MariaDB?

Thank you all.

2

Hi @alfadown,
It would be helpful to see any error messages so we know what isn’t working. Also, please execute like this: $ PTDEBUG=1 pt-table-checksum --no-check-binlog-format ... to collect debug information.

3

Hi,

Thank you,

I was using the latest version of Toolskit 3.7.0…
I replaced the packages with version 3.2.1, and I no longer get any error messages.

The error was related to detecting binlogs using the command: SHOW binary log STATUS.

Now I have to catch up :frowning:
Thanks for your feedback.

4

I opened a JIRA for tracking MariaDB 10.5 support in Percona Toolkit.

1 Like