Emergency

XtraBD monitoring

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • XtraBD monitoring

    Dear all,

    May I know how to config PMM to monitor XtraBD cluster??

    thanks.

  • #2
    You will need to install PMM client on each PXC node following the instructions in this link:
    https://www.percona.com/doc/percona-...install-client

    And then connect the pmm-client to the PMM Server following these instructions:
    https://www.percona.com/doc/percona-...connect-client

    Then finally start data collection with these instructions:
    https://www.percona.com/doc/percona-...#start-collect

    You may also refer to this page to know how to configure MySQL for PMM:
    https://www.percona.com/doc/percona-...onf-mysql.html

    Let us know if you encounter any difficulties setting up PMM Server and PMM client.

    Comment


    • #3
      hi,

      Yes. i can successfully monitor Mysql server. however, when i select those PXC graph in PMM. there is no data shown. May I missed anything in order to monitor those cluster-related metrics?

      Comment


      • #4
        Hi racheung , can you confirm that you have metrics appearing on traditional dashboards, such as MySQL Overview - that you see valid data for your PXC instances? If not, please ensure that the output of
        Code:
        pmm-admin list
        shows the mysql:metrics service in an UP state. Servers are automatically checked for the presence of certain variables, in the case of PXC we check for label_values(mysql_galera_variables_info, wsrep_cluster_name) in Grafana and if it exists we then display in the drop-down list of the two PXC dashboards. Given a PXC server you generally do not have to do anything additional to get the metrics to display.

        Please confirm you're seeing some MySQL dashboards with valid data for your PXC instance and we'll continue from there. Thanks

        Comment


        • #5
          hi Michael,

          Thanks for your update. Below is the pmm-admin list output.

          ----------------- ---------------------- ----------- -------- ----------------------------------------- ------------------------------
          SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
          ----------------- ---------------------- ----------- -------- ----------------------------------------- ------------------------------
          mysql:queries 1.1.1.1 - YES root:***@unix(/var/lib/mysql/mysql.sock) query_source=perfschema, query
          linux:metrics 1.1.1.1 42000 YES -
          mysql:metrics 1.1.1.1 42002 YES root:***@unix(/var/lib/mysql/mysql.sock)
          proxysql:metrics 1.1.1.1 42004 YES stats:***@tcp(localhost:6032)

          However, i have no idea on how to check the Lable_values. Can you let me know how to check it?

          Regards,

          Comment


          • #6
            Hi racheung , ok this is good news that mysql:metrics is showing in running state. label_values is a Grafana function:
            http://docs.grafana.org/features/dat...query-variable
            This helps us render a list on the PXC Dashboards for instances that are actually PXC nodes. This works based on the presence of a specific variable named wsrep_cluster_name . You can look in PMM for this information in a few of ways:
            1. PXC/Galera Cluster Overview dashboard -> Settings > Templating > $cluster - Edit > Preview of values == is this blank?
            2. PXC/Galera Cluster Overview dashboard -> Edit any graph -> Metric lookup -- start typing wsrep_cluster_
            3. <pmm-server>:9090/graph - start typing "wsrep" and you should see several options appear
            The first operation above validates whether Grafana knows of the instances at all or not.
            The second and third help us explore the data in Prometheus to see if we are collecting wsrep information.

            Please let me know if any of this information exists, and we'll take it further. I'm sorry I haven't been able to give you a full start-to-finish explanation already, this is the first time I've seen a mysqld_exporter work only partially so I am hoping to diagnose this more fully and incorporate our findings into the product. Thanks for your patience!

            Comment


            • #7
              Hi Michael,

              Seem no value from the metrics. Attached please find the screenshots.

              Regards,
              racheung

              Comment


              • #8
                Hi,

                Does it mean Grafana not able to detect the instances?

                Regards,

                Comment

                Working...
                X