How to monitor multiple databases from a single instance of the exporter as in a cluster ? We have a galera mariadb cluster. Should I install the exporter on all the nodes of the cluster ?
Please help ... On Tuesday, August 22, 2023 at 6:27:08 PM UTC+5:30 Y.G Kumar wrote: > Yes you are right. Able to make it work after the mysqld option. Thanks > Brian for your help. Appreciate it.... > > On Tuesday, August 22, 2023 at 1:08:58 PM UTC+5:30 Brian Candler wrote: > >> What does "telnet 127.0.0.1 3306" show? >> >> You haven't shown the mariadb "LISTEN" socket. If it's listening on >> 10.0.0.4:3306 rather than 0.0.0.0:3306 or *:3306, then it will only >> accept connections on 10.0.0.4:3306, and not 127.0.0.1:3306. >> >> You can see from your original error message that the exporter connects >> to localhost:3306 by default, as documented under the general flags >> <https://github.com/prometheus/mysqld_exporter/#general-flags>: >> >> mysqld.address >> Hostname and port used for connecting to MySQL server, format: host:port. >> (default: locahost:3306) >> Therefore, if this is the only target you want to scrape, you could pass >> --mysqld.address=10.0.0.4:3306 to override this. >> >> You could also do this through the scraping URL /probe with a "target" >> parameter: >> curl -s <IP>:9104/probe?target=10.0.0.4:3306 >> >> This is documented here: >> https://github.com/prometheus/mysqld_exporter/#multi-target-support >> However, that feature was only introduced in version v0.15.0 >> <https://github.com/prometheus/mysqld_exporter/releases/tag/v0.15.0>. >> >> On Tuesday, 22 August 2023 at 06:16:35 UTC+1 Y.G Kumar wrote: >> >>> The mariadb service is infact running on the node on 3306: >>> -- >>> # telnet 10.0.0.4 3306 >>> Trying 10.0.0.4 ... >>> Connected to 10.0.0.4 . >>> Escape character is '^]'. >>> u >>> 5.5.5-10.6.10-MariaDB-1:10.6.10+maria~ubu2004-logVcYvf{X'V�_X}.iHlf<69\mysql_native_password^CConnection >>> >>> closed by foreign host. >>> --- >>> >>> tcp 0 0 10.0.0.4:3306 10.0.0.4:55890 ESTABLISHED >>> 2863920/mariadbd >>> >>> But still the exporter is not able to detect the service. Not sure where >>> it is going wrong ? >>> >>> >>> On Tuesday, August 22, 2023 at 10:10:02 AM UTC+5:30 Y.G Kumar wrote: >>> >>>> What is the exact configuration option to mention the port number of >>>> the service ? >>>> >>>> On Friday, August 18, 2023 at 5:55:58 PM UTC+5:30 Brian Candler wrote: >>>> >>>>> > dial tcp 127.0.0.1:3306: connect: connection refused >>>>> >>>>> Your mariadb is not listening on TCP port 3306 on the loopback address >>>>> (127.0.0.1). >>>>> >>>>> If you show what command you use to connect to mariadb normally (e.g. >>>>> using the "mysql" command line client) it should be possible to configure >>>>> the mysql export to talk the same way. You would set this in whatever >>>>> file >>>>> you give to --config.my-cnf (defaults to ~/.my.cnf) >>>>> See https://github.com/prometheus/mysqld_exporter/ >>>>> >>>>> On Friday, 18 August 2023 at 13:06:06 UTC+1 Y.G Kumar wrote: >>>>> >>>>>> Hi All, >>>>>> >>>>>> We have a galera mariadb 10.6 version three node cluster. When I >>>>>> tried installing mysql exporter by following the link >>>>>> https://computingforgeeks.com/monitoring-mysql-mariadb-with-prometheus-in-five-minutes/?expand_article=1 >>>>>> >>>>>> , I could not get the exporter to detect the mysql service in which it >>>>>> is >>>>>> running .. These are the logs: >>>>>> -- >>>>>> /tmp# curl -s <IP>:9104/metrics | grep mysql_up >>>>>> ts=2023-08-18T11:22:21.544Z caller=exporter.go:152 level=error >>>>>> msg="Error pinging mysqld" err="dial tcp 127.0.0.1:3306: connect: >>>>>> connection refused" >>>>>> # HELP mysql_up Whether the MySQL server is up. >>>>>> # TYPE mysql_up gauge >>>>>> mysql_up 0 >>>>>> --- >>>>>> >>>>>> But the mariadb service is running on this node: >>>>>> --- >>>>>> ● mariadb.service - MariaDB 10.6.10 database server >>>>>> Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; >>>>>> vendor preset: enabled) >>>>>> Drop-In: /etc/systemd/system/mariadb.service.d >>>>>> └─migrated-from-my.cnf-settings.conf, override.conf >>>>>> Active: active (running) since Wed 2023-05-10 23:10:13 UTC; 3 >>>>>> months 8 days ago >>>>>> Docs: man:mariadbd(8) >>>>>> https://mariadb.com/kb/en/library/systemd/ >>>>>> Main PID: 2540463 (mariadbd) >>>>>> Status: "Taking your SQL requests now..." >>>>>> Tasks: 1587 (limit: 618903) >>>>>> CPU: 2w 5d 9h 34min 28.076s >>>>>> CGroup: /galera.slice/mariadb.service >>>>>> └─2540463 /usr/sbin/mariadbd >>>>>> --wsrep_start_position=d635b506-3dd8-11e8-989e-7aec6efd1673:2862939478 >>>>>> --- >>>>>> >>>>>> Can anyone help me where the fault is ? I have given enough >>>>>> privileges for the 'mysqld_exporter' user as well. >>>>>> >>>>>> Thanks >>>>>> Kumar >>>>>> >>>>>> -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/bb160663-7b8a-4aaf-8c76-9c1956c51bfdn%40googlegroups.com.
