Universal database synchronization method

A database and data package technology, applied in the database field, can solve the problems of increasing user costs, unable to cope with increasing changes, and limiting database types, so as to reduce impact, realize data synchronization requirements, and reduce costs.

Pending Publication Date: 2020-06-26
三六零数字安全科技集团有限公司
0 Cites 0 Cited by

AI-Extracted Technical Summary

Problems solved by technology

This mode of operation not only limits the types of databases, but also greatly increases user ...
View more

Abstract

The invention discloses a universal database synchronization method. The method comprises the steps that a main server configures proxy shunt information, the terminal computer sends an operation request data packet; the proxy shunt intercepts an operation request data packet sent by the terminal computer; the main server receives an operation request data packet sent by the terminal computer andreplies an operation result data packet of an operation request of the terminal computer to the terminal computer, and the proxy shunt intercepts the operation result data packet replied by the main server and translates the database statements except the data query language into database statements meeting the database rule of the standby server, and sends the database statements to the standby server to finish synchronous updating of the database after confirming that the operation result data packet replied by the main server is normal. By means of the technical scheme, real-time synchronization of databases of the same type and databases of different types can be achieved, universality is very good, the cost is low, and the influence on a normal service system is greatly reduced.

Application Domain

Database updatingDatabase distribution/replication +1

Technology Topic

Data queryService system +7

Image

  • Universal database synchronization method
  • Universal database synchronization method

Examples

  • Experimental program(1)

Example Embodiment

[0026] Example
[0027] For example, there are 20 terminal computers in a local area network, terminal computers PC1, PC2,..., PC20, one main server (M-SERVER), one standby server (E-SERVER), and the operations issued by these 20 terminal computers The operation result of request and reply of the main server (M-SERVER) is monitored, and the update of the SQL Server database on the main server (M-SERVER) is synchronized to the MySQL database on the standby server (E-SERVER) in real time. The general purpose of the present invention The database synchronization method includes the following steps:
[0028] a. The main server configures proxy splitter information;
[0029] The proxy splitter information includes main service information and standby server information;
[0030] The main server information includes the IP address of the main server and the port of the database on the main server;
[0031] The backup server information includes the IP address of the backup server, the database type on the backup server, and the port of the database on the backup server;
[0032] Proxy shunt information configuration:
[0033] The IP address of the main server (M-SERVER) is 192.168.0.1, and the port of the database on the main server (M-SERVER) is 1433;
[0034] The IP address of the standby server (E-SERVER) is 192.168.0.2, the database type on the standby server (E-SERVER) is MySQL, and the database port on the standby server (E-SERVER) is 3306;
[0035] b. The terminal computer sends out the operation request data packet;
[0036] The terminal computer PC6 sends out an operation request data packet to modify the IP address of the machine;
[0037] c. The proxy splitter intercepts the operation request data packet sent by the terminal computer;
[0038] The proxy splitter intercepts the data packet of the operation request to modify the local IP address of the terminal computer PC6;
[0039] d. The main server receives the operation request data packet sent by the terminal computer, and replies the operation result data packet to the terminal computer;
[0040] The main server (M-SERVER) receives the operation request data packet for modifying the local IP address sent by the terminal computer PC6, updates the modified IP address to the SQL Server database, and replies the update result data package to the terminal computer PC6;
[0041] e. The proxy splitter monitors the operation result data packet replies from the main server in real time.
[0042] The proxy splitter monitors the operation result data packet replies from the main server (M-SERVER) in real time. The specific working steps are as follows:
[0043] e1. In this embodiment, the proxy splitter detects the operation result data packet of the successful IP address modification that the main server (M-SERVER) replies to the terminal computer PC6, and continues to perform step e2;
[0044] e2. The proxy splitter confirms that the main server (M-SERVER) has updated the SQL Server database on the main server (M-SERVER) according to the operation request of the terminal computer PC6 to modify the IP address of the machine, and the operation result is normal, continue to step e3;
[0045] e3. According to the normal operation result, the proxy splitter analyzes and intercepts the database language type in the operation request data packet sent by the terminal computer PC6 as a data manipulation language, and continues to perform step e4;
[0046] e4. The proxy splitter translates the data manipulation language of the SQL Server database in the operation request packet sent by the intercepted terminal computer PC6 into a database statement that meets the MySQL database rules on the standby server (E-SERVER), and sends it to the standby server (E-SERVER). SERVER), the standby server (E-SERVER) updates the MySQL database on the standby server (E-SERVER) according to the database statements translated by the proxy splitter and meets the MySQL database rules on the standby server (E-SERVER), and completes the connection with the primary server (M -SERVER) on the SQL Server database synchronization.
[0047] The method of the present invention configures the proxy splitter information on the main server. The proxy splitter intercepts the operation request data packet sent by the terminal computer in the local area network, and monitors the response result data packet of the operation request sent by the main server to the terminal computer in real time. After confirming whether the response result data packet of the main server is normal, analyze the operation request data packet sent by the intercepted terminal computer to identify the database statement. When the database statement is identified as the data definition language, data manipulation language, and data control function, it will be identified After the database statement is translated into a database statement that meets the database rules of the standby server, it sends a database synchronization statement to the standby server, and the standby server completes the real-time database synchronization after receiving the database statement that meets the database rules of the standby server sent by the proxy splitter. This method has no limitation on database types, has good versatility, low cost, and can meet the needs of data management and analysis in real time.

PUM

no PUM

Description & Claims & Application Information

We can also present the details of the Description, Claims and Application information to help users get a comprehensive understanding of the technical details of the patent, such as background art, summary of invention, brief description of drawings, description of embodiments, and other original content. On the other hand, users can also determine the specific scope of protection of the technology through the list of claims; as well as understand the changes in the life cycle of the technology with the presentation of the patent timeline. Login to view more.

Similar technology patents

Manufacturing method of multi-channel light filtering micro lens array

ActiveCN103760627AReduce the impactEnables monochrome imaging and color reconstruction
Owner:GUANGZHOU INST OF ADVANCED TECH CHINESE ACAD OF SCI

Calibrating device for eddy sensor

InactiveCN102538652AImprove adaptability and accuracyReduce the impact
Owner:XI AN JIAOTONG UNIV

Satellite navigation receiver local time correction method and positioning method

ActiveCN103995268AReduce the impactImprove timing accuracy
Owner:BEIJING INSTITUTE OF TECHNOLOGYGY

Classification and recommendation of technical efficacy words

  • Reduce the impact
  • low cost

Method and system for searching images by images based on deep learning

ActiveCN104679863Areduce dimensionalityReduce the impact
Owner:武汉众智数字技术有限公司

Method for messaging in routing non-access layer

InactiveCN101500281AReduce the impact
Owner:HUAWEI TECH CO LTD

Portable electric power communication protocol detector and detection method thereof

InactiveCN101621430Aavoid further expansionReduce the impact
Owner:南京拓为电力科技发展有限公司 +3

Method and device for determining access point position

Owner:BEIJING SANKUAI ONLINE TECH CO LTD

System and method for transmitting wireless digital service signals via power transmission lines

ActiveUS7929940B1reduce bandwidth requirementlow cost
Owner:NEXTEL COMMUNICATIONS

Plastic waveguide-fed horn antenna

InactiveUS20100214185A1low cost
Owner:RGT UNIV OF CALIFORNIA

System and method for determination of position

InactiveUS20090149202A1low costreduce requirement
Owner:STEELE CHRISTIAN

Adaptive antenna optimization network

InactiveUS6961368B2low costminimal space
Owner:ERICSSON INC
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