problem with sync

Trying to set up a cluster of three nodes and there is no synchronization.
Conf node1:

[mysqld]
server_id=1
binlog_format=ROW
log_bin=mysql-bin
wsrep_cluster_address=gcomm://
wsrep_provider=/usr/lib/libgalera_smm.so
datadir=/var/lib/mysql

wsrep_slave_threads=2
wsrep_cluster_name=pxctest
wsrep_sst_method=xtrabackup
wsrep_node_name=Galera_cluster

log_slave_updates

innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_buffer_pool_size=400M
innodb_log_file_size=64M

Conf node2:

[mysqld]
server_id=2
binlog_format=ROW
log_bin=mysql-bin
wsrep_cluster_address=gcomm://192.168.0.102 // <- this ip node1
wsrep_provider=/usr/lib/libgalera_smm.so
datadir=/var/lib/mysql

wsrep_slave_threads=2
wsrep_cluster_name=pxctest
wsrep_sst_method=xtrabackup
wsrep_node_name=Galera_cluster2

log_slave_updates

innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
innodb_buffer_pool_size=400M
innodb_log_file_size=64M

root@ubuntu:/etc/mysql# ls -oa /usr/lib/libgalera_smm.so
-rw-r–r-- 1 root 2252744 Jan 30 09:31 /usr/lib/libgalera_smm.so

First start mysql on node1, then node2.

mysql> show global status like ‘wsrep%’;
±-------------------------±---------------------+
| Variable_name | Value |
±-------------------------±---------------------+
| wsrep_cluster_conf_id | 18446744073709551615 |
| wsrep_cluster_size | 0 |
| wsrep_cluster_state_uuid | |
| wsrep_cluster_status | Disconnected |
| wsrep_connected | OFF |
| wsrep_local_index | 18446744073709551615 |
| wsrep_provider_name | |
| wsrep_provider_vendor | |
| wsrep_provider_version | |
| wsrep_ready | ON |
±-------------------------±---------------------+
10 rows in set (0.00 sec)

Other things I’ve checked:

Firewall: none running
Conflicting ports: none
SELinux: disabled

What am I doing wrong? Grateful for the help in advance

PS Found in the logs of mysql row:
WSREP: wsrep_load(): loading provider library ‘none’

although libgalera_smm.so is in place and is registered in the config

Are you still having this issue? could you please send un the full error log?

The “mysql> show global status like ‘wsrep%’;” was from the node1? if not, could you please send us the output of that command from the node1?

Regards,

Martin