Skip to content

Latest commit

 

History

History
124 lines (104 loc) · 4.7 KB

SQL-HA-Status.md

File metadata and controls

124 lines (104 loc) · 4.7 KB
Raw
search
keywords
SQL
HA SATUS
HA
high availability
status

SQL - HA STATUS

(Since v2.2) Retrieves information about HA.

Syntax

HA STATUS [-servers] [-db] [-latency] [-messages] [-all] [-output=text]
  • -servers Dumps the configuration of servers
  • -db Dumps the configuration of the database
  • -latency Dumps the replication latency between servers (since v2.2.6)
  • -messages Dumps the statistics about replication messages between servers (since v2.2.6)
  • -all Dumps all the information
  • -output=text Write the output as text formatted in readable tables

Examples

  • Display the configuration of servers

    orientdb> HA STATUS -servers -output=text

Executed '
+--------+------+------------------------+-----+---------+----------------+----------------+-----------------------+
|Name    |Status|Databases               |Conns|StartedOn|Binary          |HTTP            |UsedMemory             |
+--------+------+------------------------+-----+---------+----------------+----------------+-----------------------+
|europe1*|ONLINE|testdb01=ONLINE (MASTER)|0    |16:31:44 |192.168.1.5:2425|192.168.1.5:2481|183.06MB/3.56GB (5.03%)|
+--------+------+------------------------+-----+---------+----------------+----------------+-----------------------+
' in 0.002000 sec(s).

  • Display the configuration of the current database

    orientdb> HA STATUS -db -output=text
Executed '
LEGEND: X = Owner, o = Copy
+-----------+-----------+----------+-------+-------+
|           |           |          |MASTER |MASTER |
|           |           |          |ONLINE |ONLINE |
+-----------+-----------+----------+-------+-------+
|CLUSTER    |writeQuorum|readQuorum|europe1|europe0|
+-----------+-----------+----------+-------+-------+
|*          |     2     |    1     |   X   |       |
|data_1     |     2     |    1     |   o   |   X   |
|data_2     |     2     |    1     |   o   |   X   |
|data_3     |     2     |    1     |   o   |   X   |
|data_4     |     2     |    1     |   o   |   X   |
|e_4        |     2     |    1     |   o   |   X   |
|e_5        |     2     |    1     |   o   |   X   |
|e_6        |     2     |    1     |   o   |   X   |
|e_7        |     2     |    1     |   o   |   X   |
|internal   |     2     |    1     |       |       |
|ofunction_0|     2     |    1     |   o   |   X   |
|orole_0    |     2     |    1     |   o   |   X   |
|oschedule_0|     2     |    1     |   o   |   X   |
|osequence_0|     2     |    1     |   o   |   X   |
|ouser_0    |     2     |    1     |   o   |   X   |
|person     |     2     |    1     |   o   |   X   |
|person_1   |     2     |    1     |   o   |   X   |
|person_6   |     2     |    1     |   o   |   X   |
|person_7   |     2     |    1     |   o   |   X   |
|v_3        |     2     |    1     |   o   |   X   |
|v_5        |     2     |    1     |   o   |   X   |
|v_6        |     2     |    1     |   o   |   X   |
|v_7        |     2     |    1     |   o   |   X   |
+-----------+-----------+----------+-------+-------+
' in 0.050000 sec(s).

  • Display the replication latency between servers (Since v2.2.6)

    orientdb> HA STATUS -latency -output=text

Executed '
REPLICATION LATENCY AVERAGE (in milliseconds)
+-------+-----+------+-----+
|Servers|node1|node2*|node3|
+-------+-----+------+-----+
|node1  |     |  0.60| 0.43|
|node2* | 0.39|      | 0.38|
|node3  | 0.35|  0.53|     |
+-------+-----+------+-----+  
' in 0.023000 sec(s).

  • Display the statistics about replication messages between servers (Since v2.2.6)

    orientdb> HA STATUS -messages -output=text

Executed '
REPLICATION MESSAGE COUNTERS
+-------+------+------+------+
|Servers| node1|node2*| node3|
+-------+------+------+------+
|node1  |      |     9|     5|
|node2* |64,476|      |53,593|
|node3  |     5|     5|      |
+-------+------+------+------+
  
REPLICATION MESSAGE COORDINATOR STATS
+-------+------+---------+------------+---------------+
|Servers|tx    |heartbeat|tx-completed|deploy_delta_db|
+-------+------+---------+------------+---------------+
|node1  |2     |28       |1           |               |
|node3* |56,379|20       |56,379      |2              |
+-------+------+---------+------------+---------------+  
' in 0.005000 sec(s).

For more information, see