MySQL database migration services

Audits replica thread execution state, verifies Seconds_Behind_Source is zero, and confirms GTID executed set parity between migration endpoints.

-- 1. Inspect MySQL replica health, thread state, and replication lag
SHOW REPLICA STATUS\G

-- 2. Validate GTID executed set parity between source and target
SELECT @@GLOBAL.gtid_executed AS replica_gtids;

Extracts table row counts and data volumes across schemas, and inspects pt-table-checksum divergence tables for zero-difference verification.

-- 1. Audit table row count parity across migrated schemas
SELECT 
  table_schema, 
  table_name, 
  table_rows, 
  ROUND(data_length / 1024 / 1024, 2) AS data_mb 
FROM information_schema.tables 
WHERE table_schema NOT IN ('mysql', 'information_schema', 'performance_schema', 'sys') 
ORDER BY data_length DESC 
LIMIT 10;

-- 2. Inspect pt-table-checksum result summary for table divergences
SELECT db, tbl, chunk, this_crc, master_crc 
FROM percona.checksums 
WHERE this_crc <> master_crc;