{"id":712,"date":"2025-02-20T08:41:25","date_gmt":"2025-02-20T00:41:25","guid":{"rendered":"http:\/\/192.168.5.24\/?p=712"},"modified":"2025-05-30T14:44:28","modified_gmt":"2025-05-30T06:44:28","slug":"prometheusgrafana%e7%9b%91%e6%8e%a7%e7%9a%84%e9%83%a8%e7%bd%b2","status":"publish","type":"post","link":"https:\/\/bigvip.dpdns.org\/?p=712","title":{"rendered":"Prometheus+grafana\u76d1\u63a7\u7684\u90e8\u7f72"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u4ecb\u7ecd<\/h2>\n\n\n\n<p>\u7565<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u5b89\u88c5prometheus\u53caexporter<\/h2>\n\n\n\n<p>Mysqld\u88ab\u76d1\u63a7\u7aef\u5b89\u88c5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum -y install mariadb-server\ntar -zxvf mysqld_exporter-0.11.0.linux-amd64.tar.gz\ncd mysqld_exporter-0.11.0.linux-amd64\nln -s \/root\/mysqld_exporter-0.11.0.linux-amd64\/mysqld_exporter \/bin\/\nsystemctl start mariadb\nmysql -uroot -p -e \"grant replication client,process on *.* to 'mysql_monitor'@'%' identified by '123';\"\n\nvi \/etc\/my.cnf.d\/client.cnf\n&#91;client]\nuser=mysql_monitor\npassword=123\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\n\n\u8fd0\u884cmysqld\u76d1\u63a7\u7aef\n&#91;root@localhost ~]# mysqld_exporter --config.my-cnf=\/etc\/my.cnf.d\/client.cnf\nINFO&#91;0000] Starting mysqld_exporter (version=0.11.0, branch=HEAD, revision=5d7179615695a61ecc3b5bf90a2a7c76a9592cdd)  source=\"mysqld_exporter.go:206\"\nINFO&#91;0000] Build context (go=go1.10.3, user=root@3d3ff666b0e4, date=20180629-15:00:35)  source=\"mysqld_exporter.go:207\"\nINFO&#91;0000] Enabled scrapers:                             source=\"mysqld_exporter.go:218\"\nINFO&#91;0000]  --collect.global_status                      source=\"mysqld_exporter.go:222\"\nINFO&#91;0000]  --collect.global_variables                   source=\"mysqld_exporter.go:222\"\nINFO&#91;0000]  --collect.slave_status                       source=\"mysqld_exporter.go:222\"\nINFO&#91;0000]  --collect.info_schema.tables                 source=\"mysqld_exporter.go:222\"\nINFO&#91;0000] Listening on :9104                            source=\"mysqld_exporter.go:232\"<\/code><\/pre>\n\n\n\n<p>\u670d\u52a1\u7aef\u5b89\u88c5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uff081\uff09\u5b89\u88c5prometheus\nyum -y install  prometheus\n\uff082\uff09\u6dfb\u52a0\u76d1\u63a7\u70b9\n\n&#91;root@node4 ~]# grep -Ev \"^&#91;&#91;:space:]]*(#|$)\" \/etc\/prometheus\/prometheus.yml\nglobal:\n  scrape_interval:     15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.\n  evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.\nalerting:\n  alertmanagers:\n  - static_configs:\n    - targets:\nrule_files:\nscrape_configs:\n  - job_name: 'prometheus'\n    static_configs:\n    - targets: &#91;'localhost:9090']\n<strong>  - job_name: 'mysqld'\n    static_configs:\n    - targets: &#91;'192.168.168.122:9104']<\/strong>\n\n\uff083\uff09\u8fd0\u884cprometheus\nprometheus  --config.file=\/etc\/prometheus\/prometheus.yml --log.level=debug<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u5b89\u88c5grafana\u5e76\u6dfb\u52a0\u76d1\u63a7\u9879\u7ed8\u56fe<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>yum -y install grafana-enterprise\nsystemctl start grafana-server<\/code><\/pre>\n\n\n\n<p>\u7528\u6d4f\u89c8\u5668\u6253\u5f00grafana\u670d\u52a1\u5668\u7684ip:3000<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"897\" height=\"630\" src=\"http:\/\/192.168.5.24\/wp-content\/uploads\/2025\/01\/image.png\" alt=\"\" class=\"wp-image-736\" srcset=\"https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2025\/01\/image.png 897w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2025\/01\/image-300x211.png 300w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2025\/01\/image-768x539.png 768w, https:\/\/bigvip.dpdns.org\/wp-content\/uploads\/2025\/01\/image-816x573.png 816w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/figure>\n\n\n\n<p>\u4f7f\u7528\u9ed8\u8ba4\u7528\u6237\u540d\u5bc6\u7801admin\/admin\u767b\u5f55<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u6ce8\u610f\u4e8b\u9879<\/h2>\n\n\n\n<p>\u65e0<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u4ecb\u7ecd \u7565 \u4e8c\u3001\u5b89\u88c5prometheus\u53caexporter Mysqld\u88ab\u76d1\u63a7\u7aef\u5b89\u88c5 \u670d\u52a1\u7aef\u5b89\u88c5 \u4e09\u3001\u5b89\u88c5g [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[20,36],"tags":[99],"class_list":["post-712","post","type-post","status-publish","format-aside","hentry","category-linux","category-36","tag-99","post_format-post-format-aside"],"_links":{"self":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts\/712","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=712"}],"version-history":[{"count":14,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts\/712\/revisions"}],"predecessor-version":[{"id":1246,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=\/wp\/v2\/posts\/712\/revisions\/1246"}],"wp:attachment":[{"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bigvip.dpdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}