MariaDB Migration Services

Audits IO and SQL replication thread health, Seconds_Behind_Master, and current GTID positions across domains to confirm zero cutover lag.

-- 1. Verify MariaDB slave threads and GTID synchronization state
SHOW SLAVE STATUS\G

-- Inspect critical replication markers
SELECT 
    VARIABLE_VALUE AS Current_GTID_Position 
FROM information_schema.GLOBAL_STATUS 
WHERE VARIABLE_NAME = 'Gtid_Current_Pos';

-- Validate domain-level slave position
SELECT @@global.gtid_slave_pos, @@global.gtid_strict_mode;

Executes non-blocking live table checksums and live row count consistency verification between source and target instances prior to cutover.

-- 2. Audit mathematical checksum across migrated tables
CHECKSUM TABLE database.table;

-- Audit table cardinality and storage engine state
SELECT 
    TABLE_NAME, 
    ENGINE, 
    TABLE_ROWS, 
    DATA_LENGTH, 
    INDEX_LENGTH, 
    CHECK_TIME 
FROM information_schema.TABLES 
WHERE TABLE_SCHEMA = 'production_db' 
ORDER BY TABLE_NAME;