MySQL


Upgrade steps:

  1. Primary Server
    1. Backup mysql database
    2. Backup remaining databases
  2. Secondary Server
    1. Transfer backups created in steps 1.A. and 1.B.
    2. Restore mysql
    3. execute “flush privileges”
    4. Upgrade MySQL
      execute “alter table proc modify column comment text”
    5. Restore remaining databases
    6. Make sure that upgraded MySQL behaves well
    7. Backup mysql
  3. Primary Server
    1. Transfer backup created in step 2.G.
    2. Upgrade MySQL
    3. Restore mysql from backup created in step 2.G.
    4. execute “flush privileges”
    5. Restore remaining databases
    6. Make sure that upgraded MySQL behaves well