maria-discuss team mailing list archive

[Niklaas Baudet von Gersdorff <stdin@xxxxxxxxxx>]

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