Enterprise Mysql Cluster Project

Table of Contents

Project Objective: Purpose

The purpose is to set up a Highly Available clustered mysql database to support general computing. This is a term goal for Winter 2016, with a firm deadline of April 13th (meeting between Ken and CSCF Managers).

Project Scope/Deliverables

The high-level outcomes and results of this project are as follows:
  • we're agreed on a project plan and timeline DONE
  • new 3-node cluster with proper master/slave replication DONE
  • mysql.cs databases (list here) are moved to new cluster DONE
  • Marmoset is left behind on current mysql.cs DONE
  • appropriate resource, latency, and health monitoring of the database services DONE
  • wrapup includes:

Scope Includes/Excludes


  • high-speed dedicated storage network
  • asynchronous replication (master/slave, same process as set up by Clayton for yubikey)
  • failover process with acceptable downtime
  • tested failover and recovery, with (test instances of?) real applications and with no data loss (requires application experts - eg., Daniel for inventory)
  • necessary documentation
  • cluster deployment
    • PXE booting cluster
    • create salt pillar to build and deploy 3 mysql nodes on hardware cluster (Anthony and Clayton)
    • saltifying: mysql cluster backup (Anthony with Fraser)
    • benchmarking and testing mysql cluster performance (Fraser, Lori, Steve Weber)
  • migrate data from mysql.cs to cluster (Fraser)


  • synchronous data replication (unless Clayton's instructions say it's trivial)
  • investigating additional mysql cluster setups
  • creating automated containers


  • many current databases (list here) are critical; downtime must be pre-planned and minimized (no unscheduled downtime)
  • no user-level changes: two weeks before exams until last CS exam
  • end of term is April (23 - end of classes; 29 - last business day before new term)

Assumptions and Risks

  • marmoset can stay where it is on the non-clustered database, for this phase.

Project Members

drallen (project manager), dlgawley a2brenna fhgunn gxshen arpepper ldpaniak

Project Stakeholders

lfolland omnafees (, ISG ...)

Project Sponsor

Ken Salem


Implementation Plan

Meeting notes

-- DanielAllen - 2016-01-19

Edit | Attach | Watch | Print version | History: r19 < r18 < r17 < r16 < r15 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r19 - 2016-04-11 - DanielAllen
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback