Creating Parameter Groups with the Amazon CLI

You can create custom parameter groups using the Amazon CLI to configure your InfluxDB 3 clusters. The following examples demonstrate how to create parameter groups with commonly modified parameters.

Example: Creating an Enterprise parameter group with custom query settings:

aws timestream-influxdb create-db-parameter-group \
  --name "my-enterprise-pg" \
  --description "Custom Enterprise parameter group" \
  --parameters '{
    "InfluxDBv3Enterprise": {
      "queryFileLimit": 500,
      "queryLogSize": 2000
    }
  }'

Example: Creating a Core parameter group with custom DataFusion threading:

aws timestream-influxdb create-db-parameter-group \
  --name "my-core-pg" \
  --description "Custom Core parameter group" \
  --parameters '{
    "InfluxDBv3Core": {
      "dataFusionNumThreads": 32,
      "queryFileLimit": 600
    }
  }'

Note: After creating a parameter group, you can use it when creating a new DB cluster by specifying --db-parameter-group-identifier, or when updating an existing cluster using the update-db-cluster command. Parameter groups cannot be modified after creation.

Verifying your current running configuration: You can check the effective parameter values on a running cluster by querying the _internal database's nodes table:

SELECT * FROM _internal.nodes

This query returns the active configuration for each node in your cluster, allowing you to verify parameter values before and after applying a new parameter group.