Want to run the master nondisruptively when replicating with MySQL

Asked 2 years ago, Updated 2 years ago, 41 views

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

2022-09-30 19:12

1 Answers

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.


2022-09-30 19:12

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.