﻿---
title: Enable logsdb for integrations
description: Enable logsdb index mode for integration data streams using @custom component templates.
url: https://www.elastic.co/elastic/docs-builder/docs/3028/manage-data/data-store/data-streams/logs-data-stream-integrations
products:
  - Elasticsearch
applies_to:
  - Elastic Stack: Generally available since 9.0
---

# Enable logsdb for integrations
This page shows you how to enable logsdb index mode for integration data streams, using `@custom` [component templates](/elastic/docs-builder/docs/3028/manage-data/data-store/templates#component-templates). If your integrations were installed before you upgraded to Elastic Stack 9.x, you need to manually enable logsdb mode.
<admonition title="Why isn't logsdb enabled automatically for integrations when upgrading?">
  Although logsdb significantly reduces storage costs, it can increase ingestion overhead slightly. On clusters that are already near capacity, enabling logsdb on many data streams at once can impact stability. For this reason, the 8.x to 9.x upgrade process does not automatically apply logsdb mode to existing integration data streams.
</admonition>

Logsdb index mode is automatically applied to _new_ integration data streams in Elastic Stack 9.0+. For more details, refer to [Availability of logsdb index mode](/elastic/docs-builder/docs/3028/manage-data/data-store/data-streams/logs-data-stream#logsdb-availability).
The steps on this page work in Elastic Cloud Serverless, but you typically won't need to enable logsdb manually in Serverless.

## Before you begin

To work with integration data streams, you need some details from the package manifest. Find your integration in the [Elastic integrations repository](https://github.com/elastic/integrations/tree/main/packages) or query the [Elastic Package Registry](https://github.com/elastic/package-registry) and make a note of the following:
- **Package name:** The exact name in the package manifest. For example, the MySQL integration package is named `mysql`.
- **Logs dataset names:** Make sure the integration has data streams where the `type` is `logs`. For example, the MySQL integration has `mysql.error` and `mysql.slowlog`. Note the name of each logs dataset for use in later steps.
  <dropdown title="Elastic Package Registry query (curl)">
  You can use this `curl` command to confirm the integration's logs data streams in the [Elastic Package Registry](https://github.com/elastic/package-registry). Replace `mysql/1.28.1` with your integration package name and version:
  ```bash
  curl -sL epr.elastic.co/package/mysql/1.28.1 | jq '.data_streams[] |
  select(.type == "logs") | {dataset, type}'
  ```

  ```json
  {
  "dataset": "mysql.error",
  "type": "logs"
  }
  {
  "dataset": "mysql.slowlog",
  "type": "logs"
  }
  ```
  </dropdown>


## Enable logsdb

<stepper>
  <step title="Find logs data streams and check index mode">
    1. Go to **Index Management** using the navigation menu or the [global search field](https://www.elastic.co/elastic/docs-builder/docs/3028/explore-analyze/find-and-organize/find-apps-and-objects).
    2. On the **Data Streams** tab, search for the integration name.
    3. Check the **Index mode** column for each logs data stream in the integration.
       If the index mode shows **LogsDB**, logsdb is already enabled and no action is needed. If it shows a different mode like **Standard** or **Time series**, continue to the next step.
  </step>

  <step title="Edit existing component templates">
    Use Kibana to find and edit `@custom` component templates for the integration log datasets:
    1. Go to **Index Management** using the navigation menu or the [global search field](https://www.elastic.co/elastic/docs-builder/docs/3028/explore-analyze/find-and-organize/find-apps-and-objects).
    2. On the **Component Templates** tab, search for `@custom` to check whether templates already exist for the integration's logs datasets.
    3. Edit the existing `@custom` templates that correspond to the log datasets you identified in [Before you begin](#before-you-begin). In the **Index settings** step, add the logsdb mode:
       ```json
        {
          "index": {
            "mode": "logsdb"
          }
        }
       ```
  </step>

  <step title="Create component templates">
    If they don't already exist, create `@custom` component templates for the logs datasets you identified in [Before you begin](#before-you-begin).
    <tab-set>
      <tab-item title="Kibana">
        1. Go to **Index Management** using the navigation menu or the [global search field](https://www.elastic.co/elastic/docs-builder/docs/3028/explore-analyze/find-and-organize/find-apps-and-objects).
        2. On the **Component Templates** tab, click **Create component template** and step through the wizard:
           - In the **Logistics** step, name the template using the pattern `logs-<integration>.<dataset>@custom` (for example, `logs-mysql.error@custom`).
        - In the **Index settings** step, add the logsdb index mode.
        Repeat for each logs dataset in the integration.
      </tab-item>

      <tab-item title="API">
        To create a `@custom` template for a single integration dataset:
        - In an Elastic Stack deployment, use the [component template](https://www.elastic.co/docs/api/doc/elasticsearch/operation/operation-cluster-put-component-template) API.
        - In Elastic Cloud Serverless, use the [component template](https://www.elastic.co/docs/api/doc/elasticsearch-serverless/operation/operation-cluster-put-component-template) API.
        Component template names must use the pattern `logs-<integration>.<dataset>@custom`.Example:
        ```json

        {
          "template": {
            "settings": {
              "index.mode": "logsdb"
            }
          }
        }
        ```
        Repeat for each logs dataset in the integration.
      </tab-item>

      <tab-item title="API (all datasets)">
        <warning>
          This `curl` command uses `PUT`, which **overwrites** any existing component templates. Before using this command, confirm that no `@custom` templates exist for your integration.Make sure to consider your cluster's resource usage before enabling logsdb on many data streams at once. On clusters that are already near capacity, this action could impact stability.
        </warning>
        To create `@custom` component templates for all logs data streams in an integration at once, run this command in a terminal window:
        ```bash
        curl -sL epr.elastic.co/package/mysql/1.28.1 | jq -r '.data_streams[] |
        select(.type == "logs") | .dataset' | xargs -I% curl -s -XPUT \
        -H'Authorization: ApiKey <API_KEY>' -H'Content-Type: application/json' \
        '<ES_URL>/_component_template/logs-%@custom' \
        -d'{"template": {"settings": {"index.mode": "logsdb"}}}'
        ```
        Replace `<API_KEY>` with your API key, `<ES_URL>` with your Elasticsearch endpoint, and `mysql/1.28.1` with your integration package name and version.
      </tab-item>
    </tab-set>
  </step>

  <step title="Verify logsdb mode">
    Changes are applied to existing data streams on [rollover](/elastic/docs-builder/docs/3028/manage-data/data-store/data-streams#data-streams-rollover). Data streams roll over automatically based on your index lifecycle policy, or you can [trigger a rollover manually](/elastic/docs-builder/docs/3028/manage-data/data-store/data-streams/use-data-stream#manually-roll-over-a-data-stream).After your data streams roll over, repeat the check in [step 1](#find-logs-data-streams-and-check-index-mode) to make sure the index mode is set to logsdb. If not, make sure the data stream has rolled over since you created or updated the corresponding template.
  </step>
</stepper>


## Enable logsdb cluster-wide (optional)

You can also enable logsdb for all logs data streams cluster-wide (not just specific integrations). To do so, create or update the `logs@custom` component template. For details about component templates and template composition, refer to [Component templates](/elastic/docs-builder/docs/3028/manage-data/data-store/templates#component-templates).
<important>
  If your cluster is already near capacity, stability issues can occur if you enable logsdb on many data streams at once. Make sure to check your cluster's resource usage before editing `logs@custom`.
</important>


## Next steps

- Review the documentation for [Logs data streams](https://www.elastic.co/elastic/docs-builder/docs/3028/manage-data/data-store/data-streams/logs-data-stream), [Templates](https://www.elastic.co/elastic/docs-builder/docs/3028/manage-data/data-store/templates), and the [Default logs index template](https://www.elastic.co/elastic/docs-builder/docs/3028/solutions/observability/logs/logs-index-template-defaults)
- [Configure a logs data stream](https://www.elastic.co/elastic/docs-builder/docs/3028/manage-data/data-store/data-streams/logs-data-stream-configure)
- [Advanced data source configuration for Elastic Security rules](https://www.elastic.co/elastic/docs-builder/docs/3028/solutions/security/detect-and-alert/advanced-data-source-configuration)