MySQL Upgrade

Project Summary:

This project is to upgrade Mysql databases (version 5.0) on paint to a new VM running Mysql 5.5.   Separating paint’s functions into separate virtual machines will allow us to separate cpu/network/memory/io resources and thereby be able to identify and isolate problems.  The VMware system has the possibility of having more I/O bandwidth and redundancy.

Mysql Scaling/Clustering:  A single master instance will be started at this time.   If there is a clear need for more servers AND we have buy in from other groups, I will make Mysql slave instances to offset the workload.

We start moving test databases in the week of January 23rd.  If a week of testing works ok, then we will move the production databases February 1 – 14th.

If a database/application doesn’t work after the migration, the original database and application will be  on paint until the problem can be resolved.  In order to complete the goal of getting off of the old hardware, paint will have to be made into a virtual machine.

 

Project Owner:

Jason Harris, Network Services

Groups Involved:

  • Network Services
  • Academic Computing
  • Admin Computing
  • Housing
  • Web Team
  • Others TBD

Estimated Completion Date:

February 21st, 2014

Resources:

Files, lists of databases, owners can be found in pccommon/mysql55upgrade