Incident simulations
Exit

INC-3309 · P2

The claims dashboards have been frozen since Sunday evening

Rabat · Technopolis datacenter · db-aw-02 (replica) · Monday 09:05

Assurances Al Wifaq (a fictional company) manages its claims declarations in MySQL 8.0: db-aw-01 is the source (application writes), db-aw-02 is a GTID replica that serves the dashboards and the exports for the branches.

This morning, the branch managers report that the dashboards “have not moved since Sunday 22:40”. The main application works normally. On Sunday evening, Youssef ran a “read-only” data fix script to correct an import.

Your mission (logged in on db-aw-02): restart replication without breaking data consistency, understand how the replica could diverge, and prevent it from happening again.

This simulation is reserved for students enrolled in a course.

Already enrolled? Log in.