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.

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.

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>