Cross-Cluster Asynchronous Replication

Cross-cluster asynchronous replication allows data to be replicated automatically from a DolphinDB server (the master cluster) to one or more servers (slave clusters) for data consistency and offsite disaster recovery. DolphinDB’s cluster replication provides enhanced fault tolerance with convenient maintenance.

Compatibility

Currently, cluster replication is only supported on DFS databases. Operations regarding access control management, tiered storage and configuration for storage engines cannot be replicated.

The following table displays functions and DDL/DML operations supported in cluster replication:

Function

Operation Type

append / tableInsert

APPEND, APPEND_CHUNK_GRANULARITY

delete

SQL_DELETE

update

SQL_UPDATE

upsert!

UPSERT

dropTable

DROP_TABLE

dropPartition

DROP_PARTITION

dropDatabase

DROP_DB

addRangePartitions

ADD_RANGE_PARTITION

addValuePartitions

ADD_VALUE_PARTITION

database

CREATE_DOMAIN

create
createPartitionedTable
createTable

CREATE_TABLE
CREATE_PARTITIONED_TABLE

addColumn

ADD_COLUMN

dropColumns

DROP_COLUMN

renameTable

RENAME_TABLE

truncate

TRUNCATE_TABLE

replaceColumn

REPLACE_COLUMN

setColumnComment

SET_COLUMN_COMMENT

rename!

RENAME_COLUMN