Logical Replication

Availability

This feature is available since openGauss 1.0.0.

Introduction

openGauss provides the logical decoding function to reversely parse physical logs to logical logs. Logical replication tools such as DRS convert logical logs to SQL statements and replay the SQL statements in the peer database. In this way, data can be synchronized between heterogeneous databases. Currently, unidirectional and bidirectional logical replication between openGauss and the MySQL or Oracle database is supported.

Benefits

Logical replication is applicable to real-time database data migration, dual-database active-active system, and rolling upgrades.

Description

DNs reversely parse physical logs to logical logs. Logical replication tools such as DRS extract logical logs from DNs, convert the logs to SQL statements, and replay the SQL statements in MySQL. Logical replication tools also extract logical logs from the MySQL database, reversely parse the logs to SQL statements, and replay the SQL statements in openGauss. In this way, data can be synchronized between heterogeneous databases.

Enhancements

  • openGauss logic decoding supports the extraction of logs from full and incremental logs.
  • openGauss supports logical decoding on a standby node.

Constraints

Column-store replication and DDL replication are not supported.

Dependencies

It depends on logical replication tools that decode logical logs.

Feedback
编组 3备份
    openGauss 2024-04-22 00:47:24
    cancel