On 2017-03-03 18:35, Калоян Механджийски wrote:
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
[email protected]:/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.
This is very strange... That would only work if you replace clang with
gcc 4.9 in your system and rebuild everything with that.
LD_LIBRARY_PATH=/usr/local/lib/gcc49
I'm not running clusters myself so it's really hard to test. If you can
help out, I am interested in actually making this work!
Let me see where I can get with MariaDB 10.2 on FreeBSD 11.1. I will
probably send you some patch to test.
Bernard.
_______________________________________________
[email protected] mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "[email protected]"
