MySQL Forums
Forum List  »  Replication

Re: Correct way to put a MySQL replicated environment safely into maintenance mode?
Posted by: Peter Brawley
Date: June 14, 2022 02:19PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Correct way to put a MySQL replicated environment safely into maintenance mode?
72
June 14, 2022 02:19PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.