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?