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

      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


      • 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




        Issue Links



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



                Smart Checklist