https://dev.mysql.com/doc/refman/5.6/ja/replication-howto-masterstatus.html
We are proceeding with the replication by referring to the above URL, but it was written that you should type the following command.If you type this command, you will not be able to load the current running master server.
FLUSH TABLES WITH READ LOCK;
I would like to replicate the master server without interruption. Could you tell me a good way?
mysql
I don't know if it's non-disruptive, but as soon as you check the coordinates, run UNLOCK TABLES;
to release the lock to restore it.
© 2024 OneMinuteCode. All rights reserved.