DDL logic replication method and system for OpenGauss database

The invention relates to the technical field of database management, and provides a DDL logic replication method and system for an OpenGauss database, and the method comprises the steps: writing a DDL log into a WAL log of a publishing end in the process of creating, publishing and executing a DDL operation at the publishing end; the DDL log written in the WAL log is decoded and read in the subscribing and publishing process of the subscribing end; and changing and modifying the corresponding data table by applying the DDL log read by decoding. According to the DDL logic replication method and system for the OpenGauss database, logic replication abnormity caused by DDL operation can be avoided, user intervention is not needed, manual maintenance on a table in the logic replication process is reduced, the management cost of a user is reduced, and operation is easy and convenient. 本发明涉及数据库管理技术领域，提供一种用于OpenGauss数据库的DDL逻辑复制方法和系统，本发明的方法包括：在发布端创建发布和执行DDL操作的过程中，将DDL日志写入发布端的WAL日志中；在订阅端订阅发布的过程中对写入WAL日志中的DDL日志解码读取；通过应用