Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Set up a delayed replica (stays 1 hour behind primary) -- Run on the replica: STOP SLAVE; CHANGE MASTER TO MASTER_DELAY = 3600; START SLAVE; -- Take a backup from the replica (pause replication first) STOP SLAVE SQL_THREAD; -- Run mysqldump here (from shell) -- mysqldump --single-transaction myapp_db > backup.sql START SLAVE SQL_THREAD; -- Check replication status SHOW SLAVE STATUS\G
Result
Open