RDS Aurora

import { RdsAurora } from "@fjall/components-infrastructure/lib/resources/aws/database/rdsAurora";

const database = new RdsAurora(this, "MyDatabase", {
  vpc: myVpc,
  databaseName: "myapp",
});

const database = new RdsAurora(this, "RestoredCluster", {
  vpc: myVpc,
  databaseName: "restored",
  snapshotIdentifier: "rds:my-aurora-cluster-snapshot",
  snapshotUsername: "postgres",
});

// Deployed in private subnets by default
const database = new RdsAurora(this, "Database", {
  vpc: vpc,
  databaseName: "secure",
});

// Allow access from application
application.connections.allowTo(
  database,
  Port.tcp(35255),
  "Application to database",
);

const database = new RdsAurora(this, "Database", {
  vpc: vpc,
  databaseName: "myapp",
});

// Access credentials
const credentials = database.getCredentials();
const endpoint = database.getHostEndpoint();
const port = database.getHostPort();

// Creates 1 reader that scales with the writer
const database = new RdsAurora(this, "Database", {
  vpc: vpc,
  databaseName: "myapp",
});

const database = new RdsAurora(this, "ScaledDatabase", {
  vpc: vpc,
  databaseName: "scaled",
  readers: {
    count: 3,
  },
});

const database = new RdsAurora(this, "WriterOnly", {
  vpc: vpc,
  databaseName: "writeronly",
  readers: false,
});

const database = new RdsAurora(this, "ProxiedDatabase", {
  vpc: vpc,
  databaseName: "proxied",
  proxy: {
    requireTLS: true,
    connectionBorrowTimeout: 120,
    maxConnections: 80,
    maxIdleConnections: 50,
  },
});

// When proxy is enabled, getHostEndpoint() returns the proxy endpoint
const endpoint = database.getHostEndpoint();

const database = new RdsAurora(this, "BackupDatabase", {
  vpc: vpc,
  databaseName: "backup",
  backupRetention: 30,
});

const database = new RdsAurora(this, "MonitoredDatabase", {
  vpc: vpc,
  databaseName: "monitored",
  monitoringInterval: Duration.seconds(10),
});

const endpoint = database.getHostEndpoint();
// Returns: Proxy endpoint if proxy enabled, otherwise cluster endpoint

const port = database.getHostPort();
// Returns: "35255" (default, as string)

const credentials = database.getCredentials();
// Returns: Secret object containing username/password

const connections = database.connections;
// Use for network access control

const cluster = database.getDatabaseCluster();
// Returns: DatabaseCluster (CDK construct)

const cfnCluster = database.getCfnCluster();
// Returns: CfnDBCluster | undefined

import { RdsAurora } from "@fjall/components-infrastructure/lib/resources/aws/database/rdsAurora";
import { Duration } from "aws-cdk-lib";
import { Vpc, Port } from "aws-cdk-lib/aws-ec2";
import { CfnOutput } from "aws-cdk-lib";

// Create VPC
const vpc = new Vpc(this, "AppVpc", {
  maxAzs: 3,
  natGateways: 1,
});

// Create database with proxy
const database = new RdsAurora(this, "ProductionDatabase", {
  vpc: vpc,
  databaseName: "production",
  clusterIdentifier: "prod-cluster",

  // Backup
  backupRetention: 35,

  // Maintenance
  preferredMaintenanceWindow: "Sun:03:00-Sun:04:00",

  // Monitoring
  monitoringInterval: Duration.seconds(10),

  // Enable proxy for connection pooling
  proxy: {
    requireTLS: true,
  },

  // Reader configuration
  readers: {
    count: 2,
  },
});

// Allow connection from application
app.connections.allowTo(database, Port.tcp(35255), "Application to database");

// Output endpoint
new CfnOutput(this, "DatabaseEndpoint", {
  value: database.getHostEndpoint(),
  description: "Database endpoint (proxy if enabled)",
});