Differences

This shows you the differences between two versions of the page.

--- prometheus [2019/09/29 22:13] – dreiggy
+++ prometheus [2019/10/04 23:50] – dreiggy
@@ Line 3: / Line 3: @@
   * Grafana prometheus dashboard: https://grafana.com/grafana/dashboards/1860
   * Grafana prometheus percona mysqld dashboard: https://grafana.com/grafana/dashboards/7362
+  * Prometheus rules collection: https://awesome-prometheus-alerts.grep.to/rules.html
@@ Line 8: / Line 9: @@
 <code bash>
 sudo useradd node_exporter -s /sbin/nologin
+mkdir -p /opt/prom-exporters
 wget https://github.com/prometheus/node_exporter/releases/download/v*/node_exporter-*.*-amd64.tar.gz
 tar xvfz node_exporter-*.*-amd64.tar.gz
-sudo cp node_exporter-*.*-amd64/node_exporter /usr/sbin/
+sudo mv node_exporter-*.*-amd64/node_exporter /opt/prom-exporters/
+rm -rf node_exporter-*.*-amd64
 </code>
@@ Line 21: / Line 24: @@
 User=node_exporter
 EnvironmentFile=/etc/sysconfig/node_exporter
-ExecStart=/usr/sbin/node_exporter $OPTIONS
+ExecStart=/opt/prom-exporters/node_exporter $OPTIONS
 [Install]
@@ Line 52: / Line 55: @@
 GRANT SELECT ON performance_schema.* TO 'mysqld_exporter'@'localhost';
 FLUSH PRIVILEGES;
+</code>
+Create a mysql password file ''/opt/prom-exporters/.mysqld_exporter.cnf'':
+<code>
+[client]
+user=mysqld_exporter
+password=My_Secure_Password
+</code>
+Change file owner and permission:
+<code>
+chown prometheus. /opt/prom-exporters/.mysqld_exporter.cnf
+chmod 600 /opt/prom-exporters/.mysqld_exporter.cnf
 </code>
@@ Line 60: / Line 76: @@
 cd mysqld_exporter-0.12.1.linux-amd64
 chown prometheus. mysqld_exporter
-mv mysqld_exporter /usr/local/bin/
+mv mysqld_exporter /opt/prom-exporters/
 cd ..
 rm -rf mysqld_exporter-0.12.1.linux-amd64*
@@ Line 68: / Line 84: @@
 <code>
 [Unit]
-Description=MySQL Exporter Service
+Description=Prometheus MySQL Exporter
-Wants=network.target
 After=network.target
-[Service]
 User=prometheus
 Group=prometheus
-Environment="DATA_SOURCE_NAME=mysqld_exporter:password@unix(/var/run/mysqd/mysqld.sock)"
+[Service]
 Type=simple
-ExecStart=/usr/local/bin/mysqld_exporter
 Restart=always
+ExecStart=/opt/prom-exporters/mysqld_exporter \
+--config.my-cnf /opt/prom-exporters/.mysqld_exporter.cnf \
+--collect.global_status \
+--collect.info_schema.innodb_metrics \
+--collect.auto_increment.columns \
+--collect.info_schema.processlist \
+--collect.binlog_size \
+--collect.info_schema.tablestats \
+--collect.global_variables \
+--collect.info_schema.query_response_time \
+--collect.info_schema.userstats \
+--collect.info_schema.tables \
+--collect.perf_schema.tablelocks \
+--collect.perf_schema.file_events \
+--collect.perf_schema.eventswaits \
+--collect.perf_schema.indexiowaits \
+--collect.perf_schema.tableiowaits \
+--collect.slave_status \
+--web.listen-address=0.0.0.0:9104
 [Install]
@@ Line 90: / Line 122: @@
 sudo systemctl start mysqld_exporter
 </code>
+Once the MySQLd Exporter is installed, verify that metrics are being exported:
+<code bash>
+curl http://localhost:9104/metrics
+</code>
+===== Usefull links =====
+  * About monitoring: https://vc.ru/dev/62715-kak-my-stroili-monitoring-na-prometheus-clickhouse-i-elk