kingbase 查看主备信息

kingbase 查看主备信息

## 切换kingbase账户
root@user-PC:~# su - kingbase
## 进入ksql 目录
kingbase@user-PC: cd /home/kingbase/cluster/cluster/db/bin
## 通过ksql 连接上数据库
kingbase@user-PC:~/cluster/cluster/db/bin$ ./ksql -USYSTEM -W123456 -dTEST -p9999
## 查看数据库节点信息
TEST=# show pool_nodes;
 node_id |    hostname    | port  | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay 
---------+----------------+-------+--------+-----------+---------+------------+-------------------+-------------------
 0       | 10.XXX.XXX.150 | 54321 | up     | 0.250000  | primary | 0          | false             | 0
 1       | 10.XXX.XXX.152 | 54321 | up     | 0.250000  | standby | 0          | true              | 0
 2       | 10.XXX.XXX.154 | 54321 | up     | 0.250000  | standby | 0          | false             | 0
 3       | 10.XXX.XXX.156 | 54321 | up     | 0.250000  | standby | 0          | false             | 0
(4 rows)
## 退出
TEST=# \q