RE: steps to pause MySQL master / slave
Date: Thu, 16 Oct 2008 16:01:57 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675033A9857@mds3aex08.USIEXCHANGE.COM>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 16 2008 - 15:01:57 CDT