1. Docs
  2. @pulumi/awsx
  3. classic
  4. rds

Module classic/rds

    APIs

    APIs

    namespace metrics

    function activeTransactions

    activeTransactions(change?: RdsMetricChange): Metric

    The average number of current transactions executing on an Aurora database instance per second. By default, Aurora doesn’t enable this metric. To begin measuring this value, set innodb_monitor_enable=‘all’ in the DB parameter group for a specific DB instance.

    Applies to: Aurora MySQL

    function auroraBinlogReplicaLag

    auroraBinlogReplicaLag(change?: RdsMetricChange): Metric

    The amount of time a replica DB cluster running on Aurora with MySQL compatibility lags behind the source DB cluster. This metric reports the value of the Seconds_Behind_Master field of the MySQL SHOW SLAVE STATUS command. This metric is useful for monitoring replica lag between Aurora DB clusters that are replicating across different AWS Regions. For more information, see Aurora MySQL Replication.

    Applies to: Aurora MySQL

    function auroraGlobalDBDataTransferBytes

    auroraGlobalDBDataTransferBytes(change?: RdsMetricChange): Metric

    Units: Bytes

    Applies to: Aurora MySQL

    function auroraGlobalDBReplicatedWriteIO

    auroraGlobalDBReplicatedWriteIO(change?: RdsMetricChange): Metric

    Units: Bytes

    Applies to: Aurora MySQL

    function auroraGlobalDBReplicationLag

    auroraGlobalDBReplicationLag(change?: RdsMetricChange): Metric

    Units: Milliseconds

    Applies to: Aurora MySQL

    function auroraReplicaLag

    auroraReplicaLag(change?: RdsMetricChange): Metric

    For an Aurora Replica, the amount of lag when replicating updates from the primary instance, in milliseconds.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function auroraReplicaLagMaximum

    auroraReplicaLagMaximum(change?: RdsMetricChange): Metric

    The maximum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function auroraReplicaLagMinimum

    auroraReplicaLagMinimum(change?: RdsMetricChange): Metric

    The minimum amount of lag between the primary instance and each Aurora DB instance in the DB cluster, in milliseconds.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function backtrackChangeRecordsCreationRate

    backtrackChangeRecordsCreationRate(change?: RdsMetricChange): Metric

    The number of backtrack change records created over five minutes for your DB cluster.

    Applies to: Aurora MySQL

    function backtrackChangeRecordsStored

    backtrackChangeRecordsStored(change?: RdsMetricChange): Metric

    The actual number of backtrack change records used by your DB cluster.

    Applies to: Aurora MySQL

    function backtrackWindowActual

    backtrackWindowActual(change?: RdsMetricChange): Metric

    The difference between the target backtrack window and the actual backtrack window.

    Applies to: Aurora MySQL

    function backtrackWindowAlert

    backtrackWindowAlert(change?: RdsMetricChange): Metric

    The number of times that the actual backtrack window is smaller than the target backtrack window for a given period of time.

    Applies to: Aurora MySQL

    function backupRetentionPeriodStorageUsed

    backupRetentionPeriodStorageUsed(change?: RdsMetricChange): Metric

    The total amount of backup storage in GiB used to support the point-in-time restore feature within the Aurora DB cluster’s backup retention window. Included in the total reported by the TotalBackupStorageBilled metric. Computed separately for each Aurora cluster. For instructions, see Understanding Aurora Backup Storage Usage. Units: Gibibytes (GiB)

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function binLogDiskUsage

    binLogDiskUsage(change?: RdsMetricChange): Metric

    The amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas.

    Units: Bytes

    function blockedTransactions

    blockedTransactions(change?: RdsMetricChange): Metric

    The average number of transactions in the database that are blocked per second.

    Applies to: Aurora MySQL

    function bufferCacheHitRatio

    bufferCacheHitRatio(change?: RdsMetricChange): Metric

    The percentage of requests that are served by the buffer cache.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function burstBalance

    burstBalance(change?: RdsMetricChange): Metric

    The percent of General Purpose SSD (gp2) burst-bucket I/O credits available.

    Units: Percent

    function commitLatency

    commitLatency(change?: RdsMetricChange): Metric

    The amount of latency for commit operations, in milliseconds.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function commitThroughput

    commitThroughput(change?: RdsMetricChange): Metric

    The average number of commit operations per second.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function cpuCreditBalance

    cpuCreditBalance(change?: RdsMetricChange): Metric

    [T2 instances] The number of earned CPU credits that an instance has accrued since it was launched or started. For T2 Standard, the CPUCreditBalance also includes the number of launch credits that have been accrued.

    Credits are accrued in the credit balance after they are earned, and removed from the credit balance when they are spent. The credit balance has a maximum limit, determined by the instance size. Once the limit is reached, any new credits that are earned are discarded. For T2 Standard, launch credits do not count towards the limit.

    The credits in the CPUCreditBalance are available for the instance to spend to burst beyond its baseline CPU utilization.

    When an instance is running, credits in the CPUCreditBalance do not expire. When the instance stops, the CPUCreditBalance does not persist, and all accrued credits are lost.

    CPU credit metrics are available at a five-minute frequency only.

    function cpuCreditUsage

    cpuCreditUsage(change?: RdsMetricChange): Metric

    [T2 instances] The number of CPU credits spent by the instance for CPU utilization. One CPU credit equals one vCPU running at 100% utilization for one minute or an equivalent combination of vCPUs, utilization, and time (for example, one vCPU running at 50% utilization for two minutes or two vCPUs running at 25% utilization for two minutes).

    CPU credit metrics are available at a five-minute frequency only. If you specify a period greater than five minutes, use the Sum statistic instead of the Average statistic.

    function cpuUtilization

    cpuUtilization(change?: RdsMetricChange): Metric

    The percentage of CPU utilization.

    Units: Percent

    function databaseConnections

    databaseConnections(change?: RdsMetricChange): Metric

    The number of database connections in use.

    Units: Count

    function ddlLatency

    ddlLatency(change?: RdsMetricChange): Metric

    The amount of latency for data definition language (DDL) requests, in milliseconds—for example, create, alter, and drop requests.

    Applies to: Aurora MySQL

    function ddlThroughput

    ddlThroughput(change?: RdsMetricChange): Metric

    The average number of DDL requests per second.

    Applies to: Aurora MySQL

    function deadlocks

    deadlocks(change?: RdsMetricChange): Metric

    The average number of deadlocks in the database per second.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function deleteLatency

    deleteLatency(change?: RdsMetricChange): Metric

    The amount of latency for delete queries, in milliseconds.

    Applies to: Aurora MySQL

    function deleteThroughput

    deleteThroughput(change?: RdsMetricChange): Metric

    The average number of delete queries per second.

    Applies to: Aurora MySQL

    function diskQueueDepth

    diskQueueDepth(change?: RdsMetricChange): Metric

    The number of outstanding IOs (read/write requests) waiting to access the disk.

    Units: Count

    function dmlLatency

    dmlLatency(change?: RdsMetricChange): Metric

    The amount of latency for inserts, updates, and deletes, in milliseconds.

    Applies to: Aurora MySQL

    function dmlThroughput

    dmlThroughput(change?: RdsMetricChange): Metric

    The average number of inserts, updates, and deletes per second.

    Applies to: Aurora MySQL

    function engineUptime

    engineUptime(change?: RdsMetricChange): Metric

    The amount of time that the instance has been running, in seconds.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function failedSQLServerAgentJobsCount

    failedSQLServerAgentJobsCount(change?: RdsMetricChange): Metric

    The number of failed SQL Server Agent jobs during the last minute.

    Unit: Count/Minute

    function freeableMemory

    freeableMemory(change?: RdsMetricChange): Metric

    The amount of available random access memory.

    Units: Bytes

    function freeLocalStorage

    freeLocalStorage(change?: RdsMetricChange): Metric

    The amount of storage available for temporary tables and logs, in bytes. Unlike for other DB engines, for Aurora DB instances this metric reports the amount of storage available to each DB instance for temporary tables and logs. This value depends on the DB instance class (for pricing information, see the Amazon RDS product page). You can increase the amount of free storage space for an instance by choosing a larger DB instance class for your instance.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function freeStorageSpace

    freeStorageSpace(change?: RdsMetricChange): Metric

    The amount of available storage space.

    Units: Bytes

    function insertLatency

    insertLatency(change?: RdsMetricChange): Metric

    The amount of latency for insert queries, in milliseconds.

    Applies to: Aurora MySQL

    function insertThroughput

    insertThroughput(change?: RdsMetricChange): Metric

    The average number of insert queries per second.

    Applies to: Aurora MySQL

    function loginFailures

    loginFailures(change?: RdsMetricChange): Metric

    The average number of failed login attempts per second.

    Applies to: Aurora MySQL

    function maximumUsedTransactionIDs

    maximumUsedTransactionIDs(change?: RdsMetricChange): Metric

    The maximum transaction ID that has been used. Applies to PostgreSQL.

    Units: Count

    function metric

    metric(metricName: RdsMetricName, change: RdsMetricChange): Metric

    Creates an AWS/RDS metric with the requested [metricName]. See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MonitoringOverview.html#monitoring-cloudwatch for list of all metric-names.

    Note, individual metrics can easily be obtained without supplying the name using the other [metricXXX] functions.

    You can monitor DB instances using Amazon CloudWatch, which collects and processes raw data from Amazon RDS into readable, near real-time metrics. These statistics are recorded for a period of two weeks, so that you can access historical information and gain a better perspective on how your web application or service is performing. By default, Amazon RDS metric data is automatically sent to CloudWatch in 1-minute periods.

    Amazon RDS metrics data can be filtered by using any of the following dimensions:

    1. “DBInstanceIdentifier”: This dimension filters the data you request for a specific database instance.
    2. “DBClusterIdentifier”: This dimension filters the data you request for a specific Amazon Aurora DB cluster.
    3. “DBClusterIdentifier, Role”: This dimension filters the data you request for a specific Aurora DB cluster, aggregating the metric by instance role (WRITER/READER). For example, you can aggregate metrics for all READER instances that belong to a cluster.
    4. “DatabaseClass”: This dimension filters the data you request for all instances in a database class. For example, you can aggregate metrics for all instances that belong to the database class db.m1.small
    5. “EngineName”: This dimension filters the data you request for the identified engine name only. For example, you can aggregate metrics for all instances that have the engine name mysql.
    6. “SourceRegion”: This dimension filters the data you request for the specified region only. For example, you can aggregate metrics for all instances in the region us-east-1.

    function networkReceiveThroughput

    networkReceiveThroughput(change?: RdsMetricChange): Metric

    The incoming (Receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.

    Units: Bytes/Second

    function networkThroughput

    networkThroughput(change?: RdsMetricChange): Metric

    The amount of network throughput both received from and transmitted to clients by each instance in the Aurora MySQL DB cluster, in bytes per second. This throughput doesn’t include network traffic between instances in the DB cluster and the cluster volume.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function networkTransmitThroughput

    networkTransmitThroughput(change?: RdsMetricChange): Metric

    The outgoing (Transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication.

    Units: Bytes/Second

    function oldestReplicationSlotLag

    oldestReplicationSlotLag(change?: RdsMetricChange): Metric

    The lagging size of the replica lagging the most in terms of WAL data received. Applies to PostgreSQL.

    Units: Megabytes

    function queries

    queries(change?: RdsMetricChange): Metric

    The average number of queries executed per second.

    Applies to: Aurora MySQL

    interface RdsMetricChange

    interface RdsMetricChange extends MetricChange

    property cluster

    cluster?: aws.rds.Cluster;

    Optional [Cluster] to filter down events to.

    property color

    color?: pulumi.Input<string>;

    The six-digit HTML hex color code to be used for this metric.

    Only used if this metric is displayed in a [Dashboard] with a [MetricWidget].

    property databaseClass

    databaseClass?: undefined | string;

    This dimension filters the data you request for all instances in a database class. For example, you can aggregate metrics for all instances that belong to the database class [db.m1.small].

    property dimensions

    dimensions?: pulumi.Input<Record<string, pulumi.Input<string>>>;

    The new dimension for this metric. If this object is missing this property, then no change will be made. However, if the property is there by set to [undefined] then the value will be cleared.

    property engineName

    engineName?: undefined | string;

    This dimension filters the data you request for the identified engine name only. For example, you can aggregate metrics for all instances that have the engine name [mysql].

    property extendedStatistic

    extendedStatistic?: pulumi.Input<number>;

    The new percentile statistic for the metric associated with the alarm. If this object is missing this property, then no change will be made. However, if the property is there by set to [undefined] then the value will be set to the default.

    property instance

    instance?: aws.rds.Instance;

    Optional [Instance] to filter down events to.

    property label

    label?: pulumi.Input<string>;

    The label to display for this metric in the graph legend. If this is not specified, the metric is given an autogenerated label that distinguishes it from the other metrics in the widget.

    Only used if this metric is displayed in a [Dashboard] with a [MetricWidget].

    property period

    period?: pulumi.Input<number>;

    The new period in seconds over which the specified stat is applied. If this object is missing this property, then no change will be made. However, if the property is there by set to [undefined] then the value will be set to the default (300s).

    property role

    role?: "WRITER" | "READER";

    This dimension filters the data you request for a specific Aurora DB cluster, aggregating the metric by instance role (WRITER/READER). For example, you can aggregate metrics for all READER instances that belong to a cluster.

    If this is provided then [cluster] must be provided as well.

    property sourceRegion

    sourceRegion?: aws.Region;

    This dimension filters the data you request for the specified region only. For example, you can aggregate metrics for all instances in the region [us-east-1].

    property statistic

    statistic?: pulumi.Input<MetricStatistic>;

    The new statistic to apply to the alarm’s associated metric. If this object is missing this property, then no change will be made. However, if the property is there by set to [undefined] then the value will be set to the default.

    property unit

    unit?: pulumi.Input<MetricUnit>;

    The new unit for this metric. If this object is missing this property, then no change will be made. However, if the property is there by set to [undefined] then the value will be set to the default.

    property visible

    visible?: pulumi.Input<boolean>;

    Set this to true to have the metric appear in the graph, or false to have it be hidden. The default is true.

    Only used if this metric is displayed in a [Dashboard] with a [MetricWidget].

    property yAxis

    yAxis?: pulumi.Input<"left" | "right">;

    Where on the graph to display the y-axis for this metric. The default is left.

    Only used if this metric is displayed in a [Dashboard] with a [MetricWidget].

    type RdsMetricName

    type RdsMetricName = "BinLogDiskUsage" | "BurstBalance" | "CPUUtilization" | "CPUCreditUsage" | "CPUCreditBalance" | "DatabaseConnections" | "DiskQueueDepth" | "FailedSQLServerAgentJobsCount" | "FreeableMemory" | "FreeStorageSpace" | "MaximumUsedTransactionIDs" | "NetworkReceiveThroughput" | "NetworkTransmitThroughput" | "OldestReplicationSlotLag" | "ReadIOPS" | "ReadLatency" | "ReadThroughput" | "ReplicaLag" | "ReplicationSlotDiskUsage" | "SwapUsage" | "TransactionLogsDiskUsage" | "TransactionLogsGeneration" | "WriteIOPS" | "WriteLatency" | "WriteThroughput" | "ActiveTransactions" | "AuroraBinlogReplicaLag" | "AuroraGlobalDBReplicatedWriteIO" | "AuroraGlobalDBDataTransferBytes" | "AuroraGlobalDBReplicationLag" | "AuroraReplicaLag" | "AuroraReplicaLagMaximum" | "AuroraReplicaLagMinimum" | "BacktrackChangeRecordsCreationRate" | "BacktrackChangeRecordsStored" | "BacktrackWindowActual" | "BacktrackWindowAlert" | "BackupRetentionPeriodStorageUsed" | "BinLogDiskUsage" | "BlockedTransactions" | "BufferCacheHitRatio" | "CommitLatency" | "CommitThroughput" | "CPUCreditBalance" | "CPUCreditUsage" | "CPUUtilization" | "DatabaseConnections" | "DDLLatency" | "DDLThroughput" | "Deadlocks" | "DeleteLatency" | "DeleteThroughput" | "DiskQueueDepth" | "DMLLatency" | "DMLThroughput" | "EngineUptime" | "FreeableMemory" | "FreeLocalStorage" | "InsertLatency" | "InsertThroughput" | "LoginFailures" | "MaximumUsedTransactionIDs" | "NetworkReceiveThroughput" | "NetworkThroughput" | "NetworkTransmitThroughput" | "Queries" | "RDSToAuroraPostgreSQLReplicaLag" | "ReadIOPS" | "ReadLatency" | "ReadThroughput" | "ResultSetCacheHitRatio" | "SelectLatency" | "SelectThroughput" | "SnapshotStorageUsed" | "SwapUsage" | "TotalBackupStorageBilled" | "TransactionLogsDiskUsage" | "UpdateLatency" | "UpdateThroughput" | "VolumeBytesUsed" | "VolumeReadIOPs" | "VolumeWriteIOPs" | "WriteIOPS" | "WriteLatency" | "WriteThroughput";

    function rdsToAuroraPostgreSQLReplicaLag

    rdsToAuroraPostgreSQLReplicaLag(change?: RdsMetricChange): Metric

    The amount of lag in seconds when replicating updates from the primary RDS PostgreSQL instance to other nodes in the cluster.

    Applies to: Aurora PostgreSQL

    function readIOPS

    readIOPS(change?: RdsMetricChange): Metric

    The average number of disk read I/O operations per second.

    Units: Count/Second

    function readLatency

    readLatency(change?: RdsMetricChange): Metric

    The average amount of time taken per disk I/O operation.

    Units: Seconds

    function readThroughput

    readThroughput(change?: RdsMetricChange): Metric

    The average number of bytes read from disk per second.

    Units: Bytes/Second

    function replicaLag

    replicaLag(change?: RdsMetricChange): Metric

    The amount of time a Read Replica DB instance lags behind the source DB instance. Applies to MySQL, MariaDB, and PostgreSQL Read Replicas.

    Units: Seconds

    function replicationSlotDiskUsage

    replicationSlotDiskUsage(change?: RdsMetricChange): Metric

    The disk space used by replication slot files. Applies to PostgreSQL.

    Units: Megabytes

    function resultSetCacheHitRatio

    resultSetCacheHitRatio(change?: RdsMetricChange): Metric

    The percentage of requests that are served by the Resultset cache.

    Applies to: Aurora MySQL

    function selectLatency

    selectLatency(change?: RdsMetricChange): Metric

    The amount of latency for select queries, in milliseconds.

    Applies to: Aurora MySQL

    function selectThroughput

    selectThroughput(change?: RdsMetricChange): Metric

    The average number of select queries per second.

    Applies to: Aurora MySQL

    function snapshotStorageUsed

    snapshotStorageUsed(change?: RdsMetricChange): Metric

    The total amount of backup storage in GiB consumed by all Aurora snapshots for an Aurora DB cluster outside its backup retention window. Included in the total reported by the TotalBackupStorageBilled metric. Computed separately for each Aurora cluster. For instructions, see Understanding Aurora Backup Storage Usage. Units: Gibibytes (GiB)

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function swapUsage

    swapUsage(change?: RdsMetricChange): Metric

    The amount of swap space used on the DB instance. This metric is not available for SQL Server.

    Units: Bytes

    function totalBackupStorageBilled

    totalBackupStorageBilled(change?: RdsMetricChange): Metric

    The total amount of backup storage in GiB for which you are billed for a given Aurora DB cluster. Includes the backup storage measured by the BackupRetentionPeriodStorageUsed and SnapshotStorageUsed metrics. Computed separately for each Aurora cluster. For instructions, see Understanding Aurora Backup Storage Usage. Units: Gibibytes (GiB)

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function transactionLogsDiskUsage

    transactionLogsDiskUsage(change?: RdsMetricChange): Metric

    The disk space used by transaction logs. Applies to PostgreSQL.

    Units: Megabytes

    function transactionLogsGeneration

    transactionLogsGeneration(change?: RdsMetricChange): Metric

    The size of transaction logs generated per second. Applies to PostgreSQL.

    Units: Megabytes/Second

    function updateLatency

    updateLatency(change?: RdsMetricChange): Metric

    The amount of latency for update queries, in milliseconds.

    Applies to: Aurora MySQL

    function updateThroughput

    updateThroughput(change?: RdsMetricChange): Metric

    The average number of update queries per second.

    Applies to: Aurora MySQL

    function volumeBytesUsed

    volumeBytesUsed(change?: RdsMetricChange): Metric

    The amount of storage used by your Aurora DB instance, in bytes. This value affects the cost of the Aurora DB cluster (for pricing information, see the Amazon RDS product page).

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function volumeReadIOPs

    volumeReadIOPs(change?: RdsMetricChange): Metric

    The number of billed read I/O operations from a cluster volume, reported at 5-minute intervals. Billed read operations are calculated at the cluster volume level, aggregated from all instances in the Aurora DB cluster, and then reported at 5-minute intervals. The value is calculated by taking the value of the Read operations metric over a 5-minute period. You can determine the amount of billed read operations per second by taking the value of the Billed read operations metric and dividing by 300 seconds. For example, if the Billed read operations returns 13,686, then the billed read operations per second is 45 (13,686 / 300 = 45.62). You accrue billed read operations for queries that request database pages that aren’t in the buffer cache and therefore must be loaded from storage. You might see spikes in billed read operations as query results are read from storage and then loaded into the buffer cache.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function volumeWriteIOPs

    volumeWriteIOPs(change?: RdsMetricChange): Metric

    The number of write disk I/O operations to the cluster volume, reported at 5-minute intervals. See the description of VolumeReadIOPS above for a detailed description of how billed write operations are calculated.

    Applies to: Aurora MySQL and Aurora PostgreSQL

    function writeIOPS

    writeIOPS(change?: RdsMetricChange): Metric

    The average number of disk write I/O operations per second.

    Units: Count/Second

    function writeLatency

    writeLatency(change?: RdsMetricChange): Metric

    The average amount of time taken per disk I/O operation.

    Units: Seconds

    function writeThroughput

    writeThroughput(change?: RdsMetricChange): Metric

    The average number of bytes written to disk per second.

    Units: Bytes/Second

      Pulumi AI - What cloud infrastructure would you like to build? Generate Program