Thanks Brian. Appreciate it... On Monday, September 11, 2023 at 12:07:30 AM UTC+5:30 Brian Candler wrote:
> mysql exporter reports whatever the server it connects to reports. > > As I said before: if you have specific questions about the behaviour of a > galera cluster, you'd be best to ask your vendor (perhaps there's a mailing > list for galera?), or test the behaviour yourself. > > On Sunday, 10 September 2023 at 17:59:58 UTC+1 Y.G Kumar wrote: > >> Thanks Brian for your response. I am good to go now. One last query >> before I go ahead and implement the exporter. Since this is a MySQL >> cluster, do all the three nodes report the same metrics ? Or do the metrics >> differ for each node ? >> >> Thanks >> Y.G >> >> On Saturday, September 9, 2023 at 4:29:57 PM UTC+5:30 Brian Candler wrote: >> >>> 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/a9623b82-33d1-4f99-b77b-b12344c4259an%40googlegroups.com.
