mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.34-79.1-79.1 Percona XtraDB Cluster (GPL), Release 5.6.34-26.19.4c779b7, wsrep_26.19
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Yakkety post upgrade sync check:
mysql: [Warning] Using a password on the command line interface can be insecure. 26.19.4c779b7, wsrep_26.19
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.34-79.1-79.1 Percona XtraDB Cluster (GPL), Release 5.6.34-
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show status like 'wsrep%'; ------- ------- ------- ---+--- ------- ------- ------- ------- ------- ------- ----+ ------- ------- ------- ---+--- ------- ------- ------- ------- ------- ------- ----+ state_uuid | 9fbaa3b6- 07cc-11e7- 804b-bf92e21596 77 | version | 7 | committed | 0 | d_bytes | 0 | keys_bytes | 0 | data_bytes | 0 | other_bytes | 0 | bytes | 1459 | cert_failures | 0 | send_queue | 0 | send_queue_ max | 1 | send_queue_ min | 0 | send_queue_ avg | 0.000000 | recv_queue | 0 | recv_queue_ max | 1 | recv_queue_ min | 0 | recv_queue_ avg | 0.000000 | cached_ downto | 0 | control_ paused_ ns | 0 | control_ paused | 0.000000 | control_ sent | 0 | control_ recv | 0 | deps_distance | 0.000000 | state_comment | Synced | index_size | 0 | bucket_ count | 22 | pool_size | 1320 | addresses | 10.5.26. 95:3306, 10.5.26. 96:3306, 10.5.26. 94:3306 | evict_list | | repl_latency | 0/0/0/0/0 | 07ce-11e7- 9b48-530e1c80de c7 | conf_id | 9 | state_uuid | 9fbaa3b6- 07cc-11e7- 804b-bf92e21596 77 | status | Primary | bf_aborts | 0 | vendor | Codership Oy <email address hidden> | version | 3.19(rXXXX) | ------- ------- ------- ---+--- ------- ------- ------- ------- ------- ------- ----+
+------
| Variable_name | Value |
+------
| wsrep_local_
| wsrep_protocol_
| wsrep_last_
| wsrep_replicated | 0 |
| wsrep_replicate
| wsrep_repl_keys | 0 |
| wsrep_repl_
| wsrep_repl_
| wsrep_repl_
| wsrep_received | 6 |
| wsrep_received_
| wsrep_local_commits | 0 |
| wsrep_local_
| wsrep_local_replays | 0 |
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_local_
| wsrep_flow_
| 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_cert_
| wsrep_gcache_
| wsrep_causal_reads | 0 |
| wsrep_cert_interval | 0.000000 |
| wsrep_incoming_
| wsrep_desync_count | 0 |
| wsrep_evs_delayed | |
| wsrep_evs_
| wsrep_evs_
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | 979db34b-
| wsrep_cluster_
| wsrep_cluster_size | 3 |
| wsrep_cluster_
| wsrep_cluster_
| wsrep_connected | ON |
| wsrep_local_
| wsrep_local_index | 0 |
| wsrep_provider_name | Galera |
| wsrep_provider_
| wsrep_provider_
| wsrep_ready | ON |
+------
59 rows in set (0.00 sec)