SQL Lab — Replication and High Availability (Hard)

🖥️

SQL Terminal

📚

Reference

📌 OBJECTIVES — NO HINTS

○Configure primary: enable binlog, set server-id

○Create replication user with REPLICATION SLAVE

○Take consistent backup with FLUSH TABLES WITH READ LOCK

○Point replica: CHANGE MASTER TO ...

○START REPLICA and verify with SHOW REPLICA STATUS

○Simulate and recover from replication break

○Implement read routing: SELECT on replica

0 / 7 complete

SQL TERMINAL — REPLICATION AND HIGH AVAILABILITY (HARD)

MySQL 8.0 — Lab environment loaded Replication and High Availability (Hard) — Hard tier · No syntax hints provided ⚠ This lab tests independent problem-solving. Reference window available. ──────────────────────────────

mysql>

COMMAND REFERENCE

AVAILABLE COMMANDS

SHOW MASTER STATUS;
CREATE USER 'repl'@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS;
CHANGE MASTER TO MASTER_HOST='primary', MASTER_USER='repl', MASTER_LOG_FILE='binlog.000001', MASTER_LOG_POS=157;
START REPLICA; SHOW REPLICA STATUS\G
SET GLOBAL SQL_REPLICA_SKIP_COUNTER=1; START REPLICA;
SELECT Seconds_Behind_Source FROM performance_schema.replication_applier_status;

Type keywords from the command list. The terminal will recognise your intent even if the exact syntax differs.

MISSION BRIEFING

REPLICATION — OMNIBANK SYSTEMS · HARD ⭐⭐⭐

SCENARIO

OmniBank needs a read replica to offload reporting queries from the primary. You must configure binlog-based replication, set up a replica server, verify replication lag, handle a replication break caused by a schema change, and implement a read/write routing strategy.

OBJECTIVES

Configure primary: enable binlog, set server-id
Create replication user with REPLICATION SLAVE
Take consistent backup with FLUSH TABLES WITH READ LOCK
Point replica: CHANGE MASTER TO ...
START REPLICA and verify with SHOW REPLICA STATUS
Simulate and recover from replication break
Implement read routing: SELECT on replica

HARD MODE RULES

No step-by-step guidance. Use the Reference window for command syntax only. You must determine the approach, the correct columns and order, and verify your own results.

Display Mode