Replication & failover

PostgreSQL · MySQL · 3 scenarios

Prototype — data is mocked and actions are not connected yet.

← Goals

PostgreSQLMySQL L2–L4

Move and recover data safely: replication lag, broken binlog, and a failover onto a stale replica — on both Postgres and MySQL.

1 / 3 scenarios passedScore avg 83%
Due Sep 1, 2026 · 12 weeks left

Scenarios to pass

PostgreSQL WAL & replication · L2 Replication lag from a write burst 83% Passed
MySQL Replication & binlog · L2 Replication broken after failover Not started
PostgreSQL HA & failover · L4 Failover onto a stale cascading replica Not started

How this goal was set

  • SystemsPostgreSQL · MySQL
  • LevelSenior
  • Focus areaReplication & HA
  • IntensityGameDay

The scenario set is assembled from your answers. Re-answer to regenerate it.

Prototype — scenario scores are mocked.