加载mysqld_exporter
cd prometheus_exporter/mysqld_exporter-0.12.1.linux-amd64
创建MySQL数据库监控用户:
create user mysql_monitor@'%' identified by 'Mysql_monitor123';
GRANT REPLICATION CLIENT, PROCESS ON *.* TO mysql_monitor@'%';
GRANT SELECT ON performance_schema.* TO mysql_monitor@'%';
vim .my.cnf
[client]
host=localhost
port=3306
user=mysql_monitor
password=Mysql_monitor123
后台运行服务
nohup ./mysqld_exporter --config.my-cnf=.my.cnf &
加载oracle_exporter
下载oracle客户端安装包,配置安装,需要19C
https://www.oracle.com/cn/database/technologies/instant-client/linux-x86-64-downloads.html
这里使用root用安装19C的客户端
rpm -ivh oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm
[root@oracle21 prometheus_exporter]# rpm -ivh oracle-instantclient19.5-basic-19.5.0.0.0-1.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:oracle-instantclient19.5-basic-19################################# [100%]
[root@oracle21 prometheus_exporter]# cd /usr/lib/oracle/19.3/client64/network/admin
-bash: cd: /usr/lib/oracle/19.3/client64/network/admin: No such file or directory
[root@oracle21 prometheus_exporter]# cd /usr/lib/oracle/19.5/client64/
[root@