MySQL Forums
Forum List  »  Replication

Re: Correct way to put a MySQL replicated environment safely into maintenance mode?
Posted by: Alex Walker
Date: June 16, 2022 06:49AM

Thanks for the reply. Given that the master/all nodes were going to be to be offline concurrently for maintenance, I wasn't expecting there to be a huge backlog to catch up on, on the replication front, so that wasn't really a notable consideration.

For anybody else's future reference, what I did in the end was take all 3 nodes offline, restart them with skip-networking enabled, then disabled binary logging on the master (set session sql_log_bin = off;) and ran the optimise table statements on all 3 nodes concurrently, before bringing them back online again normally.

This way I was able to minimise time taken, and without breaking replication.

Maintenance is now completed successfully.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Correct way to put a MySQL replicated environment safely into maintenance mode?
30
June 16, 2022 06:49AM


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.