SQL - HA STATUS

(Since v2.2) Retrieves information about HA.

Syntax

HA STATUS [-servers] [-db] [-all] [-output=text]

• -servers Dumps the configuration of servers
• -db Dumps the configuration of the database
• -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).
  

For more information, see

• Distributed Architecture
• SQL Commands
• Console Commands