通过非云原生监控Exporter 监控MySQL数据库
1、首先部署MySQL至Kubernetes集群中,直接配置MySQL权限即可
[root@k8s-master01 prometheus]# kubectl create deployment mysql --image=registry.cn-beijing.aliyuncs.com/dotbalo/mysql:5.7.23 [root@k8s-master01 prometheus]# kubectl set env deployment/mysql MYSQL_ROOT_PASSWORD=mysql deployment.apps/mysql env updated
查看Pod是否正常
创建Service暴露MySQL
[root@k8s-master01 prometheus]# kubectl expose deploy mysql --port 3306 service/mysql exposed
[root@k8s-master01 prometheus]# kubectl get svc -l app=mysql
NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
mysql ClusterIP 192.168.133.253 <none> 3306/TCP 38s
检查Service是否可用(通过telnet 测试cluster IP的3306端口即可)
授权
对于我们非云原应用监控来说,要想通过Exporter采集到数据库服务的监控数据,还需要登陆MySQL,创建Exporter所需要的用户和权限(如果已经有需要监控的MySQL,可以直接执行此步骤即可)
[root@k8s-master01 prometheus]# kubectl exec -it mysql-69d6f69557-g7xd6 -- bash root@mysql-69d6f69557-g7xd6:/# ls bin boot dev docker-entrypoint-initdb.d entrypoint.sh etc home lib lib64 media mnt opt proc root run sbin srv sys tmp usr var root@mysql-69d6f69557-g7xd6:/# mysql -u root -pmysql #验证登陆 mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.23 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec) mysql> create user 'exporter'@'%' identified by 'exporter' with max_user_connections 3; #创建exporter用户,最大连接数为3 Query OK, 0 rows affected (0.01 sec) mysql> grant process, replication client, select on *.* to 'exporter'@'%'; #授予该用户复制客户端、查看所有库、所有表权限 Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; #刷新权限列表,避免权限没有正常生效 Query OK, 0 rows affected (0.01 sec) mysql> quit;
2、配置MySQL Exporter采集MySQL监控数据
[root@k8s-master01 prometheus]# vim mysql-exporter.yaml
--- apiVersion: apps/v1 kind: Deployment metadata: name: mysql-exporter namespace: monitoring spec: replicas: 1 selector: matchLabels: k8s-app: mysql-exporter template: metadata: labels: k8s-app: mysql-exporter spec: containers: - name: mysql-exporter image: registry.cn-beijing.aliyuncs.com/dotbalo/mysqld-exporter env: - name: DATA_SOURCE_NAME value: "exporter:exporter@(mysql.default:3306)/" #value: "exporter:exporter@(mysql.default:3306)/" #如果对接的是外部mysql数据库,那么该地址可以直接写IP imagePullPolicy: IfNotPresent ports: - containerPort: 9104 --- apiVersion: v1 kind: Service metadata: name: mysql-exporter namespace: monitoring labels: k8s-app: mysql-exporter spec: type: ClusterIP selector: k8s-app: mysql-exporter ports: - name: api port: 9104 protocol: TCP
创建exporter以及service的yaml文件
#kubectl apply -f mysql-exporter.yaml
此时上述yaml文件创建完成之后会暴露出一个metrics接口,我们可以通过Service地址,检查是否能正常获取Metrics数据:
[root@k8s-master01 prometheus]# curl 192.168.212.135:9104/metrics
3、 配置ServiceMonitor和Grafana
#vim mysql-am.yaml
apiVersion: monitoring.coreos.com/v1 kind: ServiceMonitor metadata: name: mysql-exporter namespace: monitoring labels: k8s-app: mysql-exporter namespace: monitoring spec: jobLabel: k8s-app endpoints: - port: api interval: 30s scheme: http selector: matchLabels: k8s-app: mysql-exporter namespaceSelector: matchNames: - monitoring [root@k8s-master01 prometheus]# kubectl apply -f mysql-am.yaml servicemonitor.monitoring.coreos.com/mysql-exporter created
接下来我们可以在Prometheus Web UI界面看到该监控
4、最后我们将导入Grafana dashboard模版,URL地址:地址:https://grafana.com/grafana/dashboards/6239