Attended: drallen a2brenna fhgunn ldpaniak

Agenda:

• Timeline
• Remaining work
• Issues to discuss

Timeline

• Fraser and I would like to do the rest of the moves on Tuesday the 29th (or Wed the 30th at the latest).
• Current schedule then shows wrapup on Wed April 13.

Remaining work

• Fraser: time-constrained...
  • 103618 - configuring and tuning HA mysql.cs parameters
  • 103624 - migrate rest of data / stage 2 (with Daniel)
  • 103620 - assist with HA mysql.cs maintenance documentation (if time available next week)
• Daniel:
  • 103624 - migrate rest of data / stage 2 (with Fraser)
  • 103625 - migrate data to HA mysql.cs: ensure production apps are working
  • 103620 - assist with HA mysql.cs maintenance documentation (if time available next week)
  • 103621 - HA mysql.student.cs (phase two) documented plans / wrapup
• Lori:
  • 103822 - test failover of master/slave/slave asynch HA mysql.cs
  • 103617 - benchmark HA mysql.cs
  • 103620 - assist with HA mysql.cs maintenance documentation (if time available next week)
  • 103621 - HA mysql.student.cs (phase two) documented plans / wrapup
• Anthony:
  • 103619 - set up monitoring of HA mysql.cs
  • 103620 - assist with HA mysql.cs maintenance documentation (if time available next week)
  • 103621 - HA mysql.student.cs (phase two) documented plans / wrapup

Issues to discuss

• pt-table-checksum hanging: we need to make pt-table-checksum fail if it's hanging - or, is there an alternative checker that's cheaper? - we need a smarter checker that confirms all the slaves are up - Anthony will write it that way.
• firewalling
  • Anthony to open firewall for mysql port for checks by nagios, smokeping, cacti. Open mysql port to asgard?
  • Anthony will add comments relevant to debugging
  • need to document firewall updating in HATesting - Anthony to update.
  • noting: Salt doesn't know which host is the master.
• documentation questions
  • final documentation: isn't HATesting, but we can still leave Draft at the top.
• monitoring: Anthony's priority
  • will record a list of all the things we can and should monitor, and put it in twiki.

Future work: document that we will prune grants yearly? Automatically (trimming missing tables)?

-- DanielAllen - 2016-03-24