2 Star 0 Fork 1

GY / dmdbms_exporters

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
贡献代码
同步代码
取消
提示: 由于 Git 不支持空文件夾,创建文件夹后会生成空的 .keep 文件
Loading...
README
MulanPSL-2.0

DM_EXPORTER的介绍以及使用说明

介绍

  1. DM数据库适配prometheus监控的采集器,目前已支持DM8数据库同时提供grafana 8.5.X 以上版本的监控面板。
  2. 目前dm_exporter已支持的功能
    • 支持对数据库的各项指标进行采集
    • 支持对数据库进行定期巡检
    • 支持DMHS的相关指标进行监控

代码目录介绍

  1. doc目录存放的是代码中的监控项
  2. src目录是源代码目录
  3. 表盘目录存放的是grafana的相关表盘
  4. other_config目录存放的是grafana组件的配置文件
  5. export_plugin目录存放的是dm_exporter的插件

搭建效果图



搭建步骤

1. 下载dm_exporter包

下载地址: https://gitee.com/gy297879328/dmdbms_exporters/releases/download/v2.0.5/dm_prometheus_2.0.5.zip

2. 新建用户权限

## 最小化权限
## 条件允许的话 最好赋予DBA权限
create tablespace "PROMETHEUS.DBF" datafile 'PROMETHEUS.DBF' size 512 CACHE = NORMAL;
create user "PROMETHEUS" identified by "PROMETHEUS";
alter user "PROMETHEUS" default tablespace "PROMETHEUS.DBF" default index tablespace "PROMETHEUS.DBF";
grant "PUBLIC","RESOURCE","SOI","SVI","VTI" to "PROMETHEUS";
grant select on DBA_FREE_SPACE to PROMETHEUS;
grant select on DBA_DATA_FILES to PROMETHEUS;
grant select on DBA_USERS to PROMETHEUS;
grant select on V$SESSIONS to PROMETHEUS;

3. 在数据库上运行

  1. 解压dm_prometheus_2.0.5.zip
  2. 修改application.yml配置文件的数据库账号及密码
  3. 启动exporter程序
## 启动jar包前执行这句,避免jvm占用内存过多
[root@VM-24-17-centos dm_prometheus]#  export MALLOC_ARENA_MAX=2
## 启动服务
[root@VM-24-17-centos dm_prometheus]#  nohup java -jar -Xms256m  -Xmx1024m dm_prometheus-2.0.4.jar > /dev/null 2>&1 &
## 2. 访问接口
##  通过浏览器访问http://被监控端IP:9200/prometheus就可以查看到dm_prometheus在被监控端收集的监控信息
[root@server ~]# lsof -i:9200

4. 在prometheus上进行配置

修改prometheus的prometheus.yml配置文件 注:此处对外接口是/prometheus,需使用metrics_path指定 同时 cluster_name标签为必填项,因为grafan的模板会根据此标签做分类

# 添加的是数据库监控的接口9200接口,如果是一套集群,则在targets标签后进行逗号拼接,如下图所示
- job_name: "dm_db_single"
  metrics_path: "/prometheus"
  static_configs:
   - targets: ["192.168.112.135:9200"]
     labels:
     cluster_name: '单机测试'

5. 在grafana上导入提供的表盘

  1. 登录grafana登录,导入模板

  2. 所使用的模板在表盘中

  3. 效果图

更新记录

20240516_更新记录

  1. 优化dmdbms_version版本的字符串显示,优化显示过长的问题
  2. 优化接口调用的整体架构,每次调用接口末尾输出执行耗时

202404 更新记录_v2.0.5

  1. 完善进程监控逻辑,实现数据库实例目录以及安装目录的自适应识别
  2. 整理相关的xlsx表格
  3. "dmserver" "dmwatcher" "dmmonitor" "dmap" "dmagent" 探活 返回- 1:未开启监控 0:不存在进程 1:存在进程
  4. 返回本地归档状态 - 1:未开启归档 1:开启归档&归档有效 2:开启归档&归档无效
  5. 返回数据版本信息
  6. 返回实例启动天数
  7. 调整dmserver的检查逻辑,兼容前台./dmserver的场景识别
  8. hint 不可以写/+DMDB_CHECK_FLAG/ DM8 个别版本会报语法解析错误

20240412 更新记录_v2.0.4

  1. 新增dmdbms_check_tool_fail_node_info、dmdbms_check_tool_all_node_info标签,展示巡检失败的节点信息
  2. 优化dmdbms_check_tool_info标签,新增check_title的lable
  3. 新增yml文件的密码的动态加密

20240401更新记录_v2.0.3

  1. 将sort的默认值由原来的-1调整为0
  2. 新增grafana 7.0的表盘

20240331更新记录_v2.0.2

  1. 修复DM8下1.1.121版本 内存池数据空导致的标签错误
  2. 给所有的接口由原来的大try 改为 小try

20240327更新记录_v2.0.1

  1. 新增清理标签的功能,避免数据重复问题
  2. 优化dmdbms_node_uname_info标签的显示逻辑

20240308更新记录_v2.0.0

  1. 优化代码架构,新增参数dbcheck组,便于与巡检工具对接
  2. 新增dmdbms_check_tool_info、dmdbms_check_tool_create_time_info、dmdbms_check_tool_total_node_size_info、 dmdbms_check_tool_success_node_size_info、dmdbms_check_tool_fail_node_size_info、
  3. dmdbms_check_tool_result_info、dmdbms_check_tool_exec_interval_second_info指标,展示巡检的内容
  4. 新增dmdbms_user_list_info标签,显示用户列表
  5. 调整dmdbms_license_date标签的授权逻辑

20240108更新记录_v1.8

  1. 修改dmhs识别逻辑,非bin路径启动的识别逻辑
  2. 废弃dmdbms_checkpoint_info指标 改用 dmdbms_ckpttime_info
  3. 废弃dmdbms_unusable_index_info指标,大系统上查询太慢
  4. 优化代码架构,新增参数enableType=3 仅检查Dmhs的功能

202311016更新记录_v1.7

  1. 调整ckpt的指标,去除多标签问题。只查询使用时间

202311010更新记录_v1.6

  1. 新增指标ckpt个数的指标 dmdbms_ckpttime_info

20231109更新记录_v1.5

  1. 修改dmdbms_node_uname_info指标在arm和x86下表现差异的问题
  2. 新增对DDL INS的语句统计
  3. 新增对数据库检查点的更新
  4. 将慢SQL的统计延迟由秒级调整为毫秒数

20231106更新记录

  1. 查询Sql时新增lastRecvTime字段

20231031更新记录

  1. 新增监控SQL语句的指标(dmdbms_slow_sql_info)
  2. 新增监控监视器进程的指标(dmdbms_monitor_info)
  3. 对所有监控SQL新增标识

20231030更新记录

  1. 如何difference等于小于0 则直接将值置为0 因时间不同步导致

20231011更新记录

  1. 新增运行脚本checkPointTime (dmdbms_dmhs_check_point_delay)
  2. 新增dmhs进程探活检查getHsProcessExit (dmdbms_dmhs_process_is_exit)

20231011更新记录

  1. 新增主备集群延迟_task_num (dmdbms_rapply_sys_task_num)
  2. 主备集群延迟内存堆栈_sys_task_mem_used (dmdbms_rapply_sys_task_mem_used)

20230918更新记录

  1. 新增prometheus的监控项整理
  2. 将授权日期由时间戳调整为字符串年月日形式

20230912更新记录

  1. 屏蔽掉报错 MeterServiceImpl类

20230911更新记录

  1. 新增获取当前数据库授权
  2. 新增新增数据库实例的错误事件
  3. 新增失效索引数量检查

20231012更新记录

  1. 将读取数据库配置文件属性的逻辑添加到application.yml中
木兰宽松许可证, 第2版 木兰宽松许可证, 第2版 2020年1月 http://license.coscl.org.cn/MulanPSL2 您对“软件”的复制、使用、修改及分发受木兰宽松许可证,第2版(“本许可证”)的如下条款的约束: 0. 定义 “软件”是指由“贡献”构成的许可在“本许可证”下的程序和相关文档的集合。 “贡献”是指由任一“贡献者”许可在“本许可证”下的受版权法保护的作品。 “贡献者”是指将受版权法保护的作品许可在“本许可证”下的自然人或“法人实体”。 “法人实体”是指提交贡献的机构及其“关联实体”。 “关联实体”是指,对“本许可证”下的行为方而言,控制、受控制或与其共同受控制的机构,此处的控制是指有受控方或共同受控方至少50%直接或间接的投票权、资金或其他有价证券。 1. 授予版权许可 每个“贡献者”根据“本许可证”授予您永久性的、全球性的、免费的、非独占的、不可撤销的版权许可,您可以复制、使用、修改、分发其“贡献”,不论修改与否。 2. 授予专利许可 每个“贡献者”根据“本许可证”授予您永久性的、全球性的、免费的、非独占的、不可撤销的(根据本条规定撤销除外)专利许可,供您制造、委托制造、使用、许诺销售、销售、进口其“贡献”或以其他方式转移其“贡献”。前述专利许可仅限于“贡献者”现在或将来拥有或控制的其“贡献”本身或其“贡献”与许可“贡献”时的“软件”结合而将必然会侵犯的专利权利要求,不包括对“贡献”的修改或包含“贡献”的其他结合。如果您或您的“关联实体”直接或间接地,就“软件”或其中的“贡献”对任何人发起专利侵权诉讼(包括反诉或交叉诉讼)或其他专利维权行动,指控其侵犯专利权,则“本许可证”授予您对“软件”的专利许可自您提起诉讼或发起维权行动之日终止。 3. 无商标许可 “本许可证”不提供对“贡献者”的商品名称、商标、服务标志或产品名称的商标许可,但您为满足第4条规定的声明义务而必须使用除外。 4. 分发限制 您可以在任何媒介中将“软件”以源程序形式或可执行形式重新分发,不论修改与否,但您必须向接收者提供“本许可证”的副本,并保留“软件”中的版权、商标、专利及免责声明。 5. 免责声明与责任限制 “软件”及其中的“贡献”在提供时不带任何明示或默示的担保。在任何情况下,“贡献者”或版权所有者不对任何人因使用“软件”或其中的“贡献”而引发的任何直接或间接损失承担责任,不论因何种原因导致或者基于何种法律理论,即使其曾被建议有此种损失的可能性。 6. 语言 “本许可证”以中英文双语表述,中英文版本具有同等法律效力。如果中英文版本存在任何冲突不一致,以中文版为准。 条款结束 如何将木兰宽松许可证,第2版,应用到您的软件 如果您希望将木兰宽松许可证,第2版,应用到您的新软件,为了方便接收者查阅,建议您完成如下三步: 1, 请您补充如下声明中的空白,包括软件名、软件的首次发表年份以及您作为版权人的名字; 2, 请您在软件包的一级目录下创建以“LICENSE”为名的文件,将整个许可证文本放入该文件中; 3, 请将如下声明文本放入每个源文件的头部注释中。 Copyright (c) [Year] [name of copyright holder] [Software Name] is licensed under Mulan PSL v2. You can use this software according to the terms and conditions of the Mulan PSL v2. You may obtain a copy of Mulan PSL v2 at: http://license.coscl.org.cn/MulanPSL2 THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. See the Mulan PSL v2 for more details. Mulan Permissive Software License,Version 2 Mulan Permissive Software License,Version 2 (Mulan PSL v2) January 2020 http://license.coscl.org.cn/MulanPSL2 Your reproduction, use, modification and distribution of the Software shall be subject to Mulan PSL v2 (this License) with the following terms and conditions: 0. Definition Software means the program and related documents which are licensed under this License and comprise all Contribution(s). Contribution means the copyrightable work licensed by a particular Contributor under this License. Contributor means the Individual or Legal Entity who licenses its copyrightable work under this License. Legal Entity means the entity making a Contribution and all its Affiliates. Affiliates means entities that control, are controlled by, or are under common control with the acting entity under this License, ‘control’ means direct or indirect ownership of at least fifty percent (50%) of the voting power, capital or other securities of controlled or commonly controlled entity. 1. Grant of Copyright License Subject to the terms and conditions of this License, each Contributor hereby grants to you a perpetual, worldwide, royalty-free, non-exclusive, irrevocable copyright license to reproduce, use, modify, or distribute its Contribution, with modification or not. 2. Grant of Patent License Subject to the terms and conditions of this License, each Contributor hereby grants to you a perpetual, worldwide, royalty-free, non-exclusive, irrevocable (except for revocation under this Section) patent license to make, have made, use, offer for sale, sell, import or otherwise transfer its Contribution, where such patent license is only limited to the patent claims owned or controlled by such Contributor now or in future which will be necessarily infringed by its Contribution alone, or by combination of the Contribution with the Software to which the Contribution was contributed. The patent license shall not apply to any modification of the Contribution, and any other combination which includes the Contribution. If you or your Affiliates directly or indirectly institute patent litigation (including a cross claim or counterclaim in a litigation) or other patent enforcement activities against any individual or entity by alleging that the Software or any Contribution in it infringes patents, then any patent license granted to you under this License for the Software shall terminate as of the date such litigation or activity is filed or taken. 3. No Trademark License No trademark license is granted to use the trade names, trademarks, service marks, or product names of Contributor, except as required to fulfill notice requirements in Section 4. 4. Distribution Restriction You may distribute the Software in any medium with or without modification, whether in source or executable forms, provided that you provide recipients with a copy of this License and retain copyright, patent, trademark and disclaimer statements in the Software. 5. Disclaimer of Warranty and Limitation of Liability THE SOFTWARE AND CONTRIBUTION IN IT ARE PROVIDED WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED. IN NO EVENT SHALL ANY CONTRIBUTOR OR COPYRIGHT HOLDER BE LIABLE TO YOU FOR ANY DAMAGES, INCLUDING, BUT NOT LIMITED TO ANY DIRECT, OR INDIRECT, SPECIAL OR CONSEQUENTIAL DAMAGES ARISING FROM YOUR USE OR INABILITY TO USE THE SOFTWARE OR THE CONTRIBUTION IN IT, NO MATTER HOW IT’S CAUSED OR BASED ON WHICH LEGAL THEORY, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. 6. Language THIS LICENSE IS WRITTEN IN BOTH CHINESE AND ENGLISH, AND THE CHINESE VERSION AND ENGLISH VERSION SHALL HAVE THE SAME LEGAL EFFECT. IN THE CASE OF DIVERGENCE BETWEEN THE CHINESE AND ENGLISH VERSIONS, THE CHINESE VERSION SHALL PREVAIL. END OF THE TERMS AND CONDITIONS How to Apply the Mulan Permissive Software License,Version 2 (Mulan PSL v2) to Your Software To apply the Mulan PSL v2 to your work, for easy identification by recipients, you are suggested to complete following three steps: i Fill in the blanks in following statement, including insert your software name, the year of the first publication of your software, and your name identified as the copyright owner; ii Create a file named “LICENSE” which contains the whole context of this License in the first directory of your software package; iii Attach the statement to the appropriate annotated syntax at the beginning of each source file. Copyright (c) [Year] [name of copyright holder] [Software Name] is licensed under Mulan PSL v2. You can use this software according to the terms and conditions of the Mulan PSL v2. You may obtain a copy of Mulan PSL v2 at: http://license.coscl.org.cn/MulanPSL2 THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. See the Mulan PSL v2 for more details.

简介

DM数据库的exporter采集器,对接prometheus 展开 收起
Java
MulanPSL-2.0
取消

发行版 (1)

全部

贡献者

全部

近期动态

加载更多
不能加载更多了
Java
1
https://gitee.com/gy297879328/dmdbms_exporters.git
git@gitee.com:gy297879328/dmdbms_exporters.git
gy297879328
dmdbms_exporters
dmdbms_exporters
master

搜索帮助