DBParameterGroup

The DBParameterGroup resource lets you manage AWS RDS DBParameterGroups and their configuration settings. This resource allows you to define database engine-specific parameters that control the behavior of your RDS instances.

Minimal Example

Create a basic DBParameterGroup with required properties and one optional property.

import AWS from "alchemy/aws/control";

const dbParameterGroup = await AWS.RDS.DBParameterGroup("myDbParameterGroup", {
  DBParameterGroupName: "custom-db-parameters",
  Description: "Custom parameter group for my database",
  Family: "mysql8.0"
});

Advanced Configuration

Configure a DBParameterGroup with custom parameters for performance tuning.

const advancedDbParameterGroup = await AWS.RDS.DBParameterGroup("advancedDbParameterGroup", {
  DBParameterGroupName: "high-performance-parameters",
  Description: "High performance parameter group for optimized settings",
  Family: "postgres12",
  Parameters: {
    "max_connections": "200",
    "work_mem": "64MB",
    "shared_buffers": "512MB"
  }
});

Using Tags for Resource Management

Add tags to your DBParameterGroup for improved resource management.

const taggedDbParameterGroup = await AWS.RDS.DBParameterGroup("taggedDbParameterGroup", {
  DBParameterGroupName: "tagged-db-parameters",
  Description: "DB parameter group with tags",
  Family: "oracle-se2",
  Tags: [
    { Key: "Environment", Value: "Production" },
    { Key: "Project", Value: "DatabaseOptimization" }
  ]
});

Modifying an Existing DBParameterGroup

Adopt an existing parameter group instead of creating a new one.

const existingDbParameterGroup = await AWS.RDS.DBParameterGroup("existingDbParameterGroup", {
  DBParameterGroupName: "existing-db-parameters",
  Description: "Existing parameter group to be adopted",
  Family: "mysql8.0",
  adopt: true
});