Archery mysql-exprt修改后的资源包，可以一个监控多个mysql实例

## mysqld_exporter 改造为探针型 > 使用方法 1. 下载二进制或自行编译 ```shell script # 下载二进制 wget https://github.com/ning1875/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz # 源码编译 git clone https://github.com/ning1875/mysqld_exporter.git && build ``` 2. 解压tar包，使用和原版一样的命令行参数启动mysqld_exporter进程 3. 浏览器访问或者curl测试如下 ```shell script curl 'http://localhost:9104/probe?dsn=root:123123@tcp(localhost:3306)/' ``` - dsn还是常规的dsn : user=root ,pass=123123 ,host=localhost ,port=3306 - 如果能显示metrics接口证明ok 4. prometheus配置文件传参 ```yaml - job_name: mysql_exporter honor_timestamps: true scrape_interval: 15s scrape_timeout: 15s metrics_path: /probe scheme: http relabel_configs: - source_labels: [__address__] separator: ; regex: (.*) target_label: __param_dsn replacement: $1 action: replace - source_labels: [__param_dsn] separator: ; regex: .*tcp\((.*?)\).* target_label: instance replacement: $1 action: replace - separator: ; regex: (.*) target_label: __address__ replacement: localhost:9105 action: replace static_configs: - targets: - user:pass@tcp(mysql_ip1:3306)/ - user:pass@tcp(mysql_ip2:3306)/ ```