Re: upgrading mysql 5.0 to 5.5 on master-master setup
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.
Subject
Views
Written By
Posted
3471
July 27, 2012 08:55AM
Re: upgrading mysql 5.0 to 5.5 on master-master setup
1691
July 27, 2012 09:42AM
1408
July 27, 2012 10:27AM
2155
August 01, 2012 01:16PM
1432
August 02, 2012 04:02AM
1431
August 07, 2012 03:04PM
1242
August 08, 2012 06:03AM
1242
August 10, 2012 03:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.