管理Uqbar
通过PTK安装Uqbar数据库后,用户可对数据库进行相关操作,包括启动、停止、重启数据库以及查看数据库状态。
说明:下面以集群uqbar110为例。
启动数据库集群
在安装完数据库集群后,PTK 默认会将数据库集群启动。
此外,可通过 cluster start 指令启动集群,需指定集群的集群名称。
# ptk cluster -n uqbar110 start
INFO[2022-12-02T10:22:56.957] operation: start                             
INFO[2022-12-02T10:22:56.957] ========================================     
INFO[2022-12-02T10:22:56.957] start db [172.16.0.127:27009] ...            
INFO[2022-12-02T10:22:58.058] start db [172.16.0.127:27009] successfully   
INFO[2022-12-02T10:22:58.203] ========================================     
INFO[2022-12-02T10:22:58.203] start cluster successfully同时,PTK 默认会启动集群内所有实例,PTK 也支持指定单个实例启动,需指定实例的IP:
# ptk cluster -n uqbar110 start -H 192.168.122.101停止数据库集群
如果想要停止数据库集群,可以通过 cluster stop 指令,默认会停止集群内所有实例:
# ptk cluster -n uqbar110 stop
INFO[2022-12-02T10:16:28.092] operation: stop                              
INFO[2022-12-02T10:16:28.092] ========================================     
INFO[2022-12-02T10:16:28.092] stop db [172.16.0.127:27009] ...             
INFO[2022-12-02T10:16:29.157] stop db [172.16.0.127:27009] successfully    
INFO[2022-12-02T10:16:29.157] ========================================     
INFO[2022-12-02T10:16:29.158] stop successfully             如果想要停止集群内某个实例,可通过 -H 指定实例的IP,例如:
ptk cluster -n uqbar110 stop -H 192.168.122.101重启数据库集群
重启集群的操作,本质上是先停止数据库,再启动数据库的组合操作。
可通过 cluster restart 指令来实现:
# ptk cluster -n uqbar110 restart
INFO[2022-12-02T10:01:09.013] operation: stop                              
INFO[2022-12-02T10:01:09.014] ========================================     
INFO[2022-12-02T10:01:09.014] stop db [172.16.0.127:27009] ...             
INFO[2022-12-02T10:01:10.079] stop db [172.16.0.127:27009] successfully    
INFO[2022-12-02T10:01:10.079] ========================================     
INFO[2022-12-02T10:01:10.079] stop successfully                            
INFO[2022-12-02T10:01:10.080] operation: start                             
INFO[2022-12-02T10:01:10.080] ========================================     
INFO[2022-12-02T10:01:10.080] start db [172.16.0.127:27009] ...            
INFO[2022-12-02T10:01:11.185] start db [172.16.0.127:27009] successfully   
INFO[2022-12-02T10:01:11.329] ========================================     
INFO[2022-12-02T10:01:11.329] start cluster successfully查看数据库状态
可通过-n指定集群名称或通过-f指定配置文件来查看数据库状态:
注意:如果通过配置文件查询数据库状态,需要在配置文件所在目录下执行查询命令。
[root@hostname]# ptk cluster status -n uqbar110
[   Cluster State   ]
database_version                        : Uqbar-Uqbar
cluster_name                            : uqbar110
cluster_state                           : Normal
current_az                              : AZ_ALL
[  Datanode State   ]
   id  |      ip      | port  | user  | instance | db_role | state   
-------+--------------+-------+-------+----------+---------+---------
  6001 | 172.16.0.245 | 27000 | omm01 | dn_6001  | Normal  | Normal