Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have two MySQL servers running with master-master replication in a Pacemaker cluster. If a database operation should be done, the primary server is asked first to do the job, if it fails, the secondary will be asked. Of course, all changes will be replicated to the other server.

Now I have to upgrade both servers from SLES 11 SP2 to SLES 11 SP3. This will upgrade MySQL from V5.0 to 5.5, which should not be dramatic (I've tested it with 2 test machines). The running system should work without problems during the upgrade.

My scenario (primary/secondary are the roles within the pacemaker cluster):

stop replication on both servers (stop slave)

reject all connections to the secondary MySQL server with iptables

stop MySQL on the secondary server

make the upgrade on the secondary server

start MySQL on the secondary server

disable iptables' rejections on the secondary server

start replication on the secondary server (start slave)

Now I hope the secondary server will have the actual data

change the role of the servers: make the secondary server the primary server

reject all connections to the new secondary MySQL server with iptables

stop MySQL on the new secondary server

make the upgrade on the new secondary server

start MySQL on the new secondary server

disable iptables' rejections on the new secondary server

start replication on both servers (start slave)

What do you think about it? Will it work without data loss?

Thank's in advance!

Regards Burkhard

share|improve this question
    
I think it's overcompilcated. Stop MySQL, upgrade it, start it. Done. Then check all tables with CHECK TABLE table FOR UPGRADE. It will show which tables you need to rebuild. –  akuzminsky Feb 19 at 15:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.