# Best practice for pt-table-checksum frequency in Oracle Unified Assurance active-active MySQL setup

**URL:** <https://forums.percona.com/t/best-practice-for-pt-table-checksum-frequency-in-oracle-unified-assurance-active-active-mysql-setup/41144>\
**Category:** MySQL & MariaDB\
**Tags:** percona\
**Created:** [August 6, 2026, 8:41am UTC](https://forums.percona.com/t/best-practice-for-pt-table-checksum-frequency-in-oracle-unified-assurance-active-active-mysql-setup/41144 "2026-08-06T08:41:42Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 17, 2026, 3:23pm UTC](https://forums.percona.com/t/best-practice-for-pt-table-checksum-frequency-in-oracle-unified-assurance-active-active-mysql-setup/41144/2 "2026-08-17T15:23:59Z")

</div>

Hello @degokul

> [@degokul](#):
>
> 1. How often would you recommend running it in a busy operational system like this?

You never said how busy your system is. A 2-node S/S could be doing 100 qps, or 10,000 qps.

> [@degokul](#):
>
> 1. Is `once per day` generally the right starting point, or do people commonly run it more frequently in production where I want to detect the drift asap?

Daily is plenty. I’ve never heard of anyone running it more frequently.

Remember that MySQL has it’s own built-in replication safety checks. When replication breaks due to “duplicate PK” or “missing record”, those are replication safety checks. What that means is, once you’ve run pt-table-checksum once, you really shouldn’t need to run it again because MySQL is watching new transactions. pt-table-checksum watches older data for drift.

> [@degokul](#):
>
> 1. Are there any specific cautions for using `pt-table-checksum` in an active-active topology beyond the usual replication safety checks?

Not really, other than ensuring which of the two sources is your true “golden source”. Meaning if a random row is different, which one is correct? You will have to choose. Ensure you always run the tool from that MySQL as “golden source.”

> [@degokul](#):
>
> I have not found clear guidance for how people typically handle this in a true active-active topology

There’s no difference with S/S. As above, you pick which is the correct, “golden source” of your data, and run the tool there. It checks the replica. That’s it. There’s no need to re-run the tool with the other server as source because you already checked it.

---

_[View the full topic](https://forums.percona.com/t/best-practice-for-pt-table-checksum-frequency-in-oracle-unified-assurance-active-active-mysql-setup/41144)._