Problem with setting up a Galera cluster

[Cesar Da Silva]

Hi!

I am trying to setup a 3 node galera cluster and have installed the following packages:

 

mariadb-client/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 all [installed]
mariadb-client-10.0/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 armhf [installed,automatic]
mariadb-client-core-10.0/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 armhf[installed,automatic]
mariadb-common/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 all [installed,automatic]
mariadb-server/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 all [installed]
mariadb-server-10.0/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 armhf [installed,automatic]
mariadb-server-core-10.0/xenial-security,xenial-updates,now 10.0.31-0ubuntu0.16.04.2 armhf [installed,automatic]
galera-3/xenial,now 25.3.14-1 armhf [installed]

 

I have created a galera.cnf file which I put in /etc/mysql/conf.d/. Here is my current galera.cnf file:

 

[mysqld]
#mysql settings
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_doublewrite=1
query_cache_size=0
query_cache_type=0
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=256M
bind-address=192.168.1.101

#
# * Galera-related settings
#
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/libgalera_smm.so
binlog_format=ROW
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
default_storage_engine=InnoDB
innodb_log_file_size=100M
innodb_file_per_table
innodb_flush_log_at_trx_commit=1
wsrep_cluster_address="gcomm://192.168.1.8,192.168.1.9,192.168.1.101"
wsrep_cluster_name='galera'
wsrep_node_address='192.168.1.101'
wsrep_node_name='node01'
#wsrep_sst_method=xtrabackup-2
wsrep_sst_method=rsync
wsrep_sst_auth=galera:PASSWORD

 

I have the first node on an VM machine running on a  PC, and start it with the command "galera_new_cluster" without any issue. But the node  running the following kernel

Linux web01.dasilva.network 3.4.113-sun8i #18 SMP PREEMPT Thu Jun 15 02:16:06 CEST 2017 armv7l armv7l armv7l GNU/Linux

and the following distribution:

DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.3 LTS"

 

Does not want to start as a node of the galera cluster. He does not even run the galera configuration according to the log. I also have tried to change the file permissin to 777 for the galera.cnf file. Here is the relevant log entries:

 

Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] /usr/sbin/mysqld (mysqld 10.0.31-MariaDB-0ubuntu0.16.04.2) starting as process 1241 ...
Aug 27 15:18:50 web01 mysqld: /usr/sbin/mysqld: Query cache is disabled (resize or similar command in progress); repeat this command later
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: The InnoDB memory heap is disabled
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Compressed tables use zlib 1.2.8
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Using Linux native AIO
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Not using CPU crc32 instructions
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Initializing buffer pool, size = 256.0M
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Completed initialization of buffer pool
Aug 27 15:18:50 web01 mysqld: 170827 15:18:50 [Note] InnoDB: Highest supported file format is Barracuda.
Aug 27 15:18:51 web01 mysqld: 170827 15:18:51 [Note] InnoDB: 128 rollback segment(s) are active.
Aug 27 15:18:51 web01 mysqld: 170827 15:18:51 [Note] InnoDB: Waiting for purge to start
Aug 27 15:18:51 web01 mysqld: 170827 15:18:51 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1617103
Aug 27 15:18:51 web01 mysqld: 170827 15:18:51 [Note] Plugin 'FEEDBACK' is disabled.
Aug 27 15:18:51 web01 mysqld: 170827 15:18:51 [Note] Server socket created on IP: '192.168.1.101'.
Aug 27 15:18:51 web01 mysqld: 170827 15:18:51 [Note] /usr/sbin/mysqld: ready for connections.
Aug 27 15:18:51 web01 mysqld: Version: '10.0.31-MariaDB-0ubuntu0.16.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 16.04

 

Any suggestions on how to make this work?

 

Regards,

Cesar da Silva