Skip to content

Instantly share code, notes, and snippets.

@qix

qix/gist:5cd8573968da4c4760e7

Created April 10, 2015 21:06
Show Gist options
  • Save qix/5cd8573968da4c4760e7 to your computer and use it in GitHub Desktop.
Save qix/5cd8573968da4c4760e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> SHOW LEAVES;
+---------------+------+--------------------+---------------+-----------+---------+--------------------+------------------------------+
| Host | Port | Availability_Group | Pair_Host | Pair_Port | State | Opened_Connections | Average_Roundtrip_Latency_ms |
+---------------+------+--------------------+---------------+-----------+---------+--------------------+------------------------------+
| memsql-leaf7 | 3306 | 1 | memsql-leaf8 | 3306 | online | 131 | 1.448 |
| memsql-leaf8 | 3306 | 2 | memsql-leaf7 | 3306 | offline | 1 | NULL |
| memsql-leaf9 | 3306 | 1 | memsql-leaf10 | 3306 | online | 66 | 1.205 |
| memsql-leaf10 | 3306 | 2 | memsql-leaf9 | 3306 | offline | 9 | NULL |
+---------------+------+--------------------+---------------+-----------+---------+--------------------+------------------------------+
@qix
Copy link
Author

qix commented Apr 10, 2015 

mysql> SHOW REPLICATION STATUS;
+--------+------------+-----------+----------------+--------------------------------+-----------+-----------------+-------------+----------------+---------------+--------------+
| Role   | Database   | MasterURI | MasterPosition | SlaveURI                       | Connected | NetworkPosition | SlaveState  | ReplayPosition | MasterCommits | SlaveCommits |
+--------+------------+-----------+----------------+--------------------------------+-----------+-----------------+-------------+----------------+---------------+--------------+
| master | authbox    | NULL      | 0:8814         | 10.240.201.86:3306/authbox     | no        | NULL            | NULL        | NULL           |            11 |         NULL |
| master | authbox    | NULL      | 0:8814         | 10.240.137.247:3306/authbox    | no        | NULL            | NULL        | NULL           |            11 |         NULL |
| master | authbox    | NULL      | 0:8814         | 10.240.229.63:3306/authbox     | yes       | 0:8814          | replicating | 0:8814         |            11 |            9 |
| master | authbox    | NULL      | 0:8814         | 10.240.243.74:3306/authbox     | yes       | 0:8814          | replicating | 0:8814         |            11 |            9 |
| master | authbox    | NULL      | 0:8814         | 10.240.143.229:3306/authbox    | yes       | 0:8814          | replicating | 0:8814         |            11 |            9 |
| master | authbox    | NULL      | 0:8814         | 10.240.143.222:3306/authbox    | yes       | 0:8814          | replicating | 0:8814         |            11 |            9 |
| master | memsql_ops | NULL      | 3:168752489    | 10.240.201.86:3306/memsql_ops  | no        | NULL            | NULL        | NULL           |        194490 |         NULL |
| master | memsql_ops | NULL      | 3:168752489    | 10.240.137.247:3306/memsql_ops | no        | NULL            | NULL        | NULL           |        194490 |         NULL |
| master | memsql_ops | NULL      | 3:168752489    | 10.240.143.229:3306/memsql_ops | yes       | 3:168752489     | replicating | 3:168752489    |        194490 |       194490 |
| master | memsql_ops | NULL      | 3:168752489    | 10.240.243.74:3306/memsql_ops  | yes       | 3:168752489     | replicating | 3:168752489    |        194490 |       194490 |
| master | memsql_ops | NULL      | 3:168752489    | 10.240.143.222:3306/memsql_ops | yes       | 3:168752489     | replicating | 3:168752489    |        194490 |       194490 |
| master | memsql_ops | NULL      | 3:168752489    | 10.240.229.63:3306/memsql_ops  | yes       | 3:168752489     | replicating | 3:168752489    |        194490 |       194490 |
| master | sharding   | NULL      | 0:11082        | 10.240.201.86:3306/sharding    | no        | NULL            | NULL        | NULL           |           217 |         NULL |
| master | sharding   | NULL      | 0:11082        | 10.240.137.247:3306/sharding   | no        | NULL            | NULL        | NULL           |           217 |         NULL |
| master | sharding   | NULL      | 0:11082        | 10.240.243.74:3306/sharding    | yes       | 0:11082         | replicating | 0:11082        |           217 |          217 |
| master | sharding   | NULL      | 0:11082        | 10.240.143.222:3306/sharding   | yes       | 0:11082         | replicating | 0:11082        |           217 |          217 |
| master | sharding   | NULL      | 0:11082        | 10.240.229.63:3306/sharding    | yes       | 0:11082         | replicating | 0:11082        |           217 |          217 |
| master | sharding   | NULL      | 0:11082        | 10.240.143.229:3306/sharding   | yes       | 0:11082         | replicating | 0:11082        |           217 |          217 |
+--------+------------+-----------+----------------+--------------------------------+-----------+-----------------+-------------+----------------+---------------+--------------+

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment