Skip to main content

NineData Data Replication (Doris Documentation)

NineData Data Replication supports offline and real-time data replication between various homogeneous and heterogeneous data sources. It is suitable for various business scenarios such as data migration, database scaling, database version upgrades, disaster recovery, multi-live in different locations, data warehouse and data lake data integration.

For Doris data sources, NineData Data Replication supports the following replication links:

  • Doris ⇋ MySQL

  • Doris ⇋ Oracle

  • Doris ⇋ Doris

  • Doris ⇋ GaussDB

  • Doris ⇋ openGauss

  • Doris ⇋ PostgreSQL

  • Doris ⇋ ClickHouse

  • Doris ⇋ Greenplum

  • Doris ⇋ SelectDB

  • Doris ⇋ StarRocks

  • Doris ⇋ SingleStore

This article takes MySQL replication to Doris as an example to introduce task configuration methods.

Lightweight Deployment Options

If you are an enterprise developer or a small team, you can quickly achieve localized deployment through NineData Community Edition (permanently free). Based on Docker single-command installation, it meets the internal network development and testing needs of Apache Doris. For deployment methods, please refer to NineData Community Edition.

Prerequisites

A NineData platform account has been registered. If not registered, please visit the NineData Registration Page.

Step One: Add Doris and MySQL Data Sources

  1. Log in to the NineData Console, click on in the left navigation bar, and then click on on the page.

    image-20250312153427168

  2. In the pop-up data source type window, select > Doris and MySQL.

    image-20250312155600542

  3. On the data source configuration page, complete the configuration according to the following image.

    Doris

    image-20250312153626554

    MySQL

    image-20250312160403962

  4. Click on to the right of to test whether the data source can be accessed normally. If prompted with , you can click on to complete the addition of the data source.

Step Two: One-Minute Quick Configuration of Synchronization Task

Log in to the NineData Console, and you can easily complete the synchronization task configuration from MySQL to Doris according to the following image.

mysql2doris_step1

Step Three: Manage Synchronization Tasks

You can monitor various indicators of synchronization tasks in real-time, and you can also use the built-in data comparison function to automatically compare the data on both ends after synchronization to ensure data consistency.

NineData also supports replication throttling. If the replication task occupies too many read and write resources, you can limit the write rate to ensure the performance of online business.

  • View Task Details

    mysql2doris_result1

  • View Details of Each Replication Type

    mysql2doris_result2

  • View Data Comparison

    mysql2doris_result3

  • Configure Replication Throttling

    mysql2doris_result6

Step Four: Configure Task Alerts

By configuring task alerts, you can receive real-time notifications in case of task exceptions, so that you can handle them in a timely manner.

mysql2doris_result4

Step Five: Modify Synchronization Objects

You can modify the synchronization objects of the task at any time, supporting the addition and reduction of operations.

mysql2doris_result5

Please refer to the official documentation.