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