Skip to main content

Database Replication

MySQL/MariaDB master-slave replication keeps your database synchronized.

How It Works

  1. Master server logs all changes to binary log
  2. Slave connects and reads binary log
  3. Changes applied to slave database
  4. Typically under 10 seconds lag

Replication Status

Dashboard shows:

  • IO Thread: Receiving data from master
  • SQL Thread: Applying changes to slave
  • Lag: Seconds behind master
  • Last Update: When slave was last updated

Healthy Replication

  • IO Thread: Running
  • SQL Thread: Running
  • Lag: < 10 seconds
  • Status: "In sync" or low lag number

Common Issues

See Replication Troubleshooting