Application layer fault tolerance method and system in mysql active/standby mode

An active-standby mode and application layer technology, applied in the field of database disaster recovery, can solve problems such as data inconsistency, and achieve the effect of ensuring basic availability, improving availability, and simple logic

Pending Publication Date: 2022-07-29
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The technical task of the present invention is to provide an application layer fault-tolerant method and system under the mysql master-standby mode to solve the problem of data inconsistency that may be caused by the mysql master-standby synchronization mechanism

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
  • Application layer fault tolerance method and system in mysql active/standby mode
  • Application layer fault tolerance method and system in mysql active/standby mode
  • Application layer fault tolerance method and system in mysql active/standby mode

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0066] as attached figure 1 As shown, the fault-tolerant method of the application layer in the MySQL active-standby mode of the present invention is as follows:

[0067] S1. Deploy the application layer database;

[0068] S2. Deploy unsynchronized data access control system database tables;

[0069] S3. The application layer logs in to the unsynchronized data access control system;

[0070] S4, the application layer writes the business table.

[0071] The details of deploying the application layer database in step S1 of this embodiment are as follows:

[0072] S101. Enable the mysql active-standby asynchronous replication mode;

[0073] S102. Add a pre-written version number field to the business table, and the pre-written version number is used to write the return value of the unsynchronized database access control system, as shown in the following table:

[0074] primary key field 1 Field 2… Prewritten version number

[0075] The fields of the unsy...

Embodiment 2

[0110] This embodiment provides an application-layer fault-tolerant system in MySQL active-standby mode, and the system includes:

[0111] Deployment module 1, used to deploy the application layer database;

[0112] The second deployment module is used to deploy the unsynchronized data access control system database table;

[0113] The login module is used to log in to the unsynchronized data access control system at the application layer;

[0114] The writing module is used to write business tables at the application layer.

Embodiment 3

[0116] This embodiment also provides an electronic device, including: a memory and a processor;

[0117] Wherein, the memory stores computer execution instructions;

[0118] The processor executes the computer-executed instructions stored in the memory, so that the processor executes the application layer fault tolerance method in the active-standby mode of mysql according to any embodiment of the present invention.

[0119] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), off-the-shelf programmable gate arrays (FPGAs), or other programmable logic devices, Discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or the processor may be any conventional processor or the like.

[0120] The memory can be used to store computer programs and / or modules, and the processor implements various function...

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 an application layer fault tolerance method and system in a mysql main-standby mode, belongs to the technical field of database disaster tolerance, and aims to solve the technical problem of data inconsistency possibly caused by a mysql main-standby synchronization mechanism. The adopted technical scheme is as follows: the method specifically comprises the following steps: deploying an application layer database; deploying an unsynchronized data access control system database table; the application layer logs in the unsynchronized data access control system; and the application layer writes the service table. The system comprises a deployment module I, a deployment module II, a login module and a writing module, and is used for writing a service table in an application layer.

Description

technical field [0001] The invention relates to the technical field of database disaster tolerance, in particular to an application layer fault tolerance method and system in a MySQL active-standby mode. Background technique [0002] With the rapid development of Internet information technology, the amount of data continues to increase, the business logic is also increasingly complex, and there are more and more scenarios of high concurrent access to the system and massive data processing. How to achieve the goals of high availability, easy scalability, and scalability of the system at a lower cost becomes more and more important. In order to solve these series of problems, the system architecture is also constantly evolving. Traditional centralized systems have gradually been unable to meet the requirements, and distributed systems are used in more scenarios. [0003] The requirements for system availability and data reliability determine that the underlying database need...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F16/23G06F16/25G06F16/27G06F16/28G06F21/44G06F21/62
CPCG06F11/1448G06F16/27G06F16/284G06F16/25G06F16/2365G06F21/44G06F21/6218G06F2221/2141G06F21/1078
Inventor 李建伟杨镇铭田昌英安晓博
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap