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