MySQLSettings - AWS Database Migration Service

MySQLSettings

Provides information that defines a MySQL endpoint.

Contents

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.

Type: String

Required: No

DatabaseName

Database name for the endpoint.

Type: String

Required: No

EventsPollInterval

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.

Type: Integer

Required: No

MaxFileSize

Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.

Example: maxFileSize=512

Type: Integer

Required: No

ParallelLoadThreads

Improves performance when loading data into the MySQLcompatible 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

Type: Integer

Required: No

Password

Endpoint connection password.

Type: String

Required: No

Port

Endpoint TCP port.

Type: Integer

Required: No

ServerName

Fully qualified domain name of the endpoint.

Type: String

Required: No

ServerTimezone

Specifies the time zone for the source MySQL database.

Example: serverTimezone=US/Pacific;

Note: Do not enclose time zones in single quotes.

Type: String

Required: No

TargetDbType

Specifies where to migrate source tables on the target, either to a single database or multiple databases.

Example: targetDbType=MULTIPLE_DATABASES

Type: String

Valid Values: specific-database | multiple-databases

Required: No

Username

Endpoint connection user name.

Type: String

Required: No

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: