RE: steps to pause MySQL master / slave

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Oct 2008 16:01:57 -0400

Ignore that man behind the curtain !!  

 

________________________________

From: Crisler, Jon 
Sent: Thursday, October 16, 2008 3:52 PM
To: Hanson, David; O'Reilly, Colleen; Stinebaugh, Laurie
Subject: steps to pause MySQL master / slave

 

Log into slave - vmdsxaql0i0d 

 

Su - mysql

Run mysql client

 

Show slave status \G;     (record results for possible troubleshooting)

 

Stop slave;

 

Log out;

Exit server;

 

 

Log into master - vmdsxaql0i0e

 

Su - mysql

Run mysql client

 

Show master status \G;   (record results for possible troubleshooting)

 

Stop master;

Log out;

Exit server;

 

 

 

Monitor disk space- if free disk space on any of the mysql filesystems
goes to 100%, it will cause replication to permanently break and require
a total resync.

Other related posts:

  • » RE: steps to pause MySQL master / slave