Updates from September, 2012 Toggle Comment Threads | Keyboard Shortcuts

  • Elmer Masters 6:22 pm on September 18, 2012 Permalink
    Tags: CLI,   

    Some helpful MySQL commands:

    mysql> STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;

    mysql> CHANGE MASTER TO MASTER_HOST=’mysql.server.name’, MASTER_USER=’a-user’, MASTER_PASSWORD=’password’, MASTER_LOG_FILE=’mysql-bin.000000′, MASTER_LOG_POS=’742507236′;

     
  • Elmer Masters 6:04 pm on September 18, 2012 Permalink
    Tags:   

    Issues with MySQL slave may require a complete rebuild to get replication back in sync. That will eat up a lot of a weekend at this point. Should be able to do it with little production downtime though.

     
  • Elmer Masters 3:28 pm on September 18, 2012 Permalink
    Tags:   

    Doing cleanup on the MySQL Slave after the mess of last month. I learned that “slave-skip-errors = 1062” is your friend when resetting a slave that has gotten out of sync with its master.

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel