Distributed database catalogue management method and system, electronic equipment and readable storage medium

Abstract

The invention relates to the technical field of computers, in particular to a distributed database cataloguing management method and system, electronic equipment and a readable storage medium, and themethod comprises the steps that a database agent sends updated cataloguing information to a cataloguing server, wherein the database agent is front middleware for accessing a database, and cataloguesof the database are stored in the database agent; the cataloguing server sends the received database cataloguing update to a cataloguing database; and the catalogue database receives the database catalogue update and updates the stored database catalogue. According to the technical scheme, the catalogued data of the distributed database can be maintained more flexibly, the method can be maintained on the basis of both the cataloguing server and the database proxy node, the fault-tolerant capability is higher, the timeliness and consistency of the catalogued data of the distributed database oneach node are guaranteed, and the reliability of the catalogued data of the distributed database is improved. The continuous availability of the distributed database under the hybrid online transaction type load is ensured.

Description

technical field [0001] The present application relates to the technical field of computer data processing, in particular to a distributed database catalog management method, system, electronic equipment and readable storage medium. Background technique [0002] In the distributed database architecture, in order to shield the complexity brought by sub-database and sub-table, applications usually do not directly access the distributed database, but access it through the database proxy (DBProxy). DBProxy is responsible for verifying and parsing SQL statement requests from applications, routing them to the correct database shards, assembling responses from one or more database shards, and returning them to the application. In a distributed database, in order to complete the verification, parsing, routing and assembly functions of SQL statements, the distributed database catalog (Database Catalog) is in an important position. It is used to describe the information of various obje...

AI Technical Summary

Problems solved by technology

The catalog server will become the bottleneck, so this method cannot meet the extremely high requirements of mixed online transactional load in terms of performance

[0004] The second management method is to store catalog data locally through files or databases on all DBProxy nodes, and store persistently on the catalog server through the database at the same time, and realize the consistency of catalog data between DBProxy nodes and catalog servers through the trigger-broadcast mechanism. In this mechanism, during the synchronization process between the catalog server and the DBProxy node, the catalog data can only be based on the catalog server, and DBProxy is not supported.

Images