Tagged: mysql Toggle Comment Threads | Keyboard Shortcuts

  • Elmer Masters 2:46 pm on June 25, 2014 Permalink
    Tags: , , mysql   

    Moving databases is a relatively slow process. It just takes as long as it takes.

     
  • Elmer Masters 1:00 pm on May 16, 2013 Permalink
    Tags: , mysql   

    Discovered that the MySQL slave is missing data on a few Classcaster blogs. When I populated the new db with the data from the slave, some blogs “disappeared”. Going back now and pulling data from master db to restore 3 blogs.

     
  • Elmer Masters 7:57 pm on January 9, 2013 Permalink
    Tags: , mysql   

    Learned about GROUP_CONCAT() in mysql. Seems like it could be useful for pulling together multiple values of the same fields, rows in a single table. See Drupal’s profiel_values for an example. The SEPARATOR option is useful.

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

    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: mysql   

    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: mysql   

    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