Can’t seem to get hosts talking to each other. Cluster size is always 1 and, even though I can ping boxes from each other, they won’t join.
Followed the guide here: [url]Percona XtraDB Cluster
with these packages:
Percona-XtraDB-Cluster-56-debuginfo.x86_64
1:5.6.21-25.8.940.el7 @percona
Percona-XtraDB-Cluster-client-56.x86_64 1:5.6.21-25.8.940.el7 @percona
Percona-XtraDB-Cluster-full-56.x86_64 1:5.6.21-25.8.940.el7 @percona
Percona-XtraDB-Cluster-galera-3.x86_64 3.8-1.3390.rhel7 @percona
Percona-XtraDB-Cluster-galera-3-debuginfo.x86_64
3.8-1.3390.rhel7 @percona
Percona-XtraDB-Cluster-garbd-3.x86_64 3.8-1.3390.rhel7 @percona
Percona-XtraDB-Cluster-server-56.x86_64 1:5.6.21-25.8.940.el7 @percona
Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.21-25.8.940.el7 @percona
Percona-XtraDB-Cluster-test-56.x86_64 1:5.6.21-25.8.940.el7 @percona
percona-release.x86_64 0.0-1 installed
percona-xtrabackup.x86_64 2.2.7-5050.el7 @percona
Host 1:
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_incoming_addresses | 192.168.197.115:3306 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | eace2c17-8b9a-11e4-a4e2-375c869d986a |
| wsrep_cluster_conf_id | 3 |
| wsrep_cluster_size | 1 |
| wsrep_cluster_state_uuid | 98047d41-8b9a-11e4-9b38-37945e1e5709 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
[root@localhost ~]# cat /etc/my.cnf
[mysqld]
# Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
# Cluster connection URL contains the IPs of node#1, node#2 and node#3
#wsrep_cluster_address=gcomm://192.168.197.115,192.168.136.56,192.168.134.12
wsrep_cluster_address=gcomm://
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node address
wsrep_node_address=192.168.197.115
#
wsrep_cluster_name=vfcluster1
wsrep_sst_method=xtrabackup
wsrep_sst_auth="sstuser:sstpass"
# LOGGING #
log-bin = /var/lib/mysql/bin.log
log_error = /var/log/mysql/mysql-error.log
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1
[root@localhost ~]# garbd -a gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no -g vfcluster1
2014-12-24 14:10:10.615 INFO: CRC-32C: using hardware acceleration.
2014-12-24 14:10:10.615 INFO: Read config:
daemon: 0
name: garb
address: gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no
group: vfcluster1
sst: trivial
donor:
options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs.fc_master_slave=yes
cfg:
log:
2014-12-24 14:10:10.617 INFO: protonet asio version 0
2014-12-24 14:10:10.617 INFO: Using CRC-32C for message checksums.
2014-12-24 14:10:10.618 INFO: backend: asio
2014-12-24 14:10:10.619 WARN: access file(gvwstate.dat) failed(No such file or directory)
2014-12-24 14:10:10.619 INFO: restore pc from disk failed
2014-12-24 14:10:10.620 INFO: GMCast version 0
terminate called after throwing an instance of 'gu::NotSet'
Aborted
Host 2:
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_incoming_addresses | 192.168.197.115:3306 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | 6acc4184-8b9d-11e4-be4b-f666cd9bd1e5 |
| wsrep_cluster_conf_id | 1 |
| wsrep_cluster_size | 1 |
| wsrep_cluster_state_uuid | 389ea7e8-8b9d-11e4-9dda-e6c798b477e1 |
| wsrep_cluster_status | Primary |
[root@localhost ~]# cat /etc/my.cnf
[mysqld]
# Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
# Cluster connection URL contains the IPs of node#1, node#2 and node#3
wsrep_cluster_address=gcomm://192.168.197.115,192.168.136.56,192.168.134.12
#wsrep_cluster_address=gcomm://
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node address
wsrep_node_address=192.168.197.115
#
wsrep_cluster_name=vfcluster1
wsrep_sst_method=xtrabackup
wsrep_sst_auth="sstuser:sstpass"
# LOGGING #
log-bin = /var/lib/mysql/bin.log
log_error = /var/log/mysql/mysql-error.log
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1
[root@localhost ~]# garbd -a gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no -g vfcluster1
2014-12-24 13:55:55.622 INFO: CRC-32C: using hardware acceleration.
2014-12-24 13:55:55.622 INFO: Read config:
daemon: 0
name: garb
address: gcomm://192.168.197.115,192.168.136.56,192.168.134.12?pc.wait_prim=no
group: vfcluster1
sst: trivial
donor:
options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs.fc_master_slave=yes
cfg:
log:
2014-12-24 13:55:55.624 INFO: protonet asio version 0
2014-12-24 13:55:55.624 INFO: Using CRC-32C for message checksums.
2014-12-24 13:55:55.625 INFO: backend: asio
2014-12-24 13:55:55.625 WARN: access file(gvwstate.dat) failed(No such file or directory)
2014-12-24 13:55:55.626 INFO: restore pc from disk failed
2014-12-24 13:55:55.627 INFO: GMCast version 0
terminate called after throwing an instance of 'gu::NotSet'
Aborted