Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Set 1-hour delay on replica CHANGE REPLICATION SOURCE TO SOURCE_DELAY = 3600; START REPLICA; -- After accidental DROP TABLE on primary: -- 1. Stop replica SQL thread STOP REPLICA SQL_THREAD; -- 2. Fast-forward to just before the DROP START REPLICA UNTIL SQL_BEFORE_GTIDS = "primary_uuid:error_gtid"; -- 3. Promote replica or restore from it -- Check delay setting: SHOW REPLICA STATUS\G -- SQL_Delay field
Result
Open