4. 启动DBMind
在主控节点,切换到openGauss-DBMind目录下,输入如下命令启动DBMind:
-
启动配置,会在openGauss-DBMind目录下创建dbmindconf/dbmind.conf配置文件:
gs_dbmind service setup -c dbmindconf
-
切换到openGauss-DBMind目录,并修改配置文件:
vi dbmindconf/dbmind.conf
其中必填的配置项如下:
-
TSDB
TDSB为时序数据库配置,即prometheus相关信息。
[TSDB] name = prometheus # The type of time-series database. Options: prometheus. host = {主控节点ip:192.168.100.4} # Address of time-series database. port = 9090 # Port to connect to time-series database.
-
METADATABASE
DBMind服务器所创建的metadatabase数据库相关信息,注意用户需要有数据库创建的权限。在启动DBMind之前,需要把metadatabase创建好。
[METADATABASE] dbtype = opengauss # Database type. Options: sqlite, opengauss, postgresql. host = {数据库主节点ip:192.168.100.1} # Address of meta-data database. port = {数据库占用的端口号:6789} # Port to connect to meta-data database. username = dbmind_monitor # User name to connect to meta-data database. password = test_123 # Password to connect to meta-data database. database = metadatabase # Database name to connect to meta-data database.
-
WORKER
该模块用于指定DBMind可以使用的worker子进程数量,如果写0则会进行自适应,尽可能多地使用CPU资源。
用户可以使用
cat /proc/cpuinfo | grep "physical id" | fort | uniq | wc -l
命令查看逻辑CPU的个数,根据服务器情况配置worker子进程数量。[WORKER] process_num = 2 # Number of worker processes on a local node. Less than or equal to zero means adaptive.
-
AGENT
该模块用于指定DBMind连接到openGauss Agent的信息。使用该Agent,可以让DBMind获取到被监控实例的即时状态,从而提高分析准确性。同时,也可以向数据库实例下发一些变更动作。
master_url为
http://{DBMind服务器IP}:{opengauss_exporter监听端口}
,置空会自动识别。usename为数据库实例的dbmind_minotor用户。
[AGENT] master_url = username = dbmind_monitor # Username to login the monitoring database. Credential for agent. password = test_123 # Password to login the monitoring database. Credential for agent.
-
TIMED_TASK
设置定时任务:
- discard_expired_results: 删除过期结果
- self_monitoring:指标异常监控
- daily_inspection:日检
- weekly_inspection:周检
- monthly_inspection: 月检
- slow_sql_diagnosis:慢SQL诊断
- knob_recommend:参数调优
- slow_query_killer:慢SQL查杀
[TIMED_TASK] task=discard_expired_results,self_monitoring,daily_inspection, weekly_inspection,slow_sql_diagnosis,knob_recommend,slow_query_killer# select the scheduled task to start,separated by ','.
-
WEB-SERVICE
[WEB-SERVICE] host = 192.168.100.4 # Which host to bind for web service. '0.0.0.0' means to bind all. port = 8080 # Port to listen for web serivce.
-
-
配置项初始化:
gs_dbmind service setup --initialize -c dbmindconf
-
启动DBMind服务:
gs_dbmind service start -c dbmindconf
上述步骤执行完之后,就可以通过http://{DBMind服务器IP}:8080
访问DBMind前台页面。