Creating MySQL migrations

A migration resource is a definition of your migration containing all settings and parameters that are eventually used when performing a migration.

The following procedure explains how to migrate data from a MySQL source database to a MySQL target database, which contain the settings for running migration jobs with Database Migration. You can create multiple migration resources with different parameter settings to test different scenarios.

Creating a migration

  1. On the Migrations list page, select Create migration. If you need help finding the list page, see Listing migrations.

    This opens the Create migration page.

  2. Configure the following settings:

    • Name: Enter a unique name for the migration.

      On completion of the Create Migration page, the name you enter here is displayed in the list of migrations on the Migrations page.

    • Add an optional Description: for the migration resource.

    • Compartment: Select the compartment in which the Database Migration service is hosted.

  3. Select the Source database connection entry for your compartment.
  4. Select the Target database connection entry for your compartment.

    Note:

    Currently, OCI HeatWave service is supported as the target database. For a list of supported databases, see Creating MySQL connections.

  5. In the Migration options step, select the Object storage bucket in compartment: transfer medium for initial load option.

    If the bucket is in a different compartment, click Change Compartment to look in another compartment.

  6. If you want to create an online migration, check the Use online replication option to enable the replication of all data and metadata transactions from the source to the target database, committed after the initial load has begun. For additional optional configurations, see the Replication tab in the Advanced options. Optionally, you can set some additional properties which can affect the performance of your online migration.

    Note:

    Currently, for MySQL to MySQL migrations, Oracle Cloud Infrastructure Database Migration supports GoldenGate Service Integration for replication.

    Note:

    Skip this step for offline migrations.

  7. Optionally, select Advanced Options to configure advanced replication, validation, and Oracle GoldenGate settings. The Advanced Options section allows you to optionally create tags.

    For details about these settings see Selecting objects for MySQL migration, Configuring initial load advanced options for MySQL migrations, Configuring validation options, and Configuring optional replication advanced options.

  8. Click Create.

    The migration is loaded, and a new Migration Details page opens showing the information, metrics, and operations for the migration.

    The status of the creation operation is shown on top of the page along with the name of the migration. When the status is Active, you can run migration jobs with the migration.

    Alternatively click the Save as stack option to save the migrations as a stack.

    The Save as stack pane is displayed. You can save the migration resource configurations as a stack. Use the stack to install, configure, and manage the resource through the Resource Manager service.

    The following options are available:

    1. Name (Optional)
    2. Description (Optional)
    3. Save in your compartment
    4. Optionally, add Tags to organize your resources.
    5. Click Save to save as a stack.
    6. Click Cancel if you do not want to save the stack.

    After you save the Stack, it displays a link in the upper right corner that directs you to the newly created Stack in the Resource Manager. See the following topics for the next steps:

Parent topic: Create migrations