MySQL migration phases
A migration job in Oracle Cloud Infrastructure Database Migration runs in operational phases as a work flow.
The phases in Database Migration service are shown in the console with user-friendly names (DMS Phase), and in the REST API with the codes prefixed with "ODMS_", as shown in the table below.
Table 9-2 MySQL Validation/Evaluation Job Phases (offline and online)
| Phase NameConsole (API Codes) | Phase enum value | Description |
|---|---|---|
|
Validate source |
|
Validates the source database connectivity. |
| Validate target | ODMS_VALIDATE_TGT |
Validates target database connectivity |
| Validate source metadata | ODMS_FETCH_METADATA_SRC |
Validates source database basic configuration |
| Validate target metadata | ODMS_FETCH_METADATA_TGT |
Validates target database basic configuration |
| Run premigration advisor | ODMS_VALIDATE_PREMIGRATION_ADVISOR |
Runs MySQL Evaluator (Export/Import and GoldenGate checks) |
Table 9-3 MySQL Migration Job Phases (offline)
| Phase NameConsole (API Codes) | Phase enum value | Description |
|---|---|---|
|
Validate |
|
Validates the source and target database connectivity. |
| Export initial load and upload data | ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD |
Perform MySQL source dump to object storage. |
| Import initial load | ODMS_INITIAL_LOAD_IMPORT |
Perform MySQL target import from object storage |
| Validate target configuration | ODMS_FETCH_METADATA_TGT |
Validates target database basic configuration |
| Cleanup | ODMS_CLEANUP |
Cleanup temporary artifacts, object storage |
Table 9-4 MySQL Migration Job Phases (online GGS)
| Phase NameConsole (API Codes) | Phase enum value | Description |
|---|---|---|
|
Initialize replication infrastructure |
|
Setup GGS deployment, connections, networking |
| Validate | ODMS_VALIDATE |
validates source and target database connectivity. |
| Export initial load and upload data | ODMS_INITIAL_LOAD_EXPORT_DATA_UPLOAD |
Perform MySQL source dump to object storage |
| Import initial load | ODMS_INITIAL_LOAD_IMPORT |
Perform MySQL target import from object storage |
| Prepare | ODMS_PREPARE |
Setup GoldenGate replicat to apply to the target |
| Monitor replication lag | ODMS_MONITOR_REPLICATION_LAG |
Monitor GoldenGate replication lag. The replication lag needs to be a value equal or lower than the one defined when creating the migration before moving to the next phase. |
| Switchover | ODMS_SWITCHOVER |
Stop the replication based on the switchover logic. Extract and Replicat are monitored to ensure that there are no pending transactions. After confirmation, Extract and Replicat are stopped. |
| Cleanup | ODMS_CLEANUP |
Cleanup temporary artifacts, object storage |
Parent topic: Monitoring job status