2019/11/01 - AWS Database Migration Service - 7 updated api methods
Changes This release contains task timeline attributes in replication task statistics. This release also adds a note to the documentation for the CdcStartPosition task request parameter. This note describes how to enable the use of native CDC start points for a PostgreSQL source by setting the new slotName extra connection attribute on the source endpoint to the name of an existing logical replication slot.
{'ReplicationTask': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Creates a replication task using the specified parameters.
See also: AWS API Documentation
Request Syntax
client.create_replication_task( ReplicationTaskIdentifier='string', SourceEndpointArn='string', TargetEndpointArn='string', ReplicationInstanceArn='string', MigrationType='full-load'|'cdc'|'full-load-and-cdc', TableMappings='string', ReplicationTaskSettings='string', CdcStartTime=datetime(2015, 1, 1), CdcStartPosition='string', CdcStopPosition='string', Tags=[ { 'Key': 'string', 'Value': 'string' }, ] )
string
[REQUIRED]
An identifier for the replication task.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
string
[REQUIRED]
An Amazon Resource Name (ARN) that uniquely identifies the source endpoint.
string
[REQUIRED]
An Amazon Resource Name (ARN) that uniquely identifies the target endpoint.
string
[REQUIRED]
The Amazon Resource Name (ARN) of a replication instance.
string
[REQUIRED]
The migration type. Valid values: full-load | cdc | full-load-and-cdc
string
[REQUIRED]
The table mappings for the task, in JSON format. For more information, see Table Mapping in the AWS Database Migration User Guide.
string
Overall settings for the task, in JSON format. For more information, see Task Settings in the AWS Database Migration User Guide.
datetime
Indicates the start time for a change data capture (CDC) operation. Use either CdcStartTime or CdcStartPosition to specify when you want a CDC operation to start. Specifying both values results in an error.
Timestamp Example: --cdc-start-time “2018-03-08T12:12:12”
string
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want a CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
Note
When you use this task setting with a source PostgreSQL database, a logical replication slot should already be created and associated with the source endpoint. You can verify this by setting the slotName extra connection attribute to the name of this logical replication slot. For more information, see Extra Connection Attributes When Using PostgreSQL as a Source for AWS DMS .
string
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
list
One or more tags to be assigned to the replication task.
(dict) --
Key (string) --
A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and cannot be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").
Value (string) --
A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and cannot be prefixed with "aws:" or "dms:". The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', '/', '=', '+', '-' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-]*)$").
dict
Response Syntax
{ 'ReplicationTask': { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } } }
Response Structure
(dict) --
ReplicationTask (dict) --
The replication task that was created.
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.
{'ReplicationTask': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Deletes the specified replication task.
See also: AWS API Documentation
Request Syntax
client.delete_replication_task( ReplicationTaskArn='string' )
string
[REQUIRED]
The Amazon Resource Name (ARN) of the replication task to be deleted.
dict
Response Syntax
{ 'ReplicationTask': { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } } }
Response Structure
(dict) --
ReplicationTask (dict) --
The deleted replication task.
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.
{'ReplicationTasks': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Returns information about replication tasks for your account in the current region.
See also: AWS API Documentation
Request Syntax
client.describe_replication_tasks( Filters=[ { 'Name': 'string', 'Values': [ 'string', ] }, ], MaxRecords=123, Marker='string', WithoutSettings=True|False )
list
Filters applied to the describe action.
Valid filter names: replication-task-arn | replication-task-id | migration-type | endpoint-arn | replication-instance-arn
(dict) --
Name (string) -- [REQUIRED]
The name of the filter.
Values (list) -- [REQUIRED]
The filter value.
(string) --
integer
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that the remaining results can be retrieved.
Default: 100
Constraints: Minimum 20, maximum 100.
string
An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .
boolean
An option to set to avoid returning information about settings. Use this to reduce overhead when setting information is too large. To use this option, choose true ; otherwise, choose false (the default).
dict
Response Syntax
{ 'Marker': 'string', 'ReplicationTasks': [ { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } }, ] }
Response Structure
(dict) --
Marker (string) --
An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords .
ReplicationTasks (list) --
A description of the replication tasks.
(dict) --
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.
{'ReplicationTask': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Modifies the specified replication task.
You can't modify the task endpoints. The task must be stopped before you can modify it.
For more information about AWS DMS tasks, see Working with Migration Tasks in the AWS Database Migration Service User Guide .
See also: AWS API Documentation
Request Syntax
client.modify_replication_task( ReplicationTaskArn='string', ReplicationTaskIdentifier='string', MigrationType='full-load'|'cdc'|'full-load-and-cdc', TableMappings='string', ReplicationTaskSettings='string', CdcStartTime=datetime(2015, 1, 1), CdcStartPosition='string', CdcStopPosition='string' )
string
[REQUIRED]
The Amazon Resource Name (ARN) of the replication task.
string
The replication task identifier.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
string
The migration type. Valid values: full-load | cdc | full-load-and-cdc
string
When using the AWS CLI or boto3, provide the path of the JSON file that contains the table mappings. Precede the path with file:// . When working with the DMS API, provide the JSON as the parameter value, for example: --table-mappings file://mappingfile.json
string
JSON file that contains settings for the task, such as target metadata settings.
datetime
Indicates the start time for a change data capture (CDC) operation. Use either CdcStartTime or CdcStartPosition to specify when you want a CDC operation to start. Specifying both values results in an error.
Timestamp Example: --cdc-start-time “2018-03-08T12:12:12”
string
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want a CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
Note
When you use this task setting with a source PostgreSQL database, a logical replication slot should already be created and associated with the source endpoint. You can verify this by setting the slotName extra connection attribute to the name of this logical replication slot. For more information, see Extra Connection Attributes When Using PostgreSQL as a Source for AWS DMS .
string
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
dict
Response Syntax
{ 'ReplicationTask': { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } } }
Response Structure
(dict) --
ReplicationTask (dict) --
The replication task that was modified.
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.
{'ReplicationTask': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Starts the replication task.
For more information about AWS DMS tasks, see Working with Migration Tasks in the AWS Database Migration Service User Guide.
See also: AWS API Documentation
Request Syntax
client.start_replication_task( ReplicationTaskArn='string', StartReplicationTaskType='start-replication'|'resume-processing'|'reload-target', CdcStartTime=datetime(2015, 1, 1), CdcStartPosition='string', CdcStopPosition='string' )
string
[REQUIRED]
The Amazon Resource Name (ARN) of the replication task to be started.
string
[REQUIRED]
The type of replication task.
datetime
Indicates the start time for a change data capture (CDC) operation. Use either CdcStartTime or CdcStartPosition to specify when you want a CDC operation to start. Specifying both values results in an error.
Timestamp Example: --cdc-start-time “2018-03-08T12:12:12”
string
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want a CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
Note
When you use this task setting with a source PostgreSQL database, a logical replication slot should already be created and associated with the source endpoint. You can verify this by setting the slotName extra connection attribute to the name of this logical replication slot. For more information, see Extra Connection Attributes When Using PostgreSQL as a Source for AWS DMS .
string
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
dict
Response Syntax
{ 'ReplicationTask': { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } } }
Response Structure
(dict) --
ReplicationTask (dict) --
The replication task started.
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.
{'ReplicationTask': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Starts the replication task assessment for unsupported data types in the source database.
See also: AWS API Documentation
Request Syntax
client.start_replication_task_assessment( ReplicationTaskArn='string' )
string
[REQUIRED]
The Amazon Resource Name (ARN) of the replication task.
dict
Response Syntax
{ 'ReplicationTask': { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } } }
Response Structure
(dict) --
ReplicationTask (dict) --
The assessed replication task.
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.
{'ReplicationTask': {'ReplicationTaskStats': {'FreshStartDate': 'timestamp', 'FullLoadFinishDate': 'timestamp', 'FullLoadStartDate': 'timestamp', 'StartDate': 'timestamp', 'StopDate': 'timestamp'}}}
Stops the replication task.
See also: AWS API Documentation
Request Syntax
client.stop_replication_task( ReplicationTaskArn='string' )
string
[REQUIRED]
The Amazon Resource Name(ARN) of the replication task to be stopped.
dict
Response Syntax
{ 'ReplicationTask': { 'ReplicationTaskIdentifier': 'string', 'SourceEndpointArn': 'string', 'TargetEndpointArn': 'string', 'ReplicationInstanceArn': 'string', 'MigrationType': 'full-load'|'cdc'|'full-load-and-cdc', 'TableMappings': 'string', 'ReplicationTaskSettings': 'string', 'Status': 'string', 'LastFailureMessage': 'string', 'StopReason': 'string', 'ReplicationTaskCreationDate': datetime(2015, 1, 1), 'ReplicationTaskStartDate': datetime(2015, 1, 1), 'CdcStartPosition': 'string', 'CdcStopPosition': 'string', 'RecoveryCheckpoint': 'string', 'ReplicationTaskArn': 'string', 'ReplicationTaskStats': { 'FullLoadProgressPercent': 123, 'ElapsedTimeMillis': 123, 'TablesLoaded': 123, 'TablesLoading': 123, 'TablesQueued': 123, 'TablesErrored': 123, 'FreshStartDate': datetime(2015, 1, 1), 'StartDate': datetime(2015, 1, 1), 'StopDate': datetime(2015, 1, 1), 'FullLoadStartDate': datetime(2015, 1, 1), 'FullLoadFinishDate': datetime(2015, 1, 1) } } }
Response Structure
(dict) --
ReplicationTask (dict) --
The replication task stopped.
ReplicationTaskIdentifier (string) --
The user-assigned replication task identifier or name.
Constraints:
Must contain from 1 to 255 alphanumeric characters or hyphens.
First character must be a letter.
Cannot end with a hyphen or contain two consecutive hyphens.
SourceEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
TargetEndpointArn (string) --
The Amazon Resource Name (ARN) string that uniquely identifies the endpoint.
ReplicationInstanceArn (string) --
The Amazon Resource Name (ARN) of the replication instance.
MigrationType (string) --
The type of migration.
TableMappings (string) --
Table mappings specified in the task.
ReplicationTaskSettings (string) --
The settings for the replication task.
Status (string) --
The status of the replication task.
LastFailureMessage (string) --
The last error (failure) message generated for the replication instance.
StopReason (string) --
The reason the replication task was stopped.
ReplicationTaskCreationDate (datetime) --
The date the replication task was created.
ReplicationTaskStartDate (datetime) --
The date the replication task is scheduled to start.
CdcStartPosition (string) --
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error.
The value can be in date, checkpoint, or LSN/SCN format.
Date Example: --cdc-start-position “2018-03-08T12:12:12”
Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93"
LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373”
CdcStopPosition (string) --
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time.
Server time example: --cdc-stop-position “server_time:3018-02-09T12:12:12”
Commit time example: --cdc-stop-position “commit_time: 3018-02-09T12:12:12 “
RecoveryCheckpoint (string) --
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint.
ReplicationTaskArn (string) --
The Amazon Resource Name (ARN) of the replication task.
ReplicationTaskStats (dict) --
The statistics for the task, including elapsed time, tables loaded, and table errors.
FullLoadProgressPercent (integer) --
The percent complete for the full load migration task.
ElapsedTimeMillis (integer) --
The elapsed time of the task, in milliseconds.
TablesLoaded (integer) --
The number of tables loaded for this task.
TablesLoading (integer) --
The number of tables currently loading for this task.
TablesQueued (integer) --
The number of tables queued for this task.
TablesErrored (integer) --
The number of errors that have occurred during this task.
FreshStartDate (datetime) --
The date the replication task was started either with a fresh start or a target reload.
StartDate (datetime) --
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType .
StopDate (datetime) --
The date the replication task was stopped.
FullLoadStartDate (datetime) --
The date the the replication task full load was started.
FullLoadFinishDate (datetime) --
The date the replication task full load was completed.