ARCHIVED: Completed project: Webserve MySQL migration

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

Primary UITS contact: Martin Breth

Completed: June 1, 2017

Description: The current Webserve MySQL servers (mysql.iu.edu and mysql-test.iu.edu) are running on Red Hat Enterprise Linux 5 (RHEL 5), which will be deprecated in early 2017. Therefore, we need to migrate MySQL Service to RHEL 6 servers.

Migration will occur in two phases. Phase one of the migration will be to copy data from the current instances of MySQL to new Red Hat Enterprise Linux 6 (RHEL 6) servers and upgrade customer MySQL instances to version 5.5.

Phase two will include updating MySQL to 5.7, which introduces many new database features. We are adding an option to manage user data via MySQL Workbench streamed from IUanyWare (phpMyAdmin option will remain available and supported).

Phase two will also change the MySQL architecture to a MySQL database as a service approach. This includes moving from 1000+ individual MySQL instances running on each of the current servers to one single MySQL instance with many databases on each server. Each MySQL customer will have a semi-privileged MySQL user who will be able to administer only their MySQL databases.

Outcome: Moving MySQL Server to RHEL 6. MySQL Server upgrade to 5.7 and providing MySQL databases as a service.

Benefits:

  • Updated software
  • Enhanced security
  • Better organized

Primary client: Webserve users who use MySQL service

Client impact: MySQL service users will be required to test their applications as well as pick a migration date and change their connection variables.

Milestones and status: Phase one was completed as scheduled. Phase two was removed from the project scope and scheduled for summer 2017.

  • Phase one - Upgrade to RHEL 6.7 and MySQL 5.5
    • April-May 2016: MySQL migration preparations
    • May 31 and June 1, 2016: MySQL test upgrades
    • June 22-July 6, 2016: User testing
    • July 6, 2016, 9am-5pm: Mysql-test.iu.edu migration to RHEL 6 and upgrade to MySQL 5.5
    • July 17, 2016, 12:01-8am: Mysql.iu.edu migration to RHEL 6 and upgrade to MySQL 5.5
  • Phase two - Upgrade to MySQL 5.7 and single instance model
    • July 2016: MySQL upgrade preparations
    • August-October 2016: Migration to 5.7 servers

Project teams:

  • DBA
  • WebTech
  • Web Services Support

This is document agri in the Knowledge Base.
Last modified on 2021-09-08 10:19:47.