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

recommended "ignores" for pt-table-checksum on percona server for mysql 8.0?

Matthew LenzMatthew Lenz Current User Role Participant
I'd like to be sure my accounts and permissions are intact between the servers so skipping the mysql table outright isn't something I'd like to do.  I'm not running with GTID enabled just regular master/slave replication.  What what you guys recommend as a good starting point for database and/or table ignores?

Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role Advisor
    Hi Matthew,
    I'm not quite sure what you are trying to accomplish. You say you don't want to skip the mysql.* tables, but then you said you wanted to ensure accounts are the same. That would be the only way to accomplish this; run pt-table-checksum for all mysql.* tables between source and replicas. If there are any differences, the chunk checksums will be different.
    As best practice, I would not recommend ignoring any tables. You want your replicas to be true copies of your source in case of disaster recovery/promotion.
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.