Working with the AWS DMS maintenance window
Every AWS DMS replication instance has a weekly maintenance window during which any available system changes are applied. You can think of the maintenance window as an opportunity to control when modifications and software patching occurs.
If AWS DMS determines that maintenance is required during a given week, the maintenance occurs during the 30-minute maintenance window you chose when you created the replication instance. AWS DMS completes most maintenance during the 30-minute maintenance window. However, a longer time might be required for larger changes.
Effect of maintenance on existing migration tasks
When an AWS DMS migration task is running on an instance, the following events occur when a patch is applied:
If the tables in the migration task are in the replicating ongoing changes phase (CDC), AWS DMS pauses the task for a moment while the patch is applied. The migration then continues from where it was interrupted when the patch was applied.
If AWS DMS is migrating a table when the patch is applied, AWS DMS restarts the migration for the table.
Changing the maintenance window setting
You can change the maintenance window time frame using the AWS Management Console, the AWS CLI, or the AWS DMS API.
You can change the maintenance window time frame using the AWS Management Console.
To change the preferred maintenance window using the console
-
Sign in to the AWS Management Console and open the AWS DMS console at https://console.aws.amazon.com/dms/v2/
. In the navigation pane, choose Replication instances.
Choose the replication instance you want to modify and choose Modify.
Expand the Maintenance tab and choose a date and time for your maintenance window.
Choose Apply changes immediately.
Choose Modify.
To adjust the preferred maintenance window, use the AWS CLI modify-replication-instance
command with the
following parameters.
-
--replication-instance-identifier
-
--preferred-maintenance-window
Example
The following AWS CLI example sets the maintenance window to Tuesdays from 4:00–4:30 a.m. UTC.
aws dms modify-replication-instance \ --replication-instance-identifier
myrepinstance
\ --preferred-maintenance-windowTue:04:00-Tue:04:30
To adjust the preferred maintenance window, use the AWS DMS API ModifyReplicationInstance
action with the
following parameters.
-
ReplicationInstanceIdentifier =
myrepinstance
-
PreferredMaintenanceWindow =
Tue:04:00-Tue:04:30
Example
The following code example sets the maintenance window to Tuesdays from 4:00–4:30 a.m. UTC.
https://dms.us-west-2.amazonaws.com/ ?Action=ModifyReplicationInstance &DBInstanceIdentifier=myrepinstance &PreferredMaintenanceWindow=Tue:04:00-Tue:04:30 &SignatureMethod=HmacSHA256 &SignatureVersion=4 &Version=2014-09-01 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIADQKE4SARGYLE/20140425/us-east-1/dms/aws4_request &X-Amz-Date=20140425T192732Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=1dc9dd716f4855e9bdf188c70f1cf9f6251b070b68b81103b59ec70c3e7854b3