From owner-freebsd-ports@freebsd.org Fri Mar 3 17:45:11 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 38CD7CF6188 for ; Fri, 3 Mar 2017 17:45:11 +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 236ED1198 for ; Fri, 3 Mar 2017 17:45:11 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: by mailman.ysv.freebsd.org (Postfix) id 22CF9CF6187; Fri, 3 Mar 2017 17:45:11 +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 227F8CF6186 for ; Fri, 3 Mar 2017 17:45:11 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: from mx.deltanews.bg (mx.trud.bg [94.156.233.44]) by mx1.freebsd.org (Postfix) with ESMTP id D5E4D1197; Fri, 3 Mar 2017 17:45:09 +0000 (UTC) (envelope-from k_georgiev@forumnews.bg) Received: from localhost (localhost [127.0.0.1]) by mx.deltanews.bg (Postfix) with ESMTP id 7700398C01; Fri, 3 Mar 2017 19:35:18 +0200 (EET) 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 IAlxo-RwTpbZ; Fri, 3 Mar 2017 19:35:18 +0200 (EET) Received: from mx.deltanews.bg (localhost [127.0.0.1]) by mx.deltanews.bg (Postfix) with ESMTP id E6E3E98BFE; Fri, 3 Mar 2017 19:35:17 +0200 (EET) Received: from mx.deltanews.bg (mx [94.156.233.44]) by mx.deltanews.bg (Postfix) with ESMTP id C5ABE98BFD; Fri, 3 Mar 2017 19:35:17 +0200 (EET) Date: Fri, 3 Mar 2017 19:35:17 +0200 (EET) From: =?utf-8?B?0JrQsNC70L7Rj9C9INCc0LXRhdCw0L3QtNC20LjQudGB0LrQuA==?= To: ports@FreeBSD.org, brnrd@FreeBSD.org Message-ID: <1693959347.790664.1488562517398.JavaMail.zimbra@forumnews.bg> In-Reply-To: <2056479608.790136.1488561708846.JavaMail.zimbra@forumnews.bg> Subject: FreeBSD Port: databases/galera [with Mariadb 101] MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [78.90.214.14] X-Mailer: Zimbra 8.0.8_GA_6038 (ZimbraWebClient - FF51 (Linux)/8.0.8_GA_6038) Thread-Topic: FreeBSD Port: databases/galera [with Mariadb 101] Thread-Index: 8l5ttCk15MkRgbQAiIRZhgE2/qK2XA== 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: Fri, 03 Mar 2017 17:45:11 -0000 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.