AWS Database Migration Service (replication instance) is a web service that is used to migrate data from your database to a database on an AWS service.
Your database can be one of the following:
- On-premises
- An Amazon Relational Database Service (Amazon RDS) DB instance
- An Amazon Elastic Compute Cloud (Amazon EC2) instance
These services can include a database on Amazon RDS or a database on an Amazon EC2 instance. Also, you can:
- Migrate a database from an AWS service to an on-premises database.
- Migrate data between heterogeneous or homogeneous database engines.
Use the AWS public cloud integration to discover and collect metrics against the AWS service.
External reference
What is AWS Database Migration Service?
Setup
To set up the AWS integration and discover the AWS service, go to AWS Integration Discovery Profile and select Replication Instance.
Event support
CloudTrail event support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
CloudWatch alarm support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
Supported metrics
| OpsRamp Metric | AWS Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|---|
| aws_dms_FullLoadThroughputBandwidthTarget | FullLoadThroughputBandwidthTarget | Full Load Throughput Bandwidth Target | Count/Second | Average | Outgoing data transmitted from a full load for the target in KB per second. |
| aws_dms_FullLoadThroughputRowsTarget | FullLoadThroughputRowsTarget | Full Load Throughput Rows Target | Count/Second | Average | Outgoing changes from a full load for the target in rows per second. |
| aws_dms_CDCIncomingChanges | CDCIncomingChanges | CDC Incoming Changes | Count | Average | The total number of change events at a point-in-time that are waiting to be applied to the target. Note that this is not the same as a measure of the transaction change rate of the source endpoint. A large number for this metric usually indicates AWS DMS is unable to apply captured changes in a timely manner, thus causing high target latency. |
| aws_dms_CDCChangesMemorySource | CDCChangesMemorySource | CDC Changes Memory Source | Count | Average | Amount of rows accumulating in a memory and waiting to be committed from the source. You can view this metric together with CDCChangesDiskSource. |
| aws_dms_CDCChangesMemoryTarget | CDCChangesMemoryTarget | CDC Changes Memory Target | Count | Average | Amount of rows accumulating in a memory and waiting to be committed to the target. You can view this metric together with CDCChangesDiskTarget. |
| aws_dms_CDCChangesDiskSource | CDCChangesDiskSource | CDC Changes Disk Source | Count | Average | Amount of rows accumulating on disk and waiting to be committed from the source. You can view this metric together with CDCChangesMemorySource. |
| aws_dms_CDCChangesDiskTarget | CDCChangesDiskTarget | CDC Changes Disk Target | Count | Average | Amount of rows accumulating on disk and waiting to be committed to the target. You can view this metric together with CDCChangesMemoryTarget. |
| aws_dms_CDCThroughputBandwidthTarget | CDCThroughputBandwidthTarget | CDC Throughput Bandwidth Target | Kilobytes/Second | Average | Outgoing data transmitted for the target in KB per second. CDCThroughputBandwidth records outgoing data transmitted on sampling points. If no task network traffic is found, the value is zero. Because CDC does not issue long-running transactions, network traffic may not be recorded. |
| aws_dms_CDCThroughputRowsSource | CDCThroughputRowsSource | CDC Throughput Rows Source | Count/Second | Average | Incoming task changes from the source in rows per second. |
| aws_dms_CDCThroughputRowsTarget | CDCThroughputRowsTarget | CDC Throughput Rows Target | Count/Second | Average | Outgoing task changes for the target in rows per second. |
| aws_dms_CDCLatencySource | CDCLatencySource | CDC Latency Source | Seconds | Average | The gap, in seconds, between the last event captured from the source endpoint and current system time stamp of the AWS DMS instance. CDCLatencySource represents the latency between source and replication instance. |
| aws_dms_CDCLatencyTarget | CDCLatencyTarget | CDC Latency Target | Seconds | Average | The gap, in seconds, between the first event timestamp waiting to commit on the target and the current timestamp of the AWS DMS instance. Target latency is the difference between the replication instance server time and the oldest unconfirmed event id forwarded to a target component. |
| aws_dms_CPUUtilization | CPUUtilization | CPU Utilization | Percent | Average | The percentage of CPU being used by a task across multiple cores. The semantics of task CPUUtilization is slightly different from replication CPUUtilizaiton. If 1 vCPU is fully used, it indicates 100%, but if multiple vCPUs are in use, the value could be above 100%. |
| aws_dms_SwapUsage | SwapUsage | Swap Usage | Bytes | Average | The amount of swap used by the task. |
| aws_dms_MemoryUsage | MemoryUsage | Memory Usage | Bytes | Average | The control group (cgroup) memory.usage_in_bytes consumed by a task. DMS uses cgroups to control the usage of system resources such as memory and CPU. This metric indicates a task's memory usage in Megabytes within the cgroup allocated for that task. |
| aws_dms_CPUAllocated | CPUAllocated | CPU Allocated | Percent | Average | The percentage of CPU maximally allocated for the task (0 means no limit). |
| aws_dms_MemoryAllocated | MemoryAllocated | Memory Allocated | None | Average | The maximum allocation of memory for the task (0 means no limits). |