Meeting 24 March 2016, 2pm

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

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2016-03-31 - DanielAllen
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback