Date: Fri, 3 Mar 2017 19:35:17 +0200 (EET) From: =?utf-8?B?0JrQsNC70L7Rj9C9INCc0LXRhdCw0L3QtNC20LjQudGB0LrQuA==?= <k_georgiev@forumnews.bg> To: ports@FreeBSD.org, brnrd@FreeBSD.org Subject: FreeBSD Port: databases/galera [with Mariadb 101] Message-ID: <1693959347.790664.1488562517398.JavaMail.zimbra@forumnews.bg> In-Reply-To: <2056479608.790136.1488561708846.JavaMail.zimbra@forumnews.bg>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1693959347.790664.1488562517398.JavaMail.zimbra>