mysql - Lock two databases at the same time -


We are taking data database from MySQL to MongoDB for some data. Although we have seen some inconsistent data between two servers of some time after a sync, and we are investigating the problem. One thing we want to do is draw data from MongoDB and MySQL, and compare them. Although the data is updated frequently, we want to lock the database before collecting data and compare it for a short time. Is there any possible way to lock both together?

I do not know of any explicit locking in Mongodybi, but at a certain time a secondary and What about adding stop updates? You can then get a constant point to compare to comparison without influencing the live system.

For MySQL, it is possible to read only with a sol.

Comments

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

python - Receiving "KeyError" after decoding json result from url -

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -