Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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
三六零数字安全科技集团有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This mode of operation not only limits the types of databases, but also greatly increases user costs
After reaching a certain scale, traditional methods cannot cope with the increasing changes

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
  • Universal database synchronization method
  • Universal database synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0027] For example, there are 20 terminal computers in a local area network, terminal computers PC1, PC2, ..., PC20, a master server (M-SERVER), a backup server (E-SERVER), the operations issued by the 20 terminal computers The operation result of the request and the main server (M-SERVER) reply 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 database synchronization method specifically includes the following steps:

[0028] a. The master 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 main server IP address and the port of the database on the main server;

[0031] The standby server information includes the standby server IP address, the database type on the standby server, and the port of the dat...

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 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.

Description

technical field [0001] The invention belongs to the technical field of databases, in particular to a general database synchronization method. Background technique [0002] With the development of the information age, the application of databases is becoming more and more extensive. With the increasing demands of users, the pressure on the databases of products that have been deployed is also increasing. The authorization of the database is used to expand the capacity of the database to relieve the pressure on the database. This mode of operation not only limits the types of databases, but also greatly increases user costs. After reaching a certain scale, traditional methods cannot cope with the increasing changes. In order to ensure the normal operation of the business system and meet the application requirements of the database, a general database synchronization method is needed to solve the above problems. Contents of the invention [0003] The main purpose of the pr...

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): G06F16/27G06F16/242G06F16/23
CPCG06F16/27G06F16/2433G06F16/23
Inventor 张晓欧孔祥焱吴艳
Owner 三六零数字安全科技集团有限公司
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More