I'm attaching the logs from my system. There are no errors, except that it tries to re-connect.
3:30 iptables enabled now a little querying and trying to insert into a test table 3:36 iptables removed
Cluster size was also all the time 9. No node dropped out of the cluster. Below is a status snapshot from one of the nodes.
date; mysql55 mysqlxdb20s -e "show global status like 'wsrep_%';" Mon May 27 09:34:03 CEST 2013
wsrep_local_state_uuid | 23ce172b-31c5-11e2-0800-b3f49bb7dd1f wsrep_protocol_version | 4 wsrep_last_committed | 1835663 wsrep_replicated | 3877 wsrep_replicated_bytes | 4082149 wsrep_received | 329716 wsrep_received_bytes | 1064015606 wsrep_local_commits | 3875 wsrep_local_cert_failures | 0 wsrep_local_bf_aborts | 2 wsrep_local_replays | 0 wsrep_local_send_queue | 0 wsrep_local_send_queue_avg | 0.000000 wsrep_local_recv_queue | 0 wsrep_local_recv_queue_avg | 0.000000 wsrep_flow_control_paused | 0.000000 wsrep_flow_control_sent | 0 wsrep_flow_control_recv | 0 wsrep_cert_deps_distance | 220.757988 wsrep_apply_oooe | 0.000000 wsrep_apply_oool | 0.000000 wsrep_apply_window | 0.000000 wsrep_commit_oooe | 0.000000 wsrep_commit_oool | 0.000000 wsrep_commit_window | 0.000000 wsrep_local_state | 4 wsrep_local_state_comment | Synced wsrep_cert_index_size | 24845 wsrep_causal_reads | 0 wsrep_incoming_addresses | 10.10.1.123:3306,10.20.1.134:3306,10.20.1.135:3306,10.20.1.133:3306,,10.10.1.125:3306,10.20.1.190:3306,10.10.1.122:3306,10.10.1.124:3306 wsrep_cluster_conf_id | 55 wsrep_cluster_size | 9 wsrep_cluster_state_uuid | 23ce172b-31c5-11e2-0800-b3f49bb7dd1f wsrep_cluster_status | Primary wsrep_connected | ON wsrep_local_index | 3 wsrep_provider_name | Galera wsrep_provider_vendor | Codership Oy <email address hidden> wsrep_provider_version | 2.5(r150) wsrep_ready | ON
I'm attaching the logs from my system.
There are no errors, except that it tries to re-connect.
3:30 iptables enabled
now a little querying and trying to insert into a test table
3:36 iptables removed
Cluster size was also all the time 9. No node dropped out of the cluster.
Below is a status snapshot from one of the nodes.
date; mysql55 mysqlxdb20s -e "show global status like 'wsrep_%';"
Mon May 27 09:34:03 CEST 2013
wsrep_local_ state_uuid | 23ce172b- 31c5-11e2- 0800-b3f49bb7dd 1f version | 4 committed | 1835663 d_bytes | 4082149 bytes | 1064015606 cert_failures | 0 bf_aborts | 2 send_queue | 0 send_queue_ avg | 0.000000 recv_queue | 0 recv_queue_ avg | 0.000000 control_ paused | 0.000000 control_ sent | 0 control_ recv | 0 deps_distance | 220.757988 state_comment | Synced index_size | 24845 addresses | 10.10.1. 123:3306, 10.20.1. 134:3306, 10.20.1. 135:3306, 10.20.1. 133:3306, ,10.10. 1.125:3306, 10.20.1. 190:3306, 10.10.1. 122:3306, 10.10.1. 124:3306 conf_id | 55 state_uuid | 23ce172b- 31c5-11e2- 0800-b3f49bb7dd 1f status | Primary vendor | Codership Oy <email address hidden> version | 2.5(r150)
wsrep_protocol_
wsrep_last_
wsrep_replicated | 3877
wsrep_replicate
wsrep_received | 329716
wsrep_received_
wsrep_local_commits | 3875
wsrep_local_
wsrep_local_
wsrep_local_replays | 0
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_flow_
wsrep_flow_
wsrep_flow_
wsrep_cert_
wsrep_apply_oooe | 0.000000
wsrep_apply_oool | 0.000000
wsrep_apply_window | 0.000000
wsrep_commit_oooe | 0.000000
wsrep_commit_oool | 0.000000
wsrep_commit_window | 0.000000
wsrep_local_state | 4
wsrep_local_
wsrep_cert_
wsrep_causal_reads | 0
wsrep_incoming_
wsrep_cluster_
wsrep_cluster_size | 9
wsrep_cluster_
wsrep_cluster_
wsrep_connected | ON
wsrep_local_index | 3
wsrep_provider_name | Galera
wsrep_provider_
wsrep_provider_
wsrep_ready | ON