You said *"I want to keep the mysql exporter only on node A and remove it on nodes B and C"*
Then what happens if node A goes down? You'll lose all monitoring of B and C! If instead you put the exporter on your prometheus server, so that it remotely contacts A, B and C, that might be better. But unless your connections across the network are properly secured (e.g. with TLS and server certificate validation) you may be opening up your mysql server to attack. Putting the exporters directly on each node eliminates that problem. At worst, an attacker can get access to your metrics - but at least the database access credentials are not being sent across the wire. On Saturday, 9 September 2023 at 11:29:17 UTC+1 Y.G Kumar wrote: > Hi, > > I am trying to find out why the multi target approach is not advisable in > the case of mysql cluster ? > > > On Friday, September 8, 2023 at 5:06:44 PM UTC+5:30 Brian Candler wrote: > >> Ben's answer was clear and unambiguous, IMO. >> >> In the case of specific questions about the galera cluster, you'd be best >> to ask your vendor (or test the exporter's behaviour yourself). >> >> On Friday, 8 September 2023 at 11:07:36 UTC+1 Y.G Kumar wrote: >> >>> Any update ? >>> >>> On Thursday, September 7, 2023 at 9:07:34 PM UTC+5:30 Y.G Kumar wrote: >>> >>>> Ok, to clear the confusion at this point for me, is it good to have >>>> multi target approach in general ? >>>> Also the next question is, in the case of galera cluster, are the >>>> metrics same from each of the exporters ? since galera syncs the data >>>> among >>>> the cluster members ? Please explain.... >>>> Appreciate your time Brian and Ben. >>>> >>>> On Tuesday, September 5, 2023 at 6:37:31 PM UTC+5:30 Ben Kochie wrote: >>>> >>>>> The exporter is meant to run as a "side car", installed on every node >>>>> of your cluster. >>>>> >>>>> What you are doing is not following best practices. >>>>> >>>>> On Tue, Sep 5, 2023 at 2:42 PM Y.G Kumar <[email protected]> wrote: >>>>> >>>>>> Brian, >>>>>> >>>>>> This is what I am trying to achieve. I have a three node galera mysql >>>>>> cluster on three nodes A, B and C with respective IPs. >>>>>> As of now, I have installed mysql exporter in all the above three >>>>>> nodes and trying to access it using haproxy external IP using the above >>>>>> three nodes as backends. It is working fine. >>>>>> >>>>>> Now , I want to keep the mysql exporter only on node A and remove it >>>>>> on nodes B and C and start the multi target approach from node A only. >>>>>> So >>>>>> in the /etc/.mysqld_exporter.cnf file , how do I mention each section >>>>>> of >>>>>> the other two nodes ? This is my present file content in each of the >>>>>> nodes >>>>>> above: >>>>>> ---- >>>>>> [client] >>>>>> user=mysqld_exporter >>>>>> password=StrongPassword >>>>>> --- >>>>>> >>>>>> Please suggest.. >>>>>> >>>>>> Appreciate your time. >>>>>> >>>>>> Good day >>>>>> >>>>>> >>>>>> On Tuesday, August 29, 2023 at 12:46:50 PM UTC+5:30 Brian Candler >>>>>> wrote: >>>>>> >>>>>>> On Tuesday, 29 August 2023 at 07:34:58 UTC+1 Y.G Kumar wrote: >>>>>>> >>>>>>> Please help ... >>>>>>> >>>>>>> >>>>>>> Please start by reading the documentation at the link I posted >>>>>>> earlier in this thread: >>>>>>> https://github.com/prometheus/mysqld_exporter/#multi-target-support >>>>>>> >>>>>>> Then if you are unable to make this work, you can post a specific >>>>>>> question >>>>>>> <http://www.catb.org/~esr/faqs/smart-questions.html#beprecise>: >>>>>>> show exactly what you configured, what you expected to happen, and what >>>>>>> actually happened (with any logs or error messages). >>>>>>> >>>>>> -- >>>>>> 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/97eb8eb4-1ac6-4d47-9f7f-a07978cd4e6an%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/prometheus-users/97eb8eb4-1ac6-4d47-9f7f-a07978cd4e6an%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- 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/7a64db20-ebae-4050-bb4e-17c325a66c54n%40googlegroups.com.
