Mysql writing method, device, equipment and medium based on multi-active instance
A technology for writing and writing operations, applied in the field of data processing, can solve problems such as system failure and deadlock, and achieve the effect of solving deadlock problems and reducing matching time
Active Publication Date: 2021-10-08
深圳华锐分布式技术股份有限公司
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, during the running process, if the instance needs to read and write MySQL, because the working mode and content of each instance are exactly the same, there is a high probability that deadlock will occur
Once a deadlock occurs, the system cannot operate normally.
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0045] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0046] like figure 1 Shown is a flow chart of a preferred embodiment of the multi-active instance-based MySQL writing method of the present invention. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.
[0047] The multi-active instance-based MySQL writing method is applied to one or more computer devices, and the computer device is a device that can automatically perform numerical calculation and / or information processing according to preset or stored instructions, Its hardware includes but is not limited to microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASIC), programmable gate arrays (Field-Programmable Gate Array, FPGA...
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
Login to View More Abstract
The present invention relates to the field of data processing, and provides a MySQL writing method, device, equipment and medium based on a multi-active instance, capable of selecting an initial row lock with a target row identifier and a target row version number from a database table to be written into MySQL , and use the multi-active instance to compete for the initial row lock. When it is detected that the initial row lock is grabbed, the matching time is reduced by resetting the target row version number, and the target row lock is obtained by releasing the row lock, so that the initial row lock can be is used, use the multi-active instance to compete for the target row lock, obtain the row version number of the target instance that grabs the row lock, and compare the row version number of the target instance with the target row version number, when the target instance's When the row version number is the same as the target row version number, use the target instance to execute the write operation in the MySQL to be written, thereby solving the deadlock problem during the execution of the multi-active instance and ensuring that the MySQL database can be normal data input.
Description
technical field [0001] The present invention relates to the technical field of data processing, in particular to a MySQL writing method, device, equipment and media based on multi-active instances. Background technique [0002] In a distributed system, the use of multi-active instances can ensure high reliability of the system. [0003] However, during the running process, if the instance needs to read and write MySQL, because the working mode and content of each instance are exactly the same, there is a high probability that deadlock will occur. Once a deadlock occurs, the system cannot operate normally. [0004] Therefore, how to avoid the deadlock phenomenon during the running of the multi-active instance has become an urgent problem to be solved. Contents of the invention [0005] In view of the above, it is necessary to provide a MySQL writing method, device, equipment and media based on multi-active instances, which can solve the deadlock problem during the executi...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/28G06F16/25
CPCG06F16/2282G06F16/25G06F16/284
Inventor 陆朝铨李秋军陈波刘铮张峰赵楠
Owner 深圳华锐分布式技术股份有限公司