// you’re reading...

Linux, Unix, and Solaris

Scripting MySQL replicated slave restarts

The recent reboot requirements at Amazon AWS have brought up the topic of automated restarts of MySQL database servers. I’d like to offer a safe solution for scripting the procedure. Let’s pretend that we’ve already confirmed there’s no production traffic. Here are the basic commands:

Stopping MySQL Server

Stop replication

mysqladmin -u root -p stop-slave

Make sure all in-memory stuff is saved to disk.

mysqladmin -u root -p stop-slave

Bring down the mysqld server

mysqladmin -u root -p stop-slave

Starting MySQL Server

If mysqld isn’t started automatically when your host is booted, your distribution may have it’s own start script. However, you could always do the generic start:

mysqladmin -u root -p stop-slave

Next, restart replication

mysqladmin -u root -p stop-slave


No comments for “Scripting MySQL replicated slave restarts”

Post a comment

Help support my site and buy a domain name at http://domainsemailhosting.com/

%d bloggers like this: