Skip to content

ACE diff Commands

ACE diff commands can identify differences between tables and objects in a replication set (repset), schema, or for standalone tables on different nodes of your replication cluster.

ACE diff functions compare two objects and identify the differences; the output is a report that contains a:

  • summary of compared rows.
  • mismatched data details.
  • node-specific statistics.

If you generate an HTML report, ACE generates an interactive report with:

  • color‑coded difference highlighting.
  • expandable row details.
  • primary key highlighting.
  • missing row indicators.

Common Use Cases:

  • Performing routine content verification.
  • Performance‑optimized large table scans.
  • Focused comparisons between nodes, tables, or schemas.

Hint

Running diff commands can be resource-intensive. Experiment with --block-size, --concurrency-factor, and --compare-unit-size to balance runtime and resource usage. Use --table-filter for large tables to reduce comparison scope, and generate HTML reports to simplify analysis.

Info

If you'd like to automate recurring checks, add --schedule --every=<duration> to an ad-hoc run or define jobs in ace.yaml and launch the scheduler. See Scheduling ACE Runs for details.