Comment 4 for bug 1182960

Revision history for this message
Marco Schirrmeister (marcoschirrmeister) wrote :

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