OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.2.5

    Download PDF

    OceanBase logo

    The Unified Distributed Database for the AI Era.

    Follow Us
    Products
    OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
    Resources
    DocsBlogLive DemosTraining & Certification
    Company
    About OceanBaseTrust CenterLegalPartnerContact Us
    Follow Us

    © OceanBase 2026. All rights reserved

    Cloud Service AgreementPrivacy PolicySecurity
    Contact Us
    Document Feedback
    1. Documentation Center
    2. OceanBase Database
    3. SQL
    4. V4.2.5
    iconOceanBase Database
    SQL - V 4.2.5
    SQL
    KV
    • V 4.4.2
    • V 4.3.5
    • V 4.3.3
    • V 4.3.1
    • V 4.3.0
    • V 4.2.5
    • V 4.2.2
    • V 4.2.1
    • V 4.2.0
    • V 4.1.0
    • V 4.0.0
    • V 3.1.4 and earlier

    Overview

    Last Updated:2025-01-02 01:58:40  Updated
    share
    What is on this page
    Introduction to CDC
    obcdc
    oblogproxy
    oblogmsg

    folded

    share

    OceanBase Change Data Capture (CDC) helps you identify data that has changed since the last extraction. You can use the data to make history databases or perform near real-time caching. You can also provide the CDC data to message queues (MQs), so you can use MQs for analysis and auditing.

    Introduction to CDC

    OceanBase CDC has two components:

    • obcdc
    • oblogmsg

    obcdc is a fundamental component of OceanBase CDC. oblogproxy is derived from obcdc and obcdc depends on oblogmsg.

    obcdc

    obcdc provides incremental data of OceanBase Database in real time as a dynamic-link library.

    obcdc requests clogs, also known as redo logs, of each partition from OceanBase Database by using remote procedure calls (RPCs). It converts clogs to LogMsg data based on the table and column schemas that are obtained by querying OBServer nodes. After obcdc aggregates data changes of each partition involved in a transaction, it provides the changed data of the transaction to an external process row by row.

    obcdc application

    obcdc provides the incremental transaction data of OceanBase Database to external processes. Processes can call obcdc for data synchronization and subscription.

    • Data synchronization: Data from OceanBase Database is synchronized to other homogeneous or heterogeneous databases for purposes such as logical migration, logical backup, and logical upgrade.

    • Data subscription: Data from OceanBase Database is synchronized to message queues or data warehouses for purposes such as real-time computing, auditing, and monitoring.

    Deployment and use

    For more information about how to deploy and use obcdc, see Install and deploy obcdc and obcdc development instructions.

    oblogproxy

    As the proxy of obcdc, oblogproxy calls obcdc to obtain the incremental transaction data of OceanBase Database as a consumer.

    oblogproxy provides links for applications to access and manage real-time incremental logs of OceanBase Database.

    For more information about how to deploy and use oblogproxy, see Install and deploy oblogproxy by using the installation package and Build oblogproxy by using the source code.

    Note

    You can synchronize data from an OceanBase database to a MySQL database in real time by using Canal and oblogproxy. For more information, see Use Canal to synchronize data from OceanBase Database to a MySQL database.

    oblogmsg

    oblogmsg is a message format used by obcdc, the incremental data collection module of OceanBase Database, to export incremental data. oblogmsg supports writing incremental data of different types to OceanBase Database. It also supports data serialization and deserialization.

    For more information about how to install and deploy oblogmsg, see Install and deploy oblogmsg.

    Previous topic

    OBLogProxy
    Last

    Next topic

    Install and deploy OBCDC
    Next
    What is on this page
    Introduction to CDC
    obcdc
    oblogproxy
    oblogmsg