Date: Mon, 24 Jul 2017 15:25:55 +0300 (EEST) From: =?utf-8?B?0JrQsNC70L7Rj9C9INCc0LXRhdCw0L3QtNC20LjQudGB0LrQuA==?= <k_georgiev@trud.bg> To: ports@FreeBSD.org, brnrd@FreeBSD.org Subject: Re: FreeBSD Port: databases/galera [with Mariadb 101] Message-ID: <1888600836.535870.1500899155538.JavaMail.zimbra@forumnews.bg> 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
Hello, This would be very nice. I was almost ready to switch to linux with the hop= e to make this one working.=20 I still keep my FreeBSD Galera test systems so if you need anything to test= or for configuration issues please let me know asap.=20 Thanks, iddqd idkfa!=20 ----- Original Message ----- From: "=D0=9A=D0=B0=D0=BB=D0=BE=D1=8F=D0=BD =D0=9C=D0=B5=D1=85=D0=B0=D0=BD= =D0=B4=D0=B6=D0=B8=D0=B9=D1=81=D0=BA=D0=B8" <k_georgiev@forumnews.bg> To: ports@FreeBSD.org, brnrd@FreeBSD.org Sent: Friday, March 3, 2017 7:35:17 PM Subject: FreeBSD Port: databases/galera [with Mariadb 101] Hello=20 I tried about 1 year ago Galera cluster with MySQL and it didn't work out s= o back then I tried as I tried today MariaDB 101 with Galera cluster.=20 I see that both Galera and MariaDB ports are being modified but the combine= d configuration don't work at all. I also see that Galera cluster is offici= ally supported on FreeBSD. I have managed to bring up the cluster and make both nodes join but then re= plication don't work at all and even mysqld process hung when trying to sto= p one of the nodes.=20 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.=20 Adding this line 'export LD_LIBRARY_PATH=3D/usr/local/lib/gcc49' to /usr/l= ocal/bin/mysqld_safe made the cluster running and nodes able to join, but d= ata transfer between nodes don't seem to work.=20 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 ge= t it working.=20 My my.cnf file: [mysqld] sql_mode=3DNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES=20 binlog_format =3D 'ROW' [galera] wsrep_provider=3D"/usr/local/lib/libgalera_smm.so" wsrep_cluster_name=3DMyCluster wsrep_cluster_address=3D"gcomm://192.168.10.77,192.168.10.78" wsrep_node_name=3DMyNode2 wsrep_node_address=3D"192.168.10.78" wsrep_sst_method=3Drsync wsrep_sst_auth=3Dsst_user:sudomadafaka wsrep_on=3DON log_basename=3D'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 s= uccessful cluster configuration with Galera? After all this port is not mar= ked as broken?=20 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?1888600836.535870.1500899155538.JavaMail.zimbra>