public static final class CfnEndpoint.MySqlSettingsProperty.Builder
extends java.lang.Object
CfnEndpoint.MySqlSettingsProperty
Constructor and Description |
---|
Builder() |
public CfnEndpoint.MySqlSettingsProperty.Builder afterConnectScript(java.lang.String afterConnectScript)
CfnEndpoint.MySqlSettingsProperty.getAfterConnectScript()
afterConnectScript
- Specifies a script to run immediately after AWS DMS connects to the endpoint.
The migration task continues running regardless if the SQL statement succeeds or fails.
For this parameter, provide the code of the script itself, not the name of a file containing the script.
this
public CfnEndpoint.MySqlSettingsProperty.Builder cleanSourceMetadataOnMismatch(java.lang.Boolean cleanSourceMetadataOnMismatch)
CfnEndpoint.MySqlSettingsProperty.getCleanSourceMetadataOnMismatch()
cleanSourceMetadataOnMismatch
- Adjusts the behavior of DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster.
If you need DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false
.this
public CfnEndpoint.MySqlSettingsProperty.Builder cleanSourceMetadataOnMismatch(IResolvable cleanSourceMetadataOnMismatch)
CfnEndpoint.MySqlSettingsProperty.getCleanSourceMetadataOnMismatch()
cleanSourceMetadataOnMismatch
- Adjusts the behavior of DMS when migrating from an SQL Server source database that is hosted as part of an Always On availability group cluster.
If you need DMS to poll all the nodes in the Always On cluster for transaction backups, set this attribute to false
.this
public CfnEndpoint.MySqlSettingsProperty.Builder eventsPollInterval(java.lang.Number eventsPollInterval)
CfnEndpoint.MySqlSettingsProperty.getEventsPollInterval()
eventsPollInterval
- Specifies how often to check the binary log for new changes/events when the database is idle.
The default is five seconds.
Example: eventsPollInterval=5;
In the example, AWS DMS checks for changes in the binary logs every five seconds.
this
public CfnEndpoint.MySqlSettingsProperty.Builder maxFileSize(java.lang.Number maxFileSize)
CfnEndpoint.MySqlSettingsProperty.getMaxFileSize()
maxFileSize
- Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
Example: maxFileSize=512
this
public CfnEndpoint.MySqlSettingsProperty.Builder parallelLoadThreads(java.lang.Number parallelLoadThreads)
CfnEndpoint.MySqlSettingsProperty.getParallelLoadThreads()
parallelLoadThreads
- Improves performance when loading data into the MySQL-compatible target database.
Specifies how many threads to use to load the data into the MySQL-compatible target database. Setting a large number of threads can have an adverse effect on database performance, because a separate connection is required for each thread. The default is one.
Example: parallelLoadThreads=1
this
public CfnEndpoint.MySqlSettingsProperty.Builder secretsManagerAccessRoleArn(java.lang.String secretsManagerAccessRoleArn)
CfnEndpoint.MySqlSettingsProperty.getSecretsManagerAccessRoleArn()
secretsManagerAccessRoleArn
- The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in `SecretsManagerSecret` .
The role must allow the iam:PassRole
action. SecretsManagerSecret
has the value of the AWS Secrets Manager secret that allows access to the MySQL endpoint.
You can specify one of two sets of values for these permissions. You can specify the values for this setting and
SecretsManagerSecretId
. Or you can specify clear-text values forUserName
,Password
,ServerName
, andPort
. You can't specify both.For more information on creating this
SecretsManagerSecret
, the correspondingSecretsManagerAccessRoleArn
, and theSecretsManagerSecretId
that is required to access it, see Using secrets to access AWS Database Migration Service resources in the AWS Database Migration Service User Guide .
this
public CfnEndpoint.MySqlSettingsProperty.Builder secretsManagerSecretId(java.lang.String secretsManagerSecretId)
CfnEndpoint.MySqlSettingsProperty.getSecretsManagerSecretId()
secretsManagerSecretId
- The full ARN, partial ARN, or display name of the `SecretsManagerSecret` that contains the MySQL endpoint connection details.this
public CfnEndpoint.MySqlSettingsProperty.Builder serverTimezone(java.lang.String serverTimezone)
CfnEndpoint.MySqlSettingsProperty.getServerTimezone()
serverTimezone
- Specifies the time zone for the source MySQL database.
Example: serverTimezone=US/Pacific;
Note: Do not enclose time zones in single quotes.
this
public CfnEndpoint.MySqlSettingsProperty.Builder targetDbType(java.lang.String targetDbType)
CfnEndpoint.MySqlSettingsProperty.getTargetDbType()
targetDbType
- Specifies where to migrate source tables on the target, either to a single database or multiple databases.
If you specify SPECIFIC_DATABASE
, specify the database name using the DatabaseName
parameter of the Endpoint
object.
Example: targetDbType=MULTIPLE_DATABASES
this
public CfnEndpoint.MySqlSettingsProperty build()
CfnEndpoint.MySqlSettingsProperty
java.lang.NullPointerException
- if any required attribute was not provided