Ralph

Safely Restart a MySQL Slave Server

Introduction

user

Ralph

Ralph is a car enthusiast, blogger, author and teacher. In addition to being the founder of this website, Ralph is also a Linux Systems Administrator with 9 years+ experience who is also available for freelance or full-time work.


LATEST POSTS

The whole system that we live in drills into us… 23rd September, 2018

Canvas LMS: Install QTI Migration Tool 08th August, 2017

General

Safely Restart a MySQL Slave Server

Posted on .

Ensure it’s not accessible by any clients, if you use a load balancer, you should take it off temporarily.

Connect to the MySQL Server via the command line:

mysql -u root

Stop the replication:

stop slave;
flush tables;

Now is a good time to make any changes you want to.

Resume replication:

start slave;

Check the status to confirm replication is running normally, and in most cases, catching up with the master:

show slave status\G;

If that went well, now’s a good time to put it back on the load balancer.

profile

Ralph

Ralph is a car enthusiast, blogger, author and teacher. In addition to being the founder of this website, Ralph is also a Linux Systems Administrator with 9 years+ experience who is also available for freelance or full-time work.

Navigation