Details

    Description

      User story:

      • When I need to add Azure related DB for the monitoring I need to be able to enter Azure related credentials in PMM UI (add Instance) So I can see the list of all DB existed in the Azure account and processed with Adding them to PMM for monitoring

      UI/UX:
      TBD
      something related to :

      Acceptance criteria

      • User can enter credentials: AZURE_CLIENT_ID, AZURE_CLIENT_SECRET, AZURE_TENANT_ID, AZURE_SUBSCRIPTION_ID click discovery and see the list of DB services possible monitor by PMM
      • List of DBs should contain: Name, DomainName, resourceGroup, Type, Version, Location (port is unavailable - check if standard port works)
      • The user is able to select a DB from the list and proceed to a screen to fill more details to start to monitor it by PMM.
      • On the screen of Add remote MySQL (PostgreSQL/MariaDB) Instance, the user can see and edit the next fields (filled in or empty):
        • DomainName - filled in
        • Service Name - default DomainName
        • Port - default for DB type: 3306, 5432 - check if it works - ports does not return with selected resource discovery
        • user - filled in by concatenating "<administratorLogin>@<name>"
        • Password - empty
        • Labels
          • Region - repopulated by location
          • Environment - filled in by tags.environment
          • Do we need fill in any other labels?
          • Custom labels empty
        • Additional option - need additional investigation 
      • User able to do all operations using Azure and PMM UI only
      • The Discovery process works for:
        • Azure Database for PostgreSQL
        • Azure Database for MySQL
        • Azure Database for MariaDB  - need an additional investigation - as it stays separate from "standard" Azure DB - and its cost does not encourage to do many experiments. 

      Here is a screenshot of adding Azure Monitor as a datasource

      Also Resource group is required.
      It's not clear if it has to be discovered automatically or added as new instance each time with whole list of *ids.

      Out of scope:

      • any Azure SQL related discovery

      Suggested implementation:

      •  TBD

      Risks:

      • Discovery and monitoring of MariaDB
      • How to form DSN
      • TLS
      • **

      How to test:

      1. Create DB on Azure
      2. Genarates credentials.
      3. Discover from grafana
      4. Add to monitor
      5. See matrics on garafana dashboard.

      More detailed TBD

       TBD

      Details:

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              andrii.skomorokhov Andrii Skomorokhov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist