Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-11521

Clickhouse as a DataSource

    XMLWordPrintable

Details

    • New Feature
    • Status: Done
    • Medium
    • Resolution: Done
    • None
    • None
    • None
    • 3
    • Yes
    • Yes
    • No
    • [obsolete] Server Features
    • Hide

      The attached file checks MongoDB instances that have no metrics collected by QAN.

       

      • Create two Percona Server for MongoDB instances - one with default configuration (no operationProfiling) and another one with the provided mongod.conf mongod.conf (with operationProfiling enabled).
      • Add both instances as PMM services
      • Pass attached check file(mongodb-clickhouse-qan-enabled.yml) to PMM server via `PERCONA_TEST_CHECKS_FILE` env variable.
      • Run checks
      • The check should produce one alert (for the MongoDB instance that has profiling disabled). If two alerts, give it a few minutes for QAN to start collecting data from the second instance.
      Show
      The attached file checks MongoDB instances that have no metrics collected by QAN.   Create two Percona Server for MongoDB instances - one with default configuration (no operationProfiling) and another one with the provided mongod.conf mongod.conf (with operationProfiling enabled). Add both instances as PMM services Pass attached check file( mongodb-clickhouse-qan-enabled.yml ) to PMM server via `PERCONA_TEST_CHECKS_FILE` env variable. Run checks The check should produce one alert (for the MongoDB instance that has profiling disabled). If two alerts, give it a few minutes for QAN to start collecting data from the second instance.

    Description

      The problem: 

      Some advisors, especially those related to Queries are required data from QAN  stored in Clickhouse. To develop any check related to qan data we need the ability to query data from QAN so we can suggest some "bad query"

       

      Later, these results can be used by QAN to highlight Advisors and pay user attention to the Queries found by advisors (cross-feature promotion)

      UX:

       

      TBD

      Acceptance criteria:

      •  

      Out of scope:  

      • TBD

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. PMM-1024 Slow Query Alerts

          • Medium - Important issues that need attention but do not significantly disrupt the system's core functionality.
          • On Hold

          Activity

            People

              michael.okoko Michael Okoko
              roma.novikov Roma Novikov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist