Mysql – Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

clusteringgaleraMySQLreplicationxtradb-cluster

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?

Best Answer

it does not so far. I suggested it to Codership (the creator of Galera) to port it to Windows but somehow I did not have luck with my suggestion.

But we (fromdual.com) would be happy to help you setting it up and operating it on Linux?

Regards, Oli

Related Solutions

Percona XtraDB Cluster – Replication Stops Working, Cluster in ‘Synced’ State

We were able to resolve this using mysqldump instead of mydumper/myloader. Apparently there is a bug in myloader or in Galera itself which prevents replication to flow normally.

Percona xtradb cluster node2 won’t start

The log entries

2015-06-08 18:43:03 5977 [ERROR] WSREP: wsrep_load(): dlopen(): /usr/lib/galera3/libgalera_ssm.so: cannot open shared object file: No such file or directory
2015-06-08 18:43:03 5977 [ERROR] WSREP: wsrep_load(/usr/lib/galera3/libgalera_ssm.so) failed: Invalid argument (22). Reverting to no provider.

show that MySQL cannot find the file /usr/lib/galera3/libgalera_ssm.so so it cannot use it as a WSREP provider. Check that this file exists and is accessible. If your system is 64-bit, it might be in /usr/lib64/.

Also please post the error message you get when starting the node -- without reading the exact error message it's a shot in the dark.

Best Answer

Related Solutions

Percona XtraDB Cluster – Replication Stops Working, Cluster in ‘Synced’ State

Percona xtradb cluster node2 won’t start

Related Question