You are viewing documentation for version 2 of the AWS SDK for Ruby. Version 3 documentation can be found here.

Class: Aws::DatabaseMigrationService::Types::MySQLSettings

Inherits:
Struct
  • Object
show all
Defined in:
(unknown)

Overview

Note:

When passing MySQLSettings as input to an Aws::Client method, you can use a vanilla Hash:

{
  after_connect_script: "String",
  database_name: "String",
  events_poll_interval: 1,
  target_db_type: "specific-database", # accepts specific-database, multiple-databases
  max_file_size: 1,
  parallel_load_threads: 1,
  password: "SecretString",
  port: 1,
  server_name: "String",
  server_timezone: "String",
  username: "String",
}

Provides information that defines a MySQL endpoint.

Returned by:

See Also:

Instance Attribute Summary collapse

Instance Attribute Details

#after_connect_script ⇒ String

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.

Returns:

  • (String) —

    Specifies a script to run immediately after AWS DMS connects to the endpoint.

#database_name ⇒ String

Database name for the endpoint.

Returns:

  • (String) —

    Database name for the endpoint.

#events_poll_interval ⇒ Integer

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.

Returns:

  • (Integer) —

    Specifies how often to check the binary log for new changes/events when the database is idle.

#max_file_size ⇒ Integer

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

Example: maxFileSize=512

Returns:

  • (Integer) —

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

#parallel_load_threads ⇒ Integer

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

Returns:

  • (Integer) —

    Improves performance when loading data into the MySQLcompatible target database.

#password ⇒ String

Endpoint connection password.

Returns:

  • (String) —

    Endpoint connection password.

#port ⇒ Integer

Endpoint TCP port.

Returns:

  • (Integer) —

    Endpoint TCP port.

#server_name ⇒ String

Fully qualified domain name of the endpoint.

Returns:

  • (String) —

    Fully qualified domain name of the endpoint.

#server_timezone ⇒ String

Specifies the time zone for the source MySQL database.

Example: serverTimezone=US/Pacific;

Note: Do not enclose time zones in single quotes.

Returns:

  • (String) —

    Specifies the time zone for the source MySQL database.

#target_db_type ⇒ String

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

Example: targetDbType=MULTIPLE_DATABASES

Possible values:

  • specific-database
  • multiple-databases

Returns:

  • (String) —

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

#username ⇒ String

Endpoint connection user name.

Returns:

  • (String) —

    Endpoint connection user name.