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