0

I have a single node percona XtraDB Cluster.

Version: Server version: 5.6.15-56 Percona XtraDB Cluster (GPL), Release 25.5, Revision 759, wsrep_25.5.r4061

All tables in the DB are using InnoDB engine and the database is partitioned.

The server is a RHEL 6 server and I want to upgrade it to RHEL 7. What I am planning to do is, stop mysql on the old server, shut it down, disconnect the disk (old and new servers are VMs), connect it to the new RHEL 7 server, turn the new server on, mount the disk, change mysql configuration so that it will point to the new filesystem. Sounds good on paper but will this actually work?

Improve this question
3
  • 1
    Single node cluster!!!!! No other options then... you could have made the new node join the cluster n retire the old but disk!?! Btw why do u have single node cluster; instead just use percona server!!
    – mysql_user
    Oct 11, 2016 at 4:57
  • There is a future plan to turn it into a cluster, that's why. The disk is huge and replication would take ages - can't afford that. That's why I am asking if reconnecting the disk to a different server will work.
    – Iokanaan Iokan
    Oct 12, 2016 at 10:41
  • 1
    Yes with respect to mysql, it should cause no issues for same versions.
    – mysql_user
    Oct 12, 2016 at 12:58

1 Answer 1

Reset to default
0

Well, I've tested this and the answer is yes. One small thing to keep in mind is that in RHEL 6 default filesystem is EXT4 while in RHEL 7 it is XFS and you will be mounting an EXT4 filesystem to a RHEL7 machine.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.