From owner-freebsd-ports@freebsd.org Mon Jul 24 12:31:26 2017 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 57224C7D1E7 for ; Mon, 24 Jul 2017 12:31:26 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 3F54466B2B for ; Mon, 24 Jul 2017 12:31:26 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: by mailman.ysv.freebsd.org (Postfix) id 3E857C7D1E6; Mon, 24 Jul 2017 12:31:26 +0000 (UTC) Delivered-To: ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 3E2F7C7D1E5 for ; Mon, 24 Jul 2017 12:31:26 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: from mx.deltanews.bg (mx.forumnews.bg [94.156.233.44]) by mx1.freebsd.org (Postfix) with ESMTP id B71AC66B28; Mon, 24 Jul 2017 12:31:23 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: from localhost (localhost [127.0.0.1]) by mx.deltanews.bg (Postfix) with ESMTP id B85B67E47D; Mon, 24 Jul 2017 15:26:02 +0300 (EEST) Received: from mx.deltanews.bg ([127.0.0.1]) by localhost (mx.deltanews.bg [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id HASgz_s-PUtC; Mon, 24 Jul 2017 15:26:01 +0300 (EEST) Received: from mx.deltanews.bg (localhost [127.0.0.1]) by mx.deltanews.bg (Postfix) with ESMTP id 887897E44F; Mon, 24 Jul 2017 15:26:00 +0300 (EEST) Received: from mx.deltanews.bg (mx [94.156.233.44]) by mx.deltanews.bg (Postfix) with ESMTP id 7B0AA7E44E; Mon, 24 Jul 2017 15:26:00 +0300 (EEST) Date: Mon, 24 Jul 2017 15:25:55 +0300 (EEST) From: =?utf-8?B?0JrQsNC70L7Rj9C9INCc0LXRhdCw0L3QtNC20LjQudGB0LrQuA==?= To: ports@FreeBSD.org, brnrd@FreeBSD.org 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> Subject: Re: FreeBSD Port: databases/galera [with Mariadb 101] MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [94.156.233.43] X-Mailer: Zimbra 8.0.8_GA_6038 (ZimbraWebClient - FF47 (Linux)/8.0.8_GA_6038) Thread-Topic: FreeBSD Port: databases/galera [with Mariadb 101] Thread-Index: 8l5ttCk15MkRgbQAiIRZhgE2/qK2XPCu7Qm5 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 24 Jul 2017 12:31:26 -0000 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" 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.