Database hot standby data synchronization method, system and device and medium
A dual-machine hot backup and data synchronization technology, which is applied in database update, database distribution/replication, redundant data error detection in computing, etc., can solve the inconsistency of master and backup data, violation of the basic principles of dual-machine hot backup, etc. problems, to achieve the effect of ensuring high availability, solving synchronization exceptions, and improving service processing performance
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0048] Such as figure 1 As shown, a dual-machine hot standby data synchronization method for a database is used to synchronize the main service and the standby service, and perform data synchronization from the perspective of the main service, including the following steps:
[0049] S101. Obtain an SQL statement for operating the primary service, and determine whether the working status of the standby service is normal;
[0050] In step S101, after the main service receives the business request from the client, it operates the database, and the process of obtaining the SQL statement for operating the main service is as follows:
[0051] receiving a business request, and generating an SQL statement according to the business request;
[0052] Operating the database corresponding to the main service according to the SQL statement;
[0053] When the operation is successful, the SQL statement is obtained from the database corresponding to the main service.
[0054] It should be ...
Embodiment 2
[0089] Such as image 3 As shown, in the embodiment of the present invention, a method for synchronizing data in dual-machine hot backup of a database of a database is used to synchronize the main service and the backup service, and perform data synchronization from the perspective of the backup service, including the following steps:
[0090] S301. Determine whether the working state of the standby service is normal;
[0091]It should be noted that whether the working status of the standby service mentioned in this embodiment is normal refers to whether the TCP network communication connection between the standby service and the main service is normal. When communicating normally, it means that the working status of the standby service is normal. If it is judged that the TCP network communication connection between the standby service and the main service is abnormal or the standby service itself is abnormal, it means that the working status of the standby service is abnormal...
Embodiment 3
[0110] The embodiment of the present invention also provides an electronic device, including: a processor (processor), a communication interface (Communication Interface), a memory (memory) and a communication bus, wherein the processor, the communication interface, and the memory complete the mutual communication through the communication bus communication. The processor can execute the computer program in the memory, so as to realize the steps of a method for synchronizing data in dual-machine hot standby of the database.
[0111] In addition, the above logic instructions in the memory can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on this understanding, the essence of the technical solution of the present invention or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, and the ...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More