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
- Struct
- Aws::DatabaseMigrationService::Types::MySQLSettings
- Defined in:
- (unknown)
Overview
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:
Instance Attribute Summary collapse
-
#after_connect_script ⇒ String
Specifies a script to run immediately after AWS DMS connects to the endpoint.
-
#database_name ⇒ 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.
-
#max_file_size ⇒ 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.
-
#password ⇒ String
Endpoint connection password.
-
#port ⇒ Integer
Endpoint TCP port.
-
#server_name ⇒ String
Fully qualified domain name of the endpoint.
-
#server_timezone ⇒ 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.
-
#username ⇒ String
Endpoint connection user name.
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.
#database_name ⇒ 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.
#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
#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
#password ⇒ String
Endpoint connection password.
#port ⇒ Integer
Endpoint TCP port.
#server_name ⇒ 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.
#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
#username ⇒ String
Endpoint connection user name.