Configure Monitoring with New Relic

You can monitor your SingleStore Helios workspaces using New Relic via the OpenTelemetry Collector. To visualize the SingleStore Prometheus metrics, use the Prometheus receiver and send metrics data to New Relic.

Prerequisites

  • A Kubernetes cluster and the kubectl command-line tool.

  • A New Relic account and a license key used for data ingest.

  • An active SingleStore Helios deployment.

  • A SingleStore API key.

Configure OpenTelemetry and New Relic

To ingest the SingleStore Prometheus metrics into New Relic using OpenTelemetry,

  1. Clone the New Relic OpenTelemetry Examples GitHub repository.

  2. Change directory to the newrelic-opentelemetry-examples/other-examples/collector/singlestore/k8s/ directory.

  3. Update the New Relic API (license) key and SingleStore API key values in the secrets.yaml file.

    stringData:
      NEW_RELIC_API_KEY: <New_Relic_api_key>
      SINGLESTORE_API_KEY: <SingleStore_api_key>
  4. Update the SingleStore organization ID and workspace group ID in the collector.yaml file. To find these IDs, navigate to your SingleStore workspace group on the Cloud Portal. In the URL,

    • The alphanumeric values next to /organizations/ is the organization ID.

    • The alphanumeric values next to /workspaces/ is the workspace group ID.

    - name: SINGLESTORE_ORG_ID
      value: <SingleStore_organization_ID>
    - name: SINGLESTORE_WORKSPACE_GROUP_ID
      value: <SingleStore_workspace_group_ID>
  5. Run the application using the following command:

    kubectl apply -f k8s/

To reset the configuration or clean resources, run the following command:

kubectl delete -f k8s/

View the Metrics

To view the SingleStore metrics, query the New Relic data:

FROM Metric SELECT uniques(metricName) WHERE otel.library.name = 'otelcol/prometheusreceiver' AND metricName LIKE 'singlestore%'

Refer to How to query your New Relic data for more information.

To view the SingleStore dashboard,

  1. Go to one.newrelic.com, and select Integrations & Agents on the left navigation pane.

  2. On the Integrations & Agents page, search SingleStore, and select SingleStore OpenTelemetry.

  3. On the Installation plan dialog,

    1. Select an account.

    2. Configure OpenTelemetry and New Relic and select Done. Skip this step if the integration is already configured.

    3. Select See your data.

The SingleStore dashboard opens.

References

Last modified: January 9, 2025

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined
  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined
  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
    --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
    --bundle undefined \
    --new-bundle-format -
    Verified OK