FAQ
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.

Search Discussions

  • Crisler, Jon at Oct 16, 2008 at 8:01 pm
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 16, '08 at 7:54p
activeOct 16, '08 at 8:01p
posts2
users1
websiteoracle.com

1 user in discussion

Crisler, Jon: 2 posts

People

Translate

site design / logo © 2022 Grokbase