MySqlMigration¶

class oci.database_migration.models.MySqlMigration(**kwargs)¶

Bases: oci.database_migration.models.migration.Migration

MySQL Migration resource

Attributes

`DATABASE_COMBINATION_MYSQL`	str(object=’’) -> str
`DATABASE_COMBINATION_ORACLE`	str(object=’’) -> str
`LIFECYCLE_DETAILS_ABORTING`	str(object=’’) -> str
`LIFECYCLE_DETAILS_DONE`	str(object=’’) -> str
`LIFECYCLE_DETAILS_MIGRATING`	str(object=’’) -> str
`LIFECYCLE_DETAILS_READY`	str(object=’’) -> str
`LIFECYCLE_DETAILS_VALIDATED`	str(object=’’) -> str
`LIFECYCLE_DETAILS_VALIDATING`	str(object=’’) -> str
`LIFECYCLE_DETAILS_WAITING`	str(object=’’) -> str
`LIFECYCLE_STATE_ACCEPTED`	str(object=’’) -> str
`LIFECYCLE_STATE_ACTIVE`	str(object=’’) -> str
`LIFECYCLE_STATE_CANCELED`	str(object=’’) -> str
`LIFECYCLE_STATE_CREATING`	str(object=’’) -> str
`LIFECYCLE_STATE_DELETED`	str(object=’’) -> str
`LIFECYCLE_STATE_DELETING`	str(object=’’) -> str
`LIFECYCLE_STATE_FAILED`	str(object=’’) -> str
`LIFECYCLE_STATE_INACTIVE`	str(object=’’) -> str
`LIFECYCLE_STATE_IN_PROGRESS`	str(object=’’) -> str
`LIFECYCLE_STATE_NEEDS_ATTENTION`	str(object=’’) -> str
`LIFECYCLE_STATE_SUCCEEDED`	str(object=’’) -> str
`LIFECYCLE_STATE_UPDATING`	str(object=’’) -> str
`LIFECYCLE_STATE_WAITING`	str(object=’’) -> str
`TYPE_OFFLINE`	str(object=’’) -> str
`TYPE_ONLINE`	str(object=’’) -> str
`WAIT_AFTER_ODMS_CLEANUP`	str(object=’’) -> str
`WAIT_AFTER_ODMS_DATA_UPLOAD`	str(object=’’) -> str
`WAIT_AFTER_ODMS_FETCH_METADATA_SRC`	str(object=’’) -> str
`WAIT_AFTER_ODMS_FETCH_METADATA_TGT`	str(object=’’) -> str
`WAIT_AFTER_ODMS_INITIALIZE_REPLICATION_INFRASTRUCTURE`	str(object=’’) -> str
`WAIT_AFTER_ODMS_INITIAL_LOAD_EXPORT`	str(object=’’) -> str
`WAIT_AFTER_ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD`	str(object=’’) -> str
`WAIT_AFTER_ODMS_INITIAL_LOAD_IMPORT`	str(object=’’) -> str
`WAIT_AFTER_ODMS_MONITOR_REPLICATION_LAG`	str(object=’’) -> str
`WAIT_AFTER_ODMS_POST_INITIAL_LOAD`	str(object=’’) -> str
`WAIT_AFTER_ODMS_PREPARE`	str(object=’’) -> str
`WAIT_AFTER_ODMS_PREPARE_REPLICATION_TARGET`	str(object=’’) -> str
`WAIT_AFTER_ODMS_SWITCHOVER`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_ESTIMATE_SRC`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SETTINGS`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SETTINGS_TGT`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SRC`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_GG_HUB`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_PREMIGRATION_ADVISOR`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_SRC`	str(object=’’) -> str
`WAIT_AFTER_ODMS_VALIDATE_TGT`	str(object=’’) -> str
`advisor_settings`	Gets the advisor_settings of this MySqlMigration.
`compartment_id`	[Required] Gets the compartment_id of this Migration.
`data_transfer_medium_details`	Gets the data_transfer_medium_details of this MySqlMigration.
`database_combination`	[Required] Gets the database_combination of this Migration.
`defined_tags`	Gets the defined_tags of this Migration.
`description`	Gets the description of this Migration.
`display_name`	[Required] Gets the display_name of this Migration.
`executing_job_id`	Gets the executing_job_id of this Migration.
`freeform_tags`	Gets the freeform_tags of this Migration.
`ggs_details`	Gets the ggs_details of this MySqlMigration.
`hub_details`	Gets the hub_details of this MySqlMigration.
`id`	[Required] Gets the id of this Migration.
`initial_load_settings`	Gets the initial_load_settings of this MySqlMigration.
`lifecycle_details`	Gets the lifecycle_details of this Migration.
`lifecycle_state`	[Required] Gets the lifecycle_state of this Migration.
`source_database_connection_id`	[Required] Gets the source_database_connection_id of this Migration.
`system_tags`	Gets the system_tags of this Migration.
`target_database_connection_id`	[Required] Gets the target_database_connection_id of this Migration.
`time_created`	[Required] Gets the time_created of this Migration.
`time_last_migration`	Gets the time_last_migration of this Migration.
`time_updated`	Gets the time_updated of this Migration.
`type`	[Required] Gets the type of this Migration.
`wait_after`	Gets the wait_after of this Migration.

Methods

`__init__`(**kwargs)	Initializes a new MySqlMigration object with values from keyword arguments.
`get_subtype`(object_dictionary)	Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

DATABASE_COMBINATION_MYSQL = 'MYSQL'¶

DATABASE_COMBINATION_ORACLE = 'ORACLE'¶

LIFECYCLE_DETAILS_ABORTING = 'ABORTING'¶

LIFECYCLE_DETAILS_DONE = 'DONE'¶

LIFECYCLE_DETAILS_MIGRATING = 'MIGRATING'¶

LIFECYCLE_DETAILS_READY = 'READY'¶

LIFECYCLE_DETAILS_VALIDATED = 'VALIDATED'¶

LIFECYCLE_DETAILS_VALIDATING = 'VALIDATING'¶

LIFECYCLE_DETAILS_WAITING = 'WAITING'¶

LIFECYCLE_STATE_ACCEPTED = 'ACCEPTED'¶

LIFECYCLE_STATE_ACTIVE = 'ACTIVE'¶

LIFECYCLE_STATE_CANCELED = 'CANCELED'¶

LIFECYCLE_STATE_CREATING = 'CREATING'¶

LIFECYCLE_STATE_DELETED = 'DELETED'¶

LIFECYCLE_STATE_DELETING = 'DELETING'¶

LIFECYCLE_STATE_FAILED = 'FAILED'¶

LIFECYCLE_STATE_INACTIVE = 'INACTIVE'¶

LIFECYCLE_STATE_IN_PROGRESS = 'IN_PROGRESS'¶

LIFECYCLE_STATE_NEEDS_ATTENTION = 'NEEDS_ATTENTION'¶

LIFECYCLE_STATE_SUCCEEDED = 'SUCCEEDED'¶

LIFECYCLE_STATE_UPDATING = 'UPDATING'¶

LIFECYCLE_STATE_WAITING = 'WAITING'¶

TYPE_OFFLINE = 'OFFLINE'¶

TYPE_ONLINE = 'ONLINE'¶

WAIT_AFTER_ODMS_CLEANUP = 'ODMS_CLEANUP'¶

WAIT_AFTER_ODMS_DATA_UPLOAD = 'ODMS_DATA_UPLOAD'¶

WAIT_AFTER_ODMS_FETCH_METADATA_SRC = 'ODMS_FETCH_METADATA_SRC'¶

WAIT_AFTER_ODMS_FETCH_METADATA_TGT = 'ODMS_FETCH_METADATA_TGT'¶

WAIT_AFTER_ODMS_INITIALIZE_REPLICATION_INFRASTRUCTURE = 'ODMS_INITIALIZE_REPLICATION_INFRASTRUCTURE'¶

WAIT_AFTER_ODMS_INITIAL_LOAD_EXPORT = 'ODMS_INITIAL_LOAD_EXPORT'¶

WAIT_AFTER_ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD = 'ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD'¶

WAIT_AFTER_ODMS_INITIAL_LOAD_IMPORT = 'ODMS_INITIAL_LOAD_IMPORT'¶

WAIT_AFTER_ODMS_MONITOR_REPLICATION_LAG = 'ODMS_MONITOR_REPLICATION_LAG'¶

WAIT_AFTER_ODMS_POST_INITIAL_LOAD = 'ODMS_POST_INITIAL_LOAD'¶

WAIT_AFTER_ODMS_PREPARE = 'ODMS_PREPARE'¶

WAIT_AFTER_ODMS_PREPARE_REPLICATION_TARGET = 'ODMS_PREPARE_REPLICATION_TARGET'¶

WAIT_AFTER_ODMS_SWITCHOVER = 'ODMS_SWITCHOVER'¶

WAIT_AFTER_ODMS_VALIDATE = 'ODMS_VALIDATE'¶

WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_ESTIMATE_SRC = 'ODMS_VALIDATE_DATAPUMP_ESTIMATE_SRC'¶

WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SETTINGS = 'ODMS_VALIDATE_DATAPUMP_SETTINGS'¶

WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC = 'ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC'¶

WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SETTINGS_TGT = 'ODMS_VALIDATE_DATAPUMP_SETTINGS_TGT'¶

WAIT_AFTER_ODMS_VALIDATE_DATAPUMP_SRC = 'ODMS_VALIDATE_DATAPUMP_SRC'¶

WAIT_AFTER_ODMS_VALIDATE_GG_HUB = 'ODMS_VALIDATE_GG_HUB'¶

WAIT_AFTER_ODMS_VALIDATE_PREMIGRATION_ADVISOR = 'ODMS_VALIDATE_PREMIGRATION_ADVISOR'¶

WAIT_AFTER_ODMS_VALIDATE_SRC = 'ODMS_VALIDATE_SRC'¶

WAIT_AFTER_ODMS_VALIDATE_TGT = 'ODMS_VALIDATE_TGT'¶

__init__(**kwargs)¶

Initializes a new MySqlMigration object with values from keyword arguments. The default value of the database_combination attribute of this class is MYSQL and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

id (str) – The value to assign to the id property of this MySqlMigration.
description (str) – The value to assign to the description property of this MySqlMigration.
database_combination (str) – The value to assign to the database_combination property of this MySqlMigration. Allowed values for this property are: “MYSQL”, “ORACLE”
display_name (str) – The value to assign to the display_name property of this MySqlMigration.
compartment_id (str) – The value to assign to the compartment_id property of this MySqlMigration.
type (str) – The value to assign to the type property of this MySqlMigration. Allowed values for this property are: “ONLINE”, “OFFLINE”
wait_after (str) – The value to assign to the wait_after property of this MySqlMigration. Allowed values for this property are: “ODMS_VALIDATE_TGT”, “ODMS_VALIDATE_SRC”, “ODMS_VALIDATE_PREMIGRATION_ADVISOR”, “ODMS_VALIDATE_GG_HUB”, “ODMS_VALIDATE_DATAPUMP_SETTINGS”, “ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC”, “ODMS_VALIDATE_DATAPUMP_SETTINGS_TGT”, “ODMS_VALIDATE_DATAPUMP_SRC”, “ODMS_VALIDATE_DATAPUMP_ESTIMATE_SRC”, “ODMS_FETCH_METADATA_SRC”, “ODMS_FETCH_METADATA_TGT”, “ODMS_VALIDATE”, “ODMS_PREPARE”, “ODMS_INITIALIZE_REPLICATION_INFRASTRUCTURE”, “ODMS_INITIAL_LOAD_EXPORT”, “ODMS_DATA_UPLOAD”, “ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD”, “ODMS_INITIAL_LOAD_IMPORT”, “ODMS_POST_INITIAL_LOAD”, “ODMS_PREPARE_REPLICATION_TARGET”, “ODMS_MONITOR_REPLICATION_LAG”, “ODMS_SWITCHOVER”, “ODMS_CLEANUP”
source_database_connection_id (str) – The value to assign to the source_database_connection_id property of this MySqlMigration.
target_database_connection_id (str) – The value to assign to the target_database_connection_id property of this MySqlMigration.
executing_job_id (str) – The value to assign to the executing_job_id property of this MySqlMigration.
time_created (datetime) – The value to assign to the time_created property of this MySqlMigration.
time_updated (datetime) – The value to assign to the time_updated property of this MySqlMigration.
time_last_migration (datetime) – The value to assign to the time_last_migration property of this MySqlMigration.
lifecycle_state (str) – The value to assign to the lifecycle_state property of this MySqlMigration. Allowed values for this property are: “CREATING”, “UPDATING”, “ACTIVE”, “IN_PROGRESS”, “ACCEPTED”, “SUCCEEDED”, “CANCELED”, “WAITING”, “NEEDS_ATTENTION”, “INACTIVE”, “DELETING”, “DELETED”, “FAILED”
lifecycle_details (str) – The value to assign to the lifecycle_details property of this MySqlMigration. Allowed values for this property are: “READY”, “ABORTING”, “VALIDATING”, “VALIDATED”, “WAITING”, “MIGRATING”, “DONE”
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this MySqlMigration.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this MySqlMigration.
system_tags (dict(str, dict(str, object))) – The value to assign to the system_tags property of this MySqlMigration.
data_transfer_medium_details (oci.database_migration.models.MySqlDataTransferMediumDetails) – The value to assign to the data_transfer_medium_details property of this MySqlMigration.
initial_load_settings (oci.database_migration.models.MySqlInitialLoadSettings) – The value to assign to the initial_load_settings property of this MySqlMigration.
advisor_settings (oci.database_migration.models.MySqlAdvisorSettings) – The value to assign to the advisor_settings property of this MySqlMigration.
hub_details (oci.database_migration.models.GoldenGateHubDetails) – The value to assign to the hub_details property of this MySqlMigration.
ggs_details (oci.database_migration.models.MySqlGgsDeploymentDetails) – The value to assign to the ggs_details property of this MySqlMigration.

advisor_settings¶

Gets the advisor_settings of this MySqlMigration.

Returns:	The advisor_settings of this MySqlMigration.
Return type:	oci.database_migration.models.MySqlAdvisorSettings

compartment_id¶

[Required] Gets the compartment_id of this Migration. The OCID of the resource being referenced.

Returns:	The compartment_id of this Migration.
Return type:	str

data_transfer_medium_details¶

Gets the data_transfer_medium_details of this MySqlMigration.

Returns:	The data_transfer_medium_details of this MySqlMigration.
Return type:	oci.database_migration.models.MySqlDataTransferMediumDetails

database_combination¶

[Required] Gets the database_combination of this Migration. The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.

Allowed values for this property are: “MYSQL”, “ORACLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The database_combination of this Migration.
Return type:	str

defined_tags¶

Gets the defined_tags of this Migration. Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {“foo-namespace”: {“bar-key”: “value”}}

Returns:	The defined_tags of this Migration.
Return type:	dict(str, dict(str, object))

description¶

Gets the description of this Migration. A user-friendly description. Does not have to be unique, and it’s changeable. Avoid entering confidential information.

Returns:	The description of this Migration.
Return type:	str

display_name¶

[Required] Gets the display_name of this Migration. A user-friendly name. Does not have to be unique, and it’s changeable. Avoid entering confidential information.

Returns:	The display_name of this Migration.
Return type:	str

executing_job_id¶

Gets the executing_job_id of this Migration. The OCID of the resource being referenced.

Returns:	The executing_job_id of this Migration.
Return type:	str

freeform_tags¶

Gets the freeform_tags of this Migration. Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}

Returns:	The freeform_tags of this Migration.
Return type:	dict(str, str)

static get_subtype(object_dictionary)¶: Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

ggs_details¶

Gets the ggs_details of this MySqlMigration.

Returns:	The ggs_details of this MySqlMigration.
Return type:	oci.database_migration.models.MySqlGgsDeploymentDetails

hub_details¶

Gets the hub_details of this MySqlMigration.

Returns:	The hub_details of this MySqlMigration.
Return type:	oci.database_migration.models.GoldenGateHubDetails

id¶

[Required] Gets the id of this Migration. The OCID of the resource being referenced.

Returns:	The id of this Migration.
Return type:	str

initial_load_settings¶

Gets the initial_load_settings of this MySqlMigration.

Returns:	The initial_load_settings of this MySqlMigration.
Return type:	oci.database_migration.models.MySqlInitialLoadSettings

lifecycle_details¶

Gets the lifecycle_details of this Migration. Additional status related to the execution and current state of the Migration.

Allowed values for this property are: “READY”, “ABORTING”, “VALIDATING”, “VALIDATED”, “WAITING”, “MIGRATING”, “DONE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The lifecycle_details of this Migration.
Return type:	str

lifecycle_state¶

[Required] Gets the lifecycle_state of this Migration. The current state of the Migration resource.

Allowed values for this property are: “CREATING”, “UPDATING”, “ACTIVE”, “IN_PROGRESS”, “ACCEPTED”, “SUCCEEDED”, “CANCELED”, “WAITING”, “NEEDS_ATTENTION”, “INACTIVE”, “DELETING”, “DELETED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The lifecycle_state of this Migration.
Return type:	str

source_database_connection_id¶

[Required] Gets the source_database_connection_id of this Migration. The OCID of the resource being referenced.

Returns:	The source_database_connection_id of this Migration.
Return type:	str

system_tags¶

Gets the system_tags of this Migration. Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {“orcl-cloud”: {“free-tier-retained”: “true”}}

Returns:	The system_tags of this Migration.
Return type:	dict(str, dict(str, object))

target_database_connection_id¶

[Required] Gets the target_database_connection_id of this Migration. The OCID of the resource being referenced.

Returns:	The target_database_connection_id of this Migration.
Return type:	str

time_created¶

[Required] Gets the time_created of this Migration. An RFC3339 formatted datetime string such as 2016-08-25T21:10:29.600Z.

Returns:	The time_created of this Migration.
Return type:	datetime

time_last_migration¶

Gets the time_last_migration of this Migration. An RFC3339 formatted datetime string such as 2016-08-25T21:10:29.600Z.

Returns:	The time_last_migration of this Migration.
Return type:	datetime

time_updated¶

Gets the time_updated of this Migration. An RFC3339 formatted datetime string such as 2016-08-25T21:10:29.600Z.

Returns:	The time_updated of this Migration.
Return type:	datetime

type¶

[Required] Gets the type of this Migration. The type of the migration to be performed. Example: ONLINE if no downtime is preferred for a migration. This method uses Oracle GoldenGate for replication.

Allowed values for this property are: “ONLINE”, “OFFLINE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The type of this Migration.
Return type:	str

wait_after¶

Gets the wait_after of this Migration. You can optionally pause a migration after a job phase. This property allows you to optionally specify the phase after which you can pause the migration.

Allowed values for this property are: “ODMS_VALIDATE_TGT”, “ODMS_VALIDATE_SRC”, “ODMS_VALIDATE_PREMIGRATION_ADVISOR”, “ODMS_VALIDATE_GG_HUB”, “ODMS_VALIDATE_DATAPUMP_SETTINGS”, “ODMS_VALIDATE_DATAPUMP_SETTINGS_SRC”, “ODMS_VALIDATE_DATAPUMP_SETTINGS_TGT”, “ODMS_VALIDATE_DATAPUMP_SRC”, “ODMS_VALIDATE_DATAPUMP_ESTIMATE_SRC”, “ODMS_FETCH_METADATA_SRC”, “ODMS_FETCH_METADATA_TGT”, “ODMS_VALIDATE”, “ODMS_PREPARE”, “ODMS_INITIALIZE_REPLICATION_INFRASTRUCTURE”, “ODMS_INITIAL_LOAD_EXPORT”, “ODMS_DATA_UPLOAD”, “ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD”, “ODMS_INITIAL_LOAD_IMPORT”, “ODMS_POST_INITIAL_LOAD”, “ODMS_PREPARE_REPLICATION_TARGET”, “ODMS_MONITOR_REPLICATION_LAG”, “ODMS_SWITCHOVER”, “ODMS_CLEANUP”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The wait_after of this Migration.
Return type:	str