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