DBParameterGroup

Source: src/AWS/RDS/DBParameterGroup.ts

An RDS DB parameter group — instance-level engine settings, applied to a DBInstance (as opposed to the cluster-wide DBClusterParameterGroup).

Name, family, and description changes force a replacement (RDS has no modify API for these); parameters and tags update in place.

Creating a Parameter Group

Parameter Group for Aurora Postgres 16 Instances

const instanceParams = yield* DBParameterGroup("InstanceParams", {
  family: "aurora-postgresql16",
  description: "Instance-level settings for the app database",
});

Set Engine Parameters

const params = yield* DBParameterGroup("MysqlParams", {
  family: "mysql8.4",
  parameters: {
    time_zone: "Australia/Sydney",
    max_connections: "200",
  },
});

Dynamic parameters apply immediately, static ones on the next reboot. Cluster-wide settings belong on DBClusterParameterGroup instead — Postgres timezone, for example, is a cluster parameter on Aurora.

Attach to an Instance

const writer = yield* DBInstance("Writer", {
  dbClusterIdentifier: cluster.dbClusterIdentifier,
  dbInstanceClass: "db.serverless",
  engine: "aurora-postgresql",
  dbParameterGroupName: instanceParams.dbParameterGroupName,
});