Attended:

Agenda:

• Progress on Milestones
• Timeline
• Brief summary since the last meeting

Progress on Milestones:

• Backups set up and tested: (Due-date reset to next Wednesday): Remaining: testing

Timeline

• Fraser and Daniel are testing and re-moving inventory- likely not finished until mid-next-week (10th or so).
  • Schedule shows wrapup March 31 (!)

Brief summary since the last meeting

• Fraser worked cleaning up permissions and process for re-importing (prod changes)
• Fraser/Daniel worked on failover testing, which had a number of discoveries
  • default binlog_format=STATEMENT may have different failover response than MIXED ("best practice"). Switched in the live setup; will need failover testing.
  • slaves are not read-only; updates are NOT copied to master; so probably want to set read-only ("best practice")
  • master/master/slave has failure-modes. So probably want to go with master/slave/slave.

Done/can we do this in the next week?

• Anthony: switch the machine to 10Gb (requiring restarting containers) - probably ST#102302
• Backups: Anthony will deb-ify Fraser's mysql-102:/usr/local/lib/mysql scripts and install on mysql{,.student}.cs and mysql-10{2,4,6}

• Fraser: running mysqldumpexcept is quick. run twice separated by 10 sec; if the diff are identical, can use that timestamp.
  • how do we re-run import of permissions without clobbering mysql table?
    • percona command to output grants
      • but mysql.cs has lots of junk- grants for tables/users that don't exist; so fraser is writing a script to trim these.
  • slave grants: Anthony will update to use hostnames.
  • does nscd run? We don't think so; probably we want to run nscd. Anthony will set up nscd- we can benchmark before/after.
• Anthony will review /etc/mysql/conf.d/ and merge into salt what he can.
  • Salt and mysql: best practices for password storage? Anthony suggests making a more secure password to be stored on slave... Anthony will make an ST item to do that before we're done.
• Anthony will add marmoset to the slave "do NOT replicate" configs
• Fraser will update the written list of instructions for doing stage two- before next week. He will put it in ST for comment.

Next Meeting

• Wed 9 Mar? (day before retreat)

-- DanielAllen - 2016-03-02