Skip to content

Instantly share code, notes, and snippets.

@CaptTofu
Last active June 2, 2016 21:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save CaptTofu/c3b86d7ad848e3029ed86ac4bec9b7d4 to your computer and use it in GitHub Desktop.
Save CaptTofu/c3b86d7ad848e3029ed86ac4bec9b7d4 to your computer and use it in GitHub Desktop.
Patricks-MacBook-Pro:mysql-galera patg$ kubectl get pods
NAME READY STATUS RESTARTS AGE
pxc-node1-sg8eq 1/1 Running 0 5m
pxc-node2-z0m4k 1/1 Running 0 5m
pxc-node3-rr95e 0/1 ContainerCreating 0 2m
Patricks-MacBook-Pro:mysql-galera patg$ kubectl exec pxc-node2-z0m4k -i -t -- mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.24-72.2-56-log Percona XtraDB Cluster (GPL), Release rel72.2, Revision 43abf03, WSREP version 25.11, wsrep_25.11
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, 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_cluster_size';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| wsrep_cluster_size | 2 |
+--------------------+-------+
1 row in set (0.00 sec)
mysql> show status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| wsrep_cluster_size | 3 |
+--------------------+-------+
1 row in set (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment