共享存储多Master集群数据库系统的全局向量CSN事务快照生成装置

By constructing a global vector CSN transaction snapshot generation device in a multi-Master cluster database system, the problem that CSN technology cannot be applied across nodes is solved, and snapshot isolation visibility checks in multi-Master clusters are realized, thereby improving the concurrent operation efficiency and transaction processing performance of the database system.

CN120950518BActive Publication Date: 2026-07-17BEIJING VASTDATA TECH

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
BEIJING VASTDATA TECH
Filing Date
2025-08-11
Publication Date
2026-07-17

AI Technical Summary

Technical Problem

The existing CSN technology of openGauss database is only applicable to single-machine database systems or master-slave database systems. It cannot be directly applied to shared storage multi-write and multi-read cluster database systems. It cannot uniformly describe the transaction commit order in a multi-master cluster environment across nodes, which makes it impossible to achieve snapshot isolation visibility checks in multi-master clusters.

Method used

By constructing a global vector CSN transaction snapshot generation device in a shared storage multi-Master cluster database system, and utilizing a multi-Master CSN generation module, a CSN BOC sending module, a CSN BOC receiving module, and a vector CSN snapshot generation module, a CSN sequence number with node identifier is generated. The global CSN vector is then broadcast and updated through an asynchronous network message mode to achieve visibility checks for the multi-Master cluster.

Benefits of technology

It implements global consistency snapshot isolation checks in multi-Master cluster database systems, improving the concurrent operation efficiency and transaction processing performance of the database system, and avoiding the performance loss of synchronous network I/O.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120950518B_ABST
    Figure CN120950518B_ABST
Patent Text Reader

Abstract

本申请涉及一种共享存储多Master集群数据库系统的全局向量CSN事务快照生成装置及方法。本装置包括:多Master CSN生成模块,用于事务提交时生成带节点标识的多Master集群模式CSN序号并绑定事务号至CSN LOG;CSN BOC发送模块,异步广播封装的事务号与CSN序号消息包至集群其他节点;CSN BOC接收模块,接收消息包后记录至本地CSN LOG并维护全局CSN向量(按节点编号存储各节点最新CSN);向量CSN快照生成模块,通过拷贝全局CSN向量并更新本节点CSN生成快照,用于数据行快照隔离可见性检查。本发明突破传统CSN单节点限制,解决了多Master集群跨节点事务顺序统一描述的难题,通过异步消息与内存操作避免同步网络IO损耗,显著提升了集群事务可见性检查效率及业务并发性能。
Need to check novelty before this filing date? Find Prior Art