Hi Niklaas, in MariaDB 10.1, Galera replicator needs to be explicitely enabled. Try adding this to your configuration file:
wsrep_on=ON Kind regards GL Le jeu. 2 juin 2016 à 08:56, Niklaas Baudet von Gersdorff <st...@niklaas.eu> a écrit : > Hello, > > I'm trying to setup a galera cluster on FreeBSD. I followed the > instructions on [1] but every time I issue > > SHOW STATUS LIKE 'wsrep_cluster_size'; > > I get > > +--------------------+-------+ > | Variable_name | Value | > +--------------------+-------+ > | wsrep_cluster_size | 0 | > +--------------------+-------+ > 1 row in set (0.00 sec) > > So, the cluster is not working. This is the configuration of the node > that I want to set as primary: > > -----------------------------------8<----------------------------------- > > [mysqld] > datadir=/var/db/mysql > socket=/tmp/mysql.sock > user=mysql > binlog_format=ROW > bind-address=0.0.0.0 > default_storage_engine=innodb > innodb_autoinc_lock_mode=2 > innodb_flush_log_at_trx_commit=0 > innodb_buffer_pool_size=122M > wsrep_provider=/usr/local/lib/libgalera_smm.so > wsrep_provider_options="gcache.size=300M; gcache.page_size=300M" > wsrep_cluster_name="klaas_cluster" > wsrep_cluster_address="gcomm://" > #wsrep_cluster_address="gcomm://10.1.7.1,10.1.7.2,10.3.7.1" > wsrep_sst_method=rsync > > [mysql] > wsrep_cluster_name=klaas_cluster > wsrep_cluster_address="gcomm://10.1.7.1,10.1.7.2,10.3.7.1" > wsrep_node_name=box-hlm-01 > wsrep_node_address="10.1.7.1" > > [mysql_safe] > log-error=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > ----------------------------------->8----------------------------------- > > On the other two nodes the configuration is the same, except (1) only > the second `wsrep_cluster_address` exists; (2) `wsrep_node_address` > differs, obviously. > > Instead of using an "empty" `wsrep_cluster_address` I also tried setting > > mysql_args="--wsrep-new-cluster" > > in /etc/rc.conf without getting the desired result. The logs lack any > relevant warnings or errors: > > -----------------------------------8<----------------------------------- > > 160602 07:59:44 mysqld_safe mysqld from pid file > /var/db/mysql/mariadb1.box-hlm-01.klaas.pid ended > 160602 08:00:34 mysqld_safe Starting mysqld daemon with databases from > /var/db/mysql > 2016-06-02 8:00:34 34426872832 [Note] /usr/local/libexec/mysqld (mysqld > 10.1.13-MariaDB) starting as process 22580 ... > 2016-06-02 8:00:34 34426872832 [Warning] You need to use --log-bin to > make --binlog-format work. > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Using mutexes to ref count > buffer pool pages > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: The InnoDB memory heap is > disabled > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Mutexes and rw_locks use > GCC atomic builtins > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Memory barrier is not used > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Compressed tables use zlib > 1.2.8 > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Using SSE crc32 instructions > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Initializing buffer pool, > size = 122.0M > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Completed initialization of > buffer pool > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Highest supported file > format is Barracuda. > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: 128 rollback segment(s) are > active. > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Waiting for purge to start > 2016-06-02 8:00:34 34426872832 [Note] InnoDB: Percona XtraDB ( > http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616955 > 2016-06-02 8:00:34 34426872832 [Note] Plugin 'FEEDBACK' is disabled. > 2016-06-02 8:00:34 34426899456 [Note] InnoDB: Dumping buffer pool(s) not > yet started > 2016-06-02 8:00:34 34426872832 [Note] Server socket created on IP: > '0.0.0.0'. > 2016-06-02 8:00:34 34426872832 [Note] /usr/local/libexec/mysqld: ready > for connections. > Version: '10.1.13-MariaDB' socket: '/tmp/mysql.sock' port: 3306 > FreeBSD Ports > > ----------------------------------->8----------------------------------- > > Any help is very much appreciated. > > Niklaas > > 1: http://galeracluster.com/documentation-webpages/index.html > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
