FreeBSD Port: databases/galera [with Mariadb 101]

[Калоян Механджийски]

Hello,

Do you have any update on this issue? 
Have you managed to make the replication working? 

Thanks, iddqd, idkfa!

----- Original Message -----
From: "Калоян Механджийски" <k_georgiev at trud.bg>
To: ports at FreeBSD.org, brnrd at FreeBSD.org
Sent: Monday, July 24, 2017 3:25:55 PM
Subject: Re: FreeBSD Port: databases/galera [with Mariadb 101]

Hello,

This would be very nice. I was almost ready to switch to linux with the hope to make this one working. 

I still keep my FreeBSD Galera test systems so if you need anything to test or for configuration issues please let me know asap. 


Thanks, iddqd idkfa! 

----- Original Message -----
From: "Калоян Механджийски" <k_georgiev at forumnews.bg>
To: ports at FreeBSD.org, brnrd at FreeBSD.org
Sent: Friday, March 3, 2017 7:35:17 PM
Subject: FreeBSD Port: databases/galera [with Mariadb 101]

Hello 

I tried about 1 year ago Galera cluster with MySQL and it didn't work out so back then I tried as I tried today MariaDB 101 with Galera cluster. 
I see that both Galera and MariaDB ports are being modified but the combined configuration don't work at all. I also see that Galera cluster is officially supported on FreeBSD.

I have managed to bring up the cluster and make both nodes join but then replication don't work at all and even mysqld process hung when trying to stop one of the nodes. 

I have been reading this post https://forums.freebsd.org/threads/53969/ and I ended up at the same place where the author BlindPenguin ended. 
Adding this line 'export LD_LIBRARY_PATH=/usr/local/lib/gcc49' to  /usr/local/bin/mysqld_safe made the cluster running and nodes able to join, but data transfer between nodes don't seem to work. 

I've been trying with various of configuration sets, first tried the ones (the most basic ones) from the galera official documentation, then I changed some stuff just for troubleshooting but no matter what I change I can't get it working. 

My my.cnf file:

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
binlog_format = 'ROW'

[galera]
wsrep_provider="/usr/local/lib/libgalera_smm.so"
wsrep_cluster_name=MyCluster
wsrep_cluster_address="gcomm://192.168.10.77,192.168.10.78"
wsrep_node_name=MyNode2
wsrep_node_address="192.168.10.78"
wsrep_sst_method=rsync
wsrep_sst_auth=sst_user:sudomadafaka
wsrep_on=ON
log_basename='galeratest2'


FreeBSD Version:
FreeBSD galeratest.mydomain.lan 11.0-RELEASE-p1 FreeBSD 11.0-RELEASE-p1 #0 r306420: Thu Sep 29 01:43:23 UTC 2016     root at releng2.nyi.freebsd.org:/usr/obj/usr/src/sys/GENERIC  amd64

My request: Please let me know if anybody from the port maintainers did a successful cluster configuration with Galera? After all this port is not marked as broken? 
And if I can get any help from the port maintainers , or I should probably contact the Galera as port provider?

Thank you in advance.