Re: Correct way to put a MySQL replicated environment safely into maintenance mode?

[Peter Brawley]

I've not seen stopping a replica/slave and counting on it to catch up later recommended in MySQL documentation. Have you?

The standard advice for maximally reliable re-syncing replication source and replica(s) is a sequence like that described under "Reset replica/slave 5-step" at https://www.artfulsoftware.com/infotree/mysqltips.php.

The fly in that ointment is the slowness of mysqldump with large data loads. Current versions of MySQL come with a much faster dump method that can be executed in the new MySQL Shell utility. AFAIK that won't work with 5.6.

See https://www.percona.com/blog/dump-performance-comparison-mysqldump-vs-mysql-shell-utilities-vs-mydumper/ for current benchmarks---mydumper, mysqlpump and xtrabackup are roughly comparable in performance, and all are an order of magnitude faster than mysqldump.