Method, system and storage medium for synchronously updating data tables in multiple servers

A synchronous update and data table technology, applied in the field of data processing, can solve problems affecting efficiency, multi-technology cost and time cost, and complexity of data table synchronization process

Active Publication Date: 2021-06-08
HNAC TECH
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] When there are few data tables to be synchronized and the amount of data to be synchronized is small, it takes a lot of technical and time costs to develop external programs and obtain synchronization tools, which will cause serious waste of development resources and lead to the data table synchronization process. complicate and affect the efficiency

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
  • Method, system and storage medium for synchronously updating data tables in multiple servers
  • Method, system and storage medium for synchronously updating data tables in multiple servers
  • Method, system and storage medium for synchronously updating data tables in multiple servers

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the purpose, technical solutions and advantages of the present application more clearly understood, the present application will be described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application. The first server and the second server are relative concepts, and in the application process, the first server and the second server can be replaced with each other.

[0055] The method for synchronously updating data tables in multiple servers provided by this application can be applied to, for example, figure 1 in the application environment shown. Specifically, it can be a two-way synchronization between a small number of data tables in the MySQL database of two servers, which is a lightweight implementation solution. The terminal 100 communicates with the first ser...

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 present application relates to a method, a system, a computer device and a storage medium for synchronously updating data tables in multiple servers. The method includes: the first server responds to the user operation, updates the data content of the built-in first data table and the update identification of the built-in virtual record table, and sequentially sends the update identification and update content to the second server, and the second server , update the built-in record table, and interrupt the one-way synchronization thread that synchronizes the second data table to the first data table according to the updated record table, and update the built-in second data table according to the update content in the interrupted state of the one-way synchronization thread data sheet. The two-way synchronization process of the data table is realized through the built-in data table, the record table and the trigger update between the virtual tables that have a mapping relationship with them. It does not need to develop additional external synchronization tools, and realizes the convenient and efficient data table in multiple servers. Two-way synchronization.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular, to a method, system, computer device and storage medium for synchronously updating data tables in multiple servers. Background technique [0002] With the rapid development of information technology, in different application environments, it is often necessary to remotely operate server B through server A to achieve data synchronization. [0003] For the remote synchronization operation of the mysql (relational database management system) database, the traditional method is generally through other external programs, after connecting to the mysql database, through the sql command to achieve detection, update and synchronization. [0004] When there are few data tables to be synchronized and the amount of data to be synchronized is small, it takes more technical and time costs to develop external programs and obtain synchronization tools, which will cause seriou...

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 & AuthorityPatents(China)
IPC IPC(8): G06F16/22G06F16/23G06F16/27H04L29/08
CPCG06F16/2282G06F16/2365G06F16/273H04L67/1095
Inventor胡峰陈晓
OwnerHNAC TECH