Date: Mon, 24 Jul 2017 13:25:54 +0200 From: Bernard Spil <brnrd@FreeBSD.org> To: =?UTF-8?Q?=D0=9A=D0=B0=D0=BB=D0=BE=D1=8F=D0=BD_=D0=9C=D0=B5=D1=85?= =?UTF-8?Q?=D0=B0=D0=BD=D0=B4=D0=B6=D0=B8=D0=B9=D1=81=D0=BA=D0=B8?= <k_georgiev@forumnews.bg> Cc: ports@freebsd.org Subject: Re: FreeBSD Port: databases/galera [with Mariadb 101] Message-ID: <c9ae34a640398e4323aec0c01e61208b@FreeBSD.org> In-Reply-To: <1693959347.790664.1488562517398.JavaMail.zimbra@forumnews.bg> References: <1693959347.790664.1488562517398.JavaMail.zimbra@forumnews.bg>
next in thread | previous in thread | raw e-mail | index | archive | help
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 > 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. 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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?c9ae34a640398e4323aec0c01e61208b>