FW: steps to pause MySQL master / slave

Correction to server names - ignore earlier note.  

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-l