How to migrate Xtradb cluster data to MariaDB 10.4 version

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hello Team,

We have 3 node cluster which is running as a mysql XTRADB cluster [ Stage and Prod ] .We are planning to migrate the data from mysql xtradb cluster data to mariaDB 10.4 version. Can any one pls share the steps / Blog on this .So that i can try.

Thanks in advance.

Source DB version :- Server version: 5.6.34-log MySQL Community Server (GPL), wsrep_25.18
Target DB version :- MariaDB 10.4

2 Likes
2

Hi @vasu1,
Just so I understand, you’re posting on percona’s forums, asking for info on how to migrate away from percona onto something else? Is there some reason why PXC8 is not working for you? Since MariaDB is not MySQL, you’ll have to perform a logical dump and import into your new Maria cluster. Since you are already using XtraDB Cluster 5.6, why not simply upgrade to XtraDB 5.7 and then to 8.0?

2 Likes
3

Hi Matthew ,

Thanks for replying .
Actually we have old PXC clusters which is running from longs years . .Owner of those applications wants to move MariaDB for all applications …For this we are moving to MariaDB

2 Likes
4

Do you steps …or blog / document .Pls share

2 Likes
5

Hi @vasu1
Migrations off PXC to MariaDB are simply not commonly performed by Percona. While we proudly support both PXC and MariaDB Galera Cluster, we find many customers ask us to support them on MGC, or assist with a migration to PXC. So unfortunately we simply don’t have blogs or documents related to your scenario.
You may find better success from the MariaDB Community

Or on MariaDB’s sub-Reddit

1 Like
7

That’s awesome! Seems like the owner needs to understand the stability that comes with staying on Percona software. And as Michael said, most of our migrations are coming from Maria, not the other way.

1 Like