AWS DMS¶
The displayed Metrics of AWS DMS include data migration speed, latency, data consistency, and migration success rate, which reflect the performance and reliability of DMS during database migration and replication.
Configuration¶
Install Func¶
We recommend enabling Guance Integrations - Extensions - Hosted Func: all prerequisites are installed automatically. Continue with script installation.
To deploy Func yourself, see Self-hosted Func.
Install Script¶
Note: Please prepare the required Amazon AK in advance (for simplicity, you can grant global read-only permissions
ReadOnlyAccess)
Activate Script in DataFlux Func (Automata)¶
- Log in to the Guance console
- Click the 【Integration】 menu and select 【Cloud Account Management】
- Click 【Add Cloud Account】, select 【AWS】, and fill in the required information on the interface. If you have already configured the cloud account information before, ignore this step
- Click 【Test】, and if the test is successful, click 【Save】. If the test fails, please check if the relevant configuration information is correct and test again
- Click 【Cloud Account Management】, and you can see the added cloud account in the list. Click the corresponding cloud account to enter the details page
- Click on the 【Integration】 button on the cloud account details page, and find
AWS DMSunder theNot Installedlist. Click on the 【Install】 button, and the installation interface will pop up for installation.
Activate Script Manually¶
-
Log in to the Func console, click on 【Script Market】, enter the Guance script market, and search for
integration_aws_dms. -
Click 【Install】, then enter the corresponding parameters: AWS AK ID, AK Secret, and account name.
-
Click 【Deploy Startup Script】, the system will automatically create the
Startupscript set and automatically configure the corresponding startup script. -
After activation, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to execute it immediately without waiting for the scheduled time. After a while, you can view the execution task records and corresponding logs.
Verification¶
- Under [Management / Automatic Trigger Configuration], confirm that an automatic trigger configuration exists for the task, and check the task records and logs for errors.
- In Guance, check [Infrastructure / Custom] for asset information.
- In Guance, check [Metrics] for the corresponding monitoring data.
Metrics¶
After configuring Amazon CloudWatch, the default Measurement is as follows. More Metrics can be collected through configuration Amazon CloudWatch Metrics Details
Instance Metrics¶
Instance metrics in the AWS/DMS namespace use the ReplicationInstanceIdentifier dimension. SwapUsage supports both instance and task statistics, distinguished by dimensions. With only the instance dimension, it represents swap usage for the entire replication instance.
| Metric | Description |
|---|---|
CPUUtilization |
The percentage of allocated vCPU (virtual CPU) currently in use on the instance. Unit: Percentage |
FreeMemory |
The amount of physical memory available for applications, page cache, and the kernel's own data structures. For more information, see the MemFree value in the /proc/memInfo section of the Linux manual page. Unit: Bytes |
FreeStorageSpace |
The size of available storage space. Unit: Bytes |
WriteIOPS |
The average number of disk write I/O operations per second. Unit: Count/s |
ReadIOPS |
The average number of disk read I/O operations per second. Unit: Count/s |
WriteThroughput |
The average number of bytes written to disk per second. Unit: Bytes/s |
ReadThroughput |
The average number of bytes read from disk per second. Unit: Bytes/s |
NetworkTransmitThroughput |
The outgoing (transmit) network traffic on the replication instance, including customer database AWS DMS traffic and traffic used for monitoring and replication. Unit: Bytes/s |
NetworkReceiveThroughput |
The incoming (receive) network traffic on the replication instance, including customer database AWS DMS traffic and traffic used for monitoring and replication. Unit: Bytes/s |
SwapUsage |
Swap space used by the replication instance. Unit: bytes. |
Task Metrics¶
The following task metrics use both ReplicationInstanceIdentifier and ReplicationTaskIdentifier. With these two dimensions, SwapUsage represents task swap usage in bytes. CDC* metrics apply to ongoing replication, and FullLoad* metrics to full loading. Data availability depends on the task type, phase, and actual workload; null or zero values do not necessarily indicate a collection error.
| Metric | Description |
|---|---|
CDCChangesMemorySource |
The number of rows accumulated in memory and waiting to be committed from the source. You can view this Metric together with CDC ChangesDiskSource. |
CDCChangesMemoryTarget |
The number of rows accumulated in memory and waiting to be committed to the target. You can view this Metric together with CDC ChangesDiskTarget. |
CDCChangesDiskSource |
The number of rows accumulated on disk and waiting to be committed from the source. You can view this Metric together with CDC ChangesMemorySource. |
CDCChangesDiskTarget |
The number of rows accumulated on disk and waiting to be committed to the target. You can view this Metric together with CDC ChangesMemoryTarget. |
CDCThroughputBandwidthTarget |
The outgoing data transmitted to the target, in KB per second. CDC ThroughputBandwidth records the outgoing data transmitted at the sampling point. If no task network traffic is found, this value is zero. Since CDC does not publish long-running transactions, network traffic may not be recorded. |
CDCThroughputRowsSource |
The incoming task changes from the source, in rows per second. |
CDCThroughputRowsTarget |
The outgoing task changes to the target, in rows per second. |
CDCIncomingChanges |
Change events read but not yet applied to the target. Unit: count. |
CDCLatencySource |
Difference between the timestamp of the latest event captured at the source and the current replication instance time. Unit: seconds. |
CDCLatencyTarget |
Difference between the timestamp of the oldest event awaiting commit or application at the target and the current replication instance time. Unit: seconds. |
CDCThroughputBandwidthSource |
Incoming data throughput from the source during CDC. Unit: KB/s. |
FullLoadThroughputBandwidthSource |
Incoming data throughput from the source during full loading. Unit: KB/s. |
FullLoadThroughputBandwidthTarget |
Outgoing data throughput to the target during full loading. Unit: KB/s. |
FullLoadThroughputRowsSource |
Data read rate from the source during full loading. Unit: rows/s. |
FullLoadThroughputRowsTarget |
Data write rate to the target during full loading. Unit: rows/s. |
Objects¶
The collected AWS DMS object data structure can be seen in 「Infrastructure - Custom」
{
"measurement": "aws_dms",
"tags": {
"AvailabilityZone" :"cn-northwest-1b",
"class" :"aws_dms",
"cloud_provider" :"aws",
"KmsKeyId:arn" :"aws-cn:kms:cn-northwest-1:294654068288:key/531cd79a-5a86-47d6-b216-0d63e2e32b3a",
"name" :"hn-test",
"ReplicationInstanceClass" :"dms.t3.micro",
"ReplicationInstanceIdentifier" :"hn-test"
}
}
Note: The fields in
tagsmay change with subsequent updatesTip 1: The
namevalue is the instance ID, used as a unique identifier.