Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Preferences
Contact Us
Feedback
AWS Documentation
Create an AWS Account

Using OCI MySQL Heatwave as a source for AWS DMS

PDF
RSS
Focus mode
Using OCI MySQL Heatwave as a source for AWS DMS - AWS Database Migration Service
Setting up OCI MySQL Heatwave for logical replication

With AWS DMS, you can use OCI MySQL Heatwave as a source in much the same way as you do MySQL. Using OCI MySQL Heatwave as a source requires a few additional configuration changes.

For information about versions of OCI MySQL Heatwave that AWS DMS supports as a source, see Sources for AWS DMS.

Setting up OCI MySQL Heatwave for logical replication

To configure your OCI MySQL Heatwave instance as a source endpoint for DMS, do the following:

  1. Sign in to OCI Console, and open the main hamburger menu (≡) in the top left corner.

  2. Choose Databases, DB Systems.

  3. Open the Configurations menu.

  4. Choose Create configuration.

  5. Enter a configuration name, such as dms_configuration.

  6. Choose the shape of your current OCI MySQL Heatwave instance. You can find the shape on the instance's DB system configuration properties tab under the DB system configuration:Shape section.

  7. In the User variables section, choose the binlog_row_value_options system variable. Its default value is PARTIAL_JSON. Clear the value.

  8. Choose the Create button.

  9. Open your OCI MySQLHeatwave instance, and choose the Edit button.

  10. In the Configuration section, choose the Change configuration button, and choose the shape configuration that you created in step 4.

  11. Once the changes take effect, your instance is ready for logical replication.

On this page

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.