We help IT Professionals succeed at work.
Get Started

Temporarily prevent Master Database from writing to replication log

SoLost
SoLost asked
on
927 Views
Last Modified: 2012-08-14
Hi there,
I have 4 database servers.  1 Master and 3 Slave servers.

I am wanting to temporarily migrate to a new Master server while I upgrade the current Master, and then migrate back again.

If you look at the attached image you can see the setup that we currently have on the left, and the setup that I'm wanting to migrate to on the right.

My question :

Is there a way to temporarily stop the Master from logging to the replication binarly log file so that I can stop all of the slaves from replicating and they will have all stopped at the same point in the Masters binary log file.  Then, start the Master logging to the replication binary log file again without having lost any data that was inserted or modified during the period that the Master was not logging.

I am wondering about running the MASTER STOP command on the Master but not having a test environment I can not test to see if this will work or not.

Alternatively, is there a way to get the Slaves to all stop at a particular point in the Masters binary log file?
ServerLayout.jpg
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE