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?

  • 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 '16 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 '16 at 10:41
  • 1
    Yes with respect to mysql, it should cause no issues for same versions. – mysql_user Oct 12 '16 at 12:58
  • "Single node Cluster" 'isa' high tech oxymoron. – Rick James Oct 17 '16 at 19:17
  • Yes it is and in corporations oxymorons happen all the time as you might already know. – Iokanaan Iokan Oct 19 '16 at 12:34
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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