Re: upgrading mysql 5.0 to 5.5 on master-master setup

[Aftab Khan]

Rule number1. Take good backups before upgrade.

Test your upgrade plan in test environment with the same setup i.e. two masters ideally using snapshot of production databases (if possible).

If you have additional servers in PROD. You could minimize downtime. For instance add two nodes into existing setup i.e.

-- original setup
NODE1 <-> NODE2 # bi-direction replication, multi-masters

-- extend original step

NODE1 -> NODE3 -> NODE4 # node3/node4 running with 5.1

node3 <-> node4 # setup bi-direction replication between NODE3 AND NODE4

So that you can failover to node3 and node4



Edited 1 time(s). Last edit at 07/27/2012 09:43AM by Aftab Khan.