Unlock instant, AI-driven research and patent intelligence for your innovation.

Transaction monitoring method, device and system for distributed database and storage medium

A monitoring system and database technology, which is applied to the transaction monitoring of distributed databases and the fields of devices, systems, and storage media, can solve the problems that data nodes cannot meet the operation, maintenance and management requirements of distributed databases, and achieve the effect of improving operation and maintenance efficiency.

Pending Publication Date: 2020-12-22
金篆信科有限责任公司
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, for a large-scale distributed database system where the business end, computing nodes, and data nodes are separated, the separate monitoring of data nodes cannot meet the requirements of distributed database operation and maintenance and management.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Transaction monitoring method, device and system for distributed database and storage medium
  • Transaction monitoring method, device and system for distributed database and storage medium
  • Transaction monitoring method, device and system for distributed database and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0080] This embodiment provides an implementation solution for deadlock transaction analysis. In the deadlock transaction analysis, the business source of the transaction is traced through the TSN information associated with the transaction, which effectively improves the operation and maintenance efficiency of the distributed database. Technical implementation flow chart such as Figure 6 As shown, the specific description is as follows:

[0081] Step 601, the business end initiates transaction 1, and the first statement at the beginning of transaction 1 carries transaction serial number information TSN1;

[0082] Step 602, the business end initiates transaction 2, and the first statement at the beginning of transaction 2 carries transaction serial number information TSN2;

[0083] Step 603, computing nodes distribute transactions;

[0084] Step 604, link 1 in data node 1 processes the request of transaction 1, and records TSN1;

[0085] Step 605, link 2 in data node 1 pr...

Embodiment 2

[0096] This embodiment provides an implementation solution for distributed transaction exception handling. In this embodiment, the method of recording transaction indication information by data node transaction is adopted, and the distributed transaction exception processing is performed through the GTID information associated with the transaction, which greatly simplifies the process of distributed transaction exception processing. Technical implementation flow chart such as Figure 7 As shown, the specific description is as follows:

[0097] Step 701, the business end initiates a distributed transaction 1;

[0098] Step 702, the computing node receives the request of the distributed transaction 1, first assigns the global transaction ID (GTID), and then distributes the statement of the transaction 1 to multiple data nodes of the distributed database for execution according to the distribution rules of the distributed transaction;

[0099] Step 703, data node 1 executes tra...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a transaction monitoring method, device and system for a distributed database and a storage medium, and the method comprises the steps: recording transaction indication information carried in an execution request of a transaction after the execution request of the transaction is received; and performing transaction monitoring according to the transaction indication information. According to the scheme provided by the embodiment of the invention, the transaction indication information is recorded, the transaction is conveniently positioned through the transaction indication information, the operation and maintenance means of the distributed database are enhanced, and the operation and maintenance efficiency of the distributed database can be effectively improved.

Description

technical field [0001] Embodiments of the present invention relate to, but are not limited to, a transaction monitoring method, device, system, and storage medium of a distributed database. Background technique [0002] Distributed database has become a key direction of database development. The overall architecture of distributed database GoldenDB is as follows: figure 1 shown, combined with figure 1 Described as follows: [0003] The business end is the client access layer, which is composed of multiple application APPs and supports common ODBC (Open Database Connectivity, open database connection) and JDBC (Java DataBase Connectivity, java database connection) interfaces. Users use the distributed database; [0004] The computing node cluster is composed of multiple middleware DBProxy (DB proxy nodes), and the basic processing and distribution of SQL statements are completed in the computing nodes; [0005] The management node includes multiple components, such as OMM...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F11/30G06F16/27
CPCG06F11/302G06F16/27G06F16/23G06F2201/80G06F11/3006G06F11/3065G06F2201/865G06F11/079G06F11/3476G06F16/2379
Inventor 周亚运林品丁岩刘志文
Owner 金篆信科有限责任公司