Skip to main content

Periodic Full Replication

NineData periodic full replication lets you copy selected source data to the target on a recurring schedule.

Overview​

Use periodic full replication to refresh a target at a fixed interval, such as daily, hourly, or every ten minutes. Each run copies the selected source objects and applies the target-side processing strategy you configure.

Before you begin​

  • Add the source and target data sources to NineData. For details, see Add Data Source.
  • Make sure the target replication link supports full replication. For supported links, see Data Replication.

Procedure​

This guide uses a MySQL to MySQL replication link as the example.

  1. Sign in to the NineData Console.

  2. In the navigation menu, click Replication > Data Replication.

  3. On the Replication page, click Create Replication.

  4. On the Source & Target tab, configure the fields in the table, and then click Next.

    Parameter
    		Description
    NameEnter a meaningful task name. Up to 64 characters are supported.
    SourceSelect the source data source that contains the objects to copy.
    TargetSelect the target data source that receives the copied objects.
    Replication ModeSelect Uni-directional.
    TypeSelect Schema and Full, then turn on the toggle to the right of Full to enable periodic full replication.
    Note: Periodic full replication cannot run with Incremental, so do not select Incremental.
    FrequencySelect how often periodic full replication runs. Supported values are Once a Day, Every Hour, and Every 10 minutes. Choose the frequency that matches your business needs.
    Launch TimeChoose the start time and time zone for periodic full replication.
    Data Processing StrategyChoose the target-side processing strategy before each full replication starts.
    • Drop Table, Recreate, and Rewrite Data (optional when Schema is selected): Delete the target table objects in the target data source, then rebuild the table and write data from the source table structure.
    • Clear Existing Data and Rewrite (optional when Schema is not selected): Clear all data in the target table in the target data source, then write the source data again.
    • Ignore Existing Data and Overwrite: Overwrite the target table data directly with the source table data.

  5. On the Objects tab, configure the following fields, and then click Next.

    Parameter
    		Description
    Replication ObjectsSelect the objects to copy. Select All Objects to copy all objects in the source database, or select Customized Object, choose objects in the Source Object list, and click > to move them to the Target Object list.
    Blacklist (optional)Click Add to add a blacklist rule. Use it to exclude databases or objects from replication. When Customized Object or Full Instance replication is selected, exclude specific databases or objects.
    • Left dropdown: Select the database to add to the blacklist.
    • Right dropdown: Select one or more objects in the selected database. Leave this field empty to add the entire database to the blacklist.
    To exclude multiple databases, click Add again to add more rows.

  6. On the Mapping tab, choose the action that matches the selected replication type.

  • If Schema is selected: Configure the target table names after synchronization, and then click Save and Pre-Check.

    tip

    Click Mapping & Filtering to customize target column names after synchronization. Set Data Filter so that only data that matches the filter is synchronized to the target data source. For example, if the test table is employees and the filter condition is emp_no>=10005, rows whose emp_no value is less than 10005 are not synchronized.

  • If "Schema" is not selected: NineData selects the database with the same name in the target data source by default. If the database does not exist, select the target database manually. The table and column names in the target database must match the synchronized objects. If they do not match, map them manually.

  1. On the Pre-check tab, wait for NineData to complete the precheck. After the precheck passes, click Launch.

    tip
    • Select Enable data consistency comparison to start a data consistency comparison after the synchronization task completes. The start time of Enable data consistency comparison depends on the selected Type:
      • Schema: Starts after structure replication completes.
      • Schema + Full, Full: Starts after full replication completes.
    • If the precheck fails, click Details for the failed check item, review the cause, fix it, and click Check Again to run the precheck again.
    • For check items whose Result is Warning, fix the issue or ignore the warning when appropriate.

  2. On the Launch page, after Launch Successfully appears, the synchronization task starts. Use these actions to review the task:

    • Click View Details to view each execution stage.
    • Click Back to list to return to the Replication task list page.

Result​

The task runs on the schedule and strategy you configured. Open the task details page to monitor each run and review its status.

Next steps​