Not the answer you need?
Register and ask your own question!

pt-table-sync - connections name and multisource replication

rl_spark5rl_spark5 EntrantCurrent User Role Beginner
hi, great to be here ... i found nothing in the forum, or i am to blind

we are using pt-table-sync in a way like "pt-table-sync --sync-to-master --print|--execute -u........"
now we have an multisource slave and our master-master setup is also using connection names.
show slave 'vs-db-s01' status\G; for example is working.

now i would like to use pt-table-sync, but i got "Can't determine master"
in strace, i saw, that pt-table-sync uses "show slave status" statement, which is not working with connection names.

am i to stupid or did i not understood anything? :)

could you please help me, an tell, how to use it?

short setup explanation:
- master-master replication with one multisource slave
- only one master is active and written, the second will be used as slave
- the multisource slave is for backup, and standby
- all server has the same gtid-domain-id
- software is mariadb 10.1.26 on debian stretch
- percona-toolkit is 2.2.20
- replication setup via "CHANGE MASTER 'vs-db-s01' TO MASTER_HOST=...."

thanks for help and kind regards,


  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role

    Current Toolkit version is 3.0.10. Can you upgrade to the latest version?

  • rl_spark5rl_spark5 Entrant Current User Role Beginner
    hi carlos,
    maybe we can try an upgrade, but we love distribution based package management :)

    what i found, is, that pt-table-sync uses show slave status statement, which is not working in multisource replication.
    i found a session variable "default_master_connection".
    Description: In multi-source replication, specifies which connection will be used for commands and variables if you don't specify a connection.

    i got pt-table-sync running, with: "pt-table-sync --set-vars default_master_connection=\'vs-db-s01\' --sync-to-master ..."

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.