Réplication Master/Slave

Replication monitoring

PmaControl monitors the replication status of MariaDB / MySQL in real time:

• Seconds_Behind_Master — Replication lag with history
• IO Thread — Master connection status (Running, Connecting, Stopped)
• SQL Thread — Relay log application status
• GTID — GTID position for MariaDB (gtid_slave_pos) and MySQL (Executed_Gtid_Set)
• Errors — Last_IO_Error, Last_SQL_Error with diagnostics

Assisted configuration

The MasterSlave module (MasterSlave.php) assists with configuration:

• configMasterSlave — Master/slave association by level
• generatePair — Automatic generation of replication pairs
• compareVersions — Version compatibility check

Visualization in Dot3

Replication links are displayed in Dot3 with a color code:

• ■ REPLICATION_OK — Functional replication, no lag
• ■ REPLICATION_DELAY — Lag detected
• ■ REPLICATION_STOPPED — Replication stopped
• ■ REPLICATION_ERROR_SQL/IO — SQL or IO error
• ■ REPLICATION_BUG — Inconsistent state