NAME
Paws::DMS::MySQLSettings
USAGE
This class represents one of two things:
Arguments in a call to a service
Use the attributes of this class as arguments to methods. You shouldn't make instances of this class. Each attribute should be used as a named argument in the calls that expect this type of object.
As an example, if Att1 is expected to be a Paws::DMS::MySQLSettings object:
$service_obj->Method(Att1 => { AfterConnectScript => $value, ..., Username => $value });
Results returned from an API call
Use accessors for each attribute. If Att1 is expected to be an Paws::DMS::MySQLSettings object:
$result = $service_obj->Method(...);
$result->Att1->AfterConnectScript
DESCRIPTION
Provides information that defines a MySQL endpoint.
ATTRIBUTES
AfterConnectScript => Str
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.
CleanSourceMetadataOnMismatch => Bool
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
.
DatabaseName => Str
Database name for the endpoint.
EventsPollInterval => Int
Specifies how often to check the binary log for new changes/events when the database is idle.
Example: eventsPollInterval=5;
In the example, AWS DMS checks for changes in the binary logs every five seconds.
MaxFileSize => Int
Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
Example: maxFileSize=512
ParallelLoadThreads => Int
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.
Example: parallelLoadThreads=1
Password => Str
Endpoint connection password.
Port => Int
Endpoint TCP port.
SecretsManagerAccessRoleArn => Str
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
. 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 for UserName
, Password
, ServerName
, and Port
. You can't specify both. For more information on creating this SecretsManagerSecret
and the SecretsManagerAccessRoleArn
and SecretsManagerSecretId
required to access it, see Using secrets to access AWS Database Migration Service resources (https://docs.aws.amazon.com/https:/docs.aws.amazon.com/dms/latest/userguide/CHAP_Security.html#security-iam-secretsmanager) in the AWS Database Migration Service User Guide.
SecretsManagerSecretId => Str
The full ARN, partial ARN, or friendly name of the SecretsManagerSecret
that contains the MySQL endpoint connection details.
ServerName => Str
Fully qualified domain name of the endpoint.
ServerTimezone => Str
Specifies the time zone for the source MySQL database.
Example: serverTimezone=US/Pacific;
Note: Do not enclose time zones in single quotes.
TargetDbType => Str
Specifies where to migrate source tables on the target, either to a single database or multiple databases.
Example: targetDbType=MULTIPLE_DATABASES
Username => Str
Endpoint connection user name.
SEE ALSO
This class forms part of Paws, describing an object used in Paws::DMS
BUGS and CONTRIBUTIONS
The source code is located here: https://github.com/pplu/aws-sdk-perl
Please report bugs to: https://github.com/pplu/aws-sdk-perl/issues