Struct aws_sdk_databasemigration::types::GcpMySqlSettings
source · #[non_exhaustive]pub struct GcpMySqlSettings {Show 14 fields
pub after_connect_script: Option<String>,
pub clean_source_metadata_on_mismatch: Option<bool>,
pub database_name: Option<String>,
pub events_poll_interval: Option<i32>,
pub target_db_type: Option<TargetDbType>,
pub max_file_size: Option<i32>,
pub parallel_load_threads: Option<i32>,
pub password: Option<String>,
pub port: Option<i32>,
pub server_name: Option<String>,
pub server_timezone: Option<String>,
pub username: Option<String>,
pub secrets_manager_access_role_arn: Option<String>,
pub secrets_manager_secret_id: Option<String>,
}
Expand description
Settings in JSON format for the source GCP MySQL endpoint.
Fields (Non-exhaustive)§
This struct is marked as non-exhaustive
Struct { .. }
syntax; cannot be matched against without a wildcard ..
; and struct update syntax will not work.after_connect_script: Option<String>
Specifies a script to run immediately after DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
For this parameter, provide the code of the script itself, not the name of a file containing the script.
clean_source_metadata_on_mismatch: Option<bool>
Cleans and recreates table metadata information on the replication instance when a mismatch occurs. For example, in a situation where running an alter DDL on the table could result in different information about the table cached in the replication instance.
database_name: Option<String>
Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName
request parameter on either the CreateEndpoint
or ModifyEndpoint
API call. Specifying DatabaseName
when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the DMS task.
events_poll_interval: Option<i32>
Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
Example: eventsPollInterval=5;
In the example, DMS checks for changes in the binary logs every five seconds.
target_db_type: Option<TargetDbType>
Specifies where to migrate source tables on the target, either to a single database or multiple databases.
Example: targetDbType=MULTIPLE_DATABASES
max_file_size: Option<i32>
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: Option<i32>
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. The default is one.
Example: parallelLoadThreads=1
password: Option<String>
Endpoint connection password.
port: Option<i32>
Endpoint TCP port.
server_name: Option<String>
The MySQL host name.
server_timezone: Option<String>
Specifies the time zone for the source MySQL database.
Example: serverTimezone=US/Pacific;
Note: Do not enclose time zones in single quotes.
username: Option<String>
Endpoint connection user name.
secrets_manager_access_role_arn: Option<String>
The full Amazon Resource Name (ARN) of the IAM role that specifies DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
The role must allow the iam:PassRole
action. SecretsManagerSecret
has the value of the Amazon Web Services 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 Database Migration Service resources in the Database Migration Service User Guide.
secrets_manager_secret_id: Option<String>
The full ARN, partial ARN, or friendly name of the SecretsManagerSecret
that contains the MySQL endpoint connection details.
Implementations§
source§impl GcpMySqlSettings
impl GcpMySqlSettings
sourcepub fn after_connect_script(&self) -> Option<&str>
pub fn after_connect_script(&self) -> Option<&str>
Specifies a script to run immediately after DMS connects to the endpoint. The migration task continues running regardless if the SQL statement succeeds or fails.
For this parameter, provide the code of the script itself, not the name of a file containing the script.
sourcepub fn clean_source_metadata_on_mismatch(&self) -> Option<bool>
pub fn clean_source_metadata_on_mismatch(&self) -> Option<bool>
Cleans and recreates table metadata information on the replication instance when a mismatch occurs. For example, in a situation where running an alter DDL on the table could result in different information about the table cached in the replication instance.
sourcepub fn database_name(&self) -> Option<&str>
pub fn database_name(&self) -> Option<&str>
Database name for the endpoint. For a MySQL source or target endpoint, don't explicitly specify the database using the DatabaseName
request parameter on either the CreateEndpoint
or ModifyEndpoint
API call. Specifying DatabaseName
when you create or modify a MySQL endpoint replicates all the task tables to this single database. For MySQL endpoints, you specify the database only when you specify the schema in the table-mapping rules of the DMS task.
sourcepub fn events_poll_interval(&self) -> Option<i32>
pub fn events_poll_interval(&self) -> Option<i32>
Specifies how often to check the binary log for new changes/events when the database is idle. The default is five seconds.
Example: eventsPollInterval=5;
In the example, DMS checks for changes in the binary logs every five seconds.
sourcepub fn target_db_type(&self) -> Option<&TargetDbType>
pub fn target_db_type(&self) -> Option<&TargetDbType>
Specifies where to migrate source tables on the target, either to a single database or multiple databases.
Example: targetDbType=MULTIPLE_DATABASES
sourcepub fn max_file_size(&self) -> Option<i32>
pub fn max_file_size(&self) -> Option<i32>
Specifies the maximum size (in KB) of any .csv file used to transfer data to a MySQL-compatible database.
Example: maxFileSize=512
sourcepub fn parallel_load_threads(&self) -> Option<i32>
pub fn parallel_load_threads(&self) -> Option<i32>
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. The default is one.
Example: parallelLoadThreads=1
sourcepub fn server_name(&self) -> Option<&str>
pub fn server_name(&self) -> Option<&str>
The MySQL host name.
sourcepub fn server_timezone(&self) -> Option<&str>
pub fn server_timezone(&self) -> Option<&str>
Specifies the time zone for the source MySQL database.
Example: serverTimezone=US/Pacific;
Note: Do not enclose time zones in single quotes.
sourcepub fn secrets_manager_access_role_arn(&self) -> Option<&str>
pub fn secrets_manager_access_role_arn(&self) -> Option<&str>
The full Amazon Resource Name (ARN) of the IAM role that specifies DMS as the trusted entity and grants the required permissions to access the value in SecretsManagerSecret.
The role must allow the iam:PassRole
action. SecretsManagerSecret
has the value of the Amazon Web Services 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 Database Migration Service resources in the Database Migration Service User Guide.
sourcepub fn secrets_manager_secret_id(&self) -> Option<&str>
pub fn secrets_manager_secret_id(&self) -> Option<&str>
The full ARN, partial ARN, or friendly name of the SecretsManagerSecret
that contains the MySQL endpoint connection details.
source§impl GcpMySqlSettings
impl GcpMySqlSettings
sourcepub fn builder() -> GcpMySqlSettingsBuilder
pub fn builder() -> GcpMySqlSettingsBuilder
Creates a new builder-style object to manufacture GcpMySqlSettings
.
Trait Implementations§
source§impl Clone for GcpMySqlSettings
impl Clone for GcpMySqlSettings
source§fn clone(&self) -> GcpMySqlSettings
fn clone(&self) -> GcpMySqlSettings
1.0.0 · source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source
. Read moresource§impl Debug for GcpMySqlSettings
impl Debug for GcpMySqlSettings
source§impl PartialEq for GcpMySqlSettings
impl PartialEq for GcpMySqlSettings
source§fn eq(&self, other: &GcpMySqlSettings) -> bool
fn eq(&self, other: &GcpMySqlSettings) -> bool
self
and other
values to be equal, and is used
by ==
.