Skip to main content

Databases & Analytics - How to set up logs forwarding

Stephanie R.
Updated

Learn how to forward service logs to your own Logs Data Platform stream with the OVHcloud API.

Cloud Databases and Analytics allow you to send logs of your service to your own Logs Data Platform (LDP) data stream.

 

Requirements

  • Access to the OVHcloud Control Panel and OVHcloud API

  • A Cloud Database service up and running

    We will use Valkey as the example in this guide.

  • A Logs Data Platform account within this OVHcloud account with at least one destination stream configured

    NOTE: If you are not familiar with all the LDP Stream configuration possibilities, create a new one with the default options (indexing and websocket enabled, long-term storage disabled) for this guide.

 

Instructions

Create your subscription

Logs direct access

From the OVHcloud Control Panel, navigate to your engine via the Public Cloud and Databases (or Data Analysis) menus.

Once there, click the Logs tab.

manager_database_logsTab.png

 

Logs access through LDP

From the Logs tab, you can Subscribe to an LDP data stream. Once the subscription is enabled, all the logs will be pushed to Logs Data Platform to archive generated logs and perform advanced searches, and create alerts or visualizations.

For more information, please refer to our Quick Start for Logs Data Platform guide.

manager_database_logsTab_subscribe.png

Retrieve the required information

Retrieve your LDP destination streamId:

  • In the OVHcloud Control Panel, go to the Logs Data Platform section and select your service.
  • Go to the Data stream tab.
  • Choose your target stream, select the more options... button, and then Copy stream ID.
manager_ldp_datastreamTab_moreOptions.png

Retrieve your LDP destination serviceName:

  • This is your Public Cloud project ID.

Retrieve your clusterId:

Retrieve the available kind values for your service:

 

Use the following API call:

POST /cloud/project/{serviceName}/database/{engine}/{clusterId}/log/subscription

Request Body: 

{
  kind: "string",
  streamId: <LDP destination stream ID>
}

 

Find logs in Graylog

To find logs of your service in your Graylog stream, you can use the following Graylog queries:

MongoDB®

Query: cluster: "<HostID>"

You can find this HostID in your manager:

  • In Login information switch the Service to mongodb
  • Now you can see the Host field with the format <HostID>.database.cloud.ovh.us

 

Other Engines

Query: clusterID: "<Engine>-<HostID>"

You can find this HostID in your manager:

  • Find the Cluster ID formatted as a UUID (AAAAAAAA-BBBB-CCCC-DDDDDDDDDDDD)
  • HostID is the first part of the UUID (AAAAAAAA)

 

Delete your subscription

Method 1: Unsubscribe

From the OVHcloud Control Panel, navigate to your engine and select the Logs tab.

Click Unsubscribe.

manager_database_logsTab_unsubscribe.png

 

Method 2: Cancel the database service

If you delete your database service, all subscriptions of this service are deleted automatically.

For instructions to cancel a Database or Analytics service, see our Databases & Analytics - FAQ guide.

Method 1: Unsubscribe

You can delete subscriptions using the subscriptionId concerned in this API call:

DELETE /cloud/project/{serviceName}/database/{engine}/{clusterId}/log/subscription/{subscriptionId}

 

Method 2: Cancel the database service

If you delete your database service, all subscriptions of this service are deleted automatically.

DELETE /cloud/project/{serviceName}/database/{engine}/{clusterId}

 

Go further

For more information and tutorials, please see our other Managed Databases & Analytics or Platform as a Service guides. You can also explore the guides for other OVHcloud products and services.

If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

OVHcloud Managed Databases and Analytics:

  • Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs.
  • Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation.
  • MongoDB® is a registered trademark of MongoDB, Inc.
  • MySQL® is a registered trademark of Oracle and/or its affiliates.
  • PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.

Related articles