Not the answer you need?
Register and ask your own question!

XtraBD monitoring

Dear all,

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

thanks.

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    You will need to install PMM client on each PXC node following the instructions in this link:
    https://www.percona.com/doc/percona-monitoring-and-management/deploy/client/index.html#install-client

    And then connect the pmm-client to the PMM Server following these instructions:
    https://www.percona.com/doc/percona-monitoring-and-management/deploy/connect-client.html#connect-client

    Then finally start data collection with these instructions:
    https://www.percona.com/doc/percona-monitoring-and-management/deploy/start-collect.html#start-collect

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

    Let us know if you encounter any difficulties setting up PMM Server and PMM client.
  • racheungracheung Entrant Current User Role Beginner
    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?
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    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
    pmm-admin list
    
    shows the 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
  • racheungracheung Entrant Current User Role Beginner
    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,
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi racheung , ok this is good news that is showing in running state. label_values is a Grafana function:
    http://docs.grafana.org/features/datasources/prometheus/#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!
  • racheungracheung Entrant Current User Role Beginner
    Hi Michael,

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

    Regards,
    racheung
  • racheungracheung Entrant Current User Role Beginner
    Hi,

    Does it mean Grafana not able to detect the instances?

    Regards,
  • novidnovid Entrant Inactive User Role Beginner
    I've had this problem too... Is there any solution to fix this problem?
  • novidnovid Entrant Inactive User Role Beginner
    I've had this problem too.. Is there any solution to fix it?
  • novidnovid Entrant Inactive User Role Beginner
    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
    pmm-admin list
    
    shows the 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


    Why this variable is empty at Grafana?



    Prometheus does not have any mysql_galera_variables_info parameter.
  • novidnovid Entrant Inactive User Role Beginner
    I think the problem is that mysqld_exporter to get wsrep_cluster_name, uses show global VARIABLES but in my case, I get error from this command.

    [HTML]mysql> show global VARIABLES ;
    ERROR 1682 (HY000): Native table 'performance_schema'.'global_variables' has the wrong structure[/HTML]

    So I must fix this problem and then try again.
  • odenoden Entrant Inactive User Role Beginner
    mee too(tm)

    Hi,

    I'm quite new to PMM and have configured monitoring for a 3 node Percona 5.7 cluster (with vertical replicas) but can't see any galera graphs at all.
  • novidnovid Entrant Inactive User Role Beginner
    oden wrote: »
    mee too(tm)

    Hi,

    I'm quite new to PMM and have configured monitoring for a 3 node Percona 5.7 cluster (with vertical replicas) but can't see any galera graphs at all.

    Can you see output of show global VARIABLES inside mysql?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.