CN110209534A - The system and method for automated back-up mysql database - Google Patents

The system and method for automated back-up mysql database Download PDF

Info

Publication number
CN110209534A
CN110209534A CN201910516092.1A CN201910516092A CN110209534A CN 110209534 A CN110209534 A CN 110209534A CN 201910516092 A CN201910516092 A CN 201910516092A CN 110209534 A CN110209534 A CN 110209534A
Authority
CN
China
Prior art keywords
data
actual data
backup database
data library
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201910516092.1A
Other languages
Chinese (zh)
Other versions
CN110209534B (en
Inventor
罗刚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Sichuan Changhong Electric Co Ltd
Original Assignee
Sichuan Changhong Electric Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Sichuan Changhong Electric Co Ltd filed Critical Sichuan Changhong Electric Co Ltd
Priority to CN201910516092.1A priority Critical patent/CN110209534B/en
Publication of CN110209534A publication Critical patent/CN110209534A/en
Application granted granted Critical
Publication of CN110209534B publication Critical patent/CN110209534B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1448Management of the data involved in backup or backup restore
    • G06F11/1451Management of the data involved in backup or backup restore by selection of backup contents
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80Database-specific techniques

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to the redundancy techniques of mysql database, it discloses a kind of system and methods of automated back-up mysql database, it solves in traditional technology when needing to check data, local data base is first imported again from mysql database export data, the occupancy plenty of time leads to ineffective problem.System in the present invention includes: actual data library, backup database, actual data library micro services module, backup database micro services module and java scheduler;Wherein, actual data library micro services module, backup database micro services module and java scheduler deployment are in same server;The starting of java scheduler timing, by calling actual data library micro services module accesses actual data library, by calling backup database micro services module accesses backup database, comparison based on the field in the table in backup database and actual data library, changed data are searched in actual data library, and changed data are updated to backup database.

Description

The system and method for automated back-up mysql database
Technical field
The present invention relates to the redundancy techniques of mysql database, and in particular to the system of automated back-up mysql database and side Method.
Background technique
Often only DBA (database administrator) possesses read-write to mysql database to one regular project construction environment Permission, and developer generally only possesses read-only authority.When operation and financial staff need to check data, it is necessary to by DBA All data in mysql database are first exported, local data base are then imported data to by developer, to pass through sql Sentence, which inquires target data and exports excel table, is supplied to operation and financial staff.
However, but with the increase of portfolio, data volume also sharp increase first exports data when needing to check data The operation for importing local data base again occupies the plenty of time, causes working efficiency low.
Summary of the invention
The technical problems to be solved by the present invention are: proposing a kind of system and method for automated back-up mysql database, solve Certainly in traditional technology when needing to check data, Yao Xiancong mysql database export data import local data base again, occupy big The amount time leads to ineffective problem.
The technical proposal adopted by the invention to solve the above technical problems is that:
The system of automated back-up mysql database, comprising: actual data library, backup database, actual data library micro services Module, backup database micro services module and java scheduler;Wherein, actual data library micro services module, backup database Micro services module and java scheduler deployment are in same server;
The actual data library is the mysql database that projects use;
The backup database is the data that the data in the mysql database for using projects are backed up Library, and possess identical table and field with actual data library, and contain field in each table: from increase major key id, renewal time and Logic deleted marker position;
The actual data library micro services module connects actual data library;
The backup database micro services module connects backup database;
The java scheduler timing starting, for by calling actual data library micro services module accesses actual data Library, by calling backup database micro services module accesses backup database, based in backup database and actual data library Changed data are searched in the comparison of field in table in actual data library, and changed data are updated to backup Database.
As advanced optimizing, the data of the variation include: newly-increased, change and the data deleted.
By the way that increasing newly, changing and deleting, data search and backup is able to maintain backup database and actual data library In data it is consistent.
As advanced optimizing, the comparison of the field in the table based in backup database and actual data library, Changed data are searched in actual data library, and changed data are updated to backup database, are specifically included:
The id for obtaining the last item data in the table in backup database, by each number in the table in this id and actual data library According to id be compared, in the table in actual data library it is all possess id greater than this id data be increase newly data, will increase newly Data be inserted into the correspondence table of backup database;
The id for obtaining the last item data in the table in backup database, by each number in the table in this id and actual data library According to id be compared, all id that possess are less than or equal to this id in the table in actual data library, and renewal time was between last time Java scheduler starts between time and current time, and the data that logic deleted marker position is 0 are the data updated, will be updated Data be updated in the correspondence table of backup database;
Search actual data library in table in renewal time between last time java scheduler starting the time and current time it Between, and the data that logic deleted marker position is 1 are the data deleted, and the logic of corresponding data is deleted mark in backup database Will position is 1, and renewal time field is updated to as actual data library.
Changed data can be quickly searched by the comparison of field, to improve backup efficiency.
As advanced optimizing, the actual data library micro services module and backup database micro services module are used Restful interface, it is only open to java scheduler.
It is only open to java scheduler using restful interface, it does not open to the outside world, then can guarantee the data in database Safety, also, the calling of interface is not needed using token security mechanism yet.
In addition, be applied in above system the present invention also provides a kind of method of automated back-up mysql database, Include:
The starting of java scheduler timing passes through tune by calling actual data library micro services module accesses actual data library With backup database micro services module accesses backup database, based on the field in the table in backup database and actual data library Comparison, changed data are searched in actual data library, changed data are updated to backup database.
As advanced optimizing, time of the java scheduler timing starting determines with portfolio according to demand.
Determine that the time of java scheduler timing starting can satisfy backup requirements with portfolio according to demand.
As advanced optimizing, the data of the variation include: newly-increased, change and the data deleted.
By the way that increasing newly, changing and deleting, data search and backup is able to maintain backup database and actual data library In data it is consistent.
As advanced optimizing, the comparison of the field in the table based in backup database and actual data library, Changed data are searched in actual data library, and changed data are updated to backup database, are specifically included:
The id for obtaining the last item data in the table in backup database, by each number in the table in this id and actual data library According to id be compared, in the table in actual data library it is all possess id greater than this id data be increase newly data, will increase newly Data be inserted into the correspondence table of backup database;
The id for obtaining the last item data in the table in backup database, by each number in the table in this id and actual data library According to id be compared, all id that possess are less than or equal to this id in the table in actual data library, and renewal time was between last time Java scheduler starts between time and current time, and the data that logic deleted marker position is 0 are the data updated, will be updated Data be updated in the correspondence table of backup database;
Search actual data library in table in renewal time between last time java scheduler starting the time and current time it Between, and the data that logic deleted marker position is 1 are the data deleted, and the logic of corresponding data is deleted mark in backup database Will position is 1, and renewal time field is updated to as actual data library.
Changed data can be quickly searched by the comparison of field, to improve backup efficiency.
The beneficial effects of the present invention are:
By start by set date java scheduler, the micro- of actual data library and backup database is separately connected by calling two Service obtains the data for sending variation from actual data library, backs up in backup database;Due to being backed up for self-timing, It eliminates and exports data and importing local data base in the mysql database that the slave projects when needing to check data use Link, working efficiency can be improved, and since non-alignment type database data changes, also ensure the correct of data Property.
Detailed description of the invention
Fig. 1 is the system structure diagram of the automated back-up mysql database in the present invention;
Fig. 2 is the flow chart backed up in embodiment to newly-increased data;
Fig. 3 is the flow chart backed up in embodiment to the data of change;
Fig. 4 is the flow chart backed up in embodiment to the data of deletion.
Specific embodiment
The present invention is intended to provide a kind of system and method for automated back-up mysql database, solves needing in traditional technology When checking data, Yao Xiancong mysql database export data import local data base again, and the occupancy plenty of time causes work to be imitated The low problem of rate.Its core concept is: two databases with identical table and field of creation, one of them is as projects The actual data library used, another is the backup database that data backup is carried out to it;Creation two for connecting formal number According to the micro services in library and backup database, and by start by set date java scheduler, to call the two micro services, from formal number According to the data for sending variation are obtained in library, back up in backup database.
As shown in Figure 1, in the present invention automated back-up mysql database system, comprising: actual data library, Backup Data Library, actual data library micro services module, backup database micro services module and java scheduler;Wherein, actual data library is micro- Service module, backup database micro services module and java scheduler deployment are in same server;
The actual data library is the mysql database that projects use;
The backup database is the data that the data in the mysql database for using projects are backed up Library, and possess identical table and field with actual data library;
The actual data library micro services module connects actual data library;
The backup database micro services module connects backup database;
The java scheduler timing starting, for by calling actual data library micro services module accesses actual data Library, by calling backup database micro services module accesses backup database, based in backup database and actual data library Changed data are searched in the comparison of field in table in actual data library, and changed data are updated to backup Database.
In specific implementation, the table of two databases is identical with field, just can guarantee in backup database in this way The consistency of data and the data in actual data library;When establishing table, each table must include following field:
1. can quickly find out newly-increased data by comparing the id in the table of both sides in this way from the major key id increased;
2. renewal time field updateTime when project updates actual data library data, needs renewal time field simultaneously It is updated so that it is convenient to rapidly find out the data of update;
3. the mark ifDel that logic is deleted, logic deletes field and is defaulted as 0, when projects delete actual data library number According to when (being not that physics is deleted, and logic is deleted), be 1 by deleted marker position, while renewal time field need to be carried out It updates, when searching deletion data in this way, only need to find out the data that deleted marker position is 1, quickly and effectively.
Java scheduler is a java engineering, and frame is the frame of springMvc.Timer scheduled therein Can start by set date (starting time specifically regard project data amount decision) at regular intervals, the interface for calling micro services to provide. Java scheduler is equivalent to a terminal, is connected to both sides database, and calling in actual data library of make suring in incognito has change Data found out and be updated to backup database, while being also the source for initiating whole flow process.
Actual data library micro services module and backup database micro services module are exactly two spring boot engineerings, and one The database of a connection is the actual data library of project, and effect mainly finds out the data for having change in actual data library; The database of one connection is the database of backup, and main function is that the data changed in actual data library are updated to backup In database.Java scheduler need to be disposed in a server with micro services, be present in same network segment, and such micro services provide Interface could be transferred by java scheduler;That is, micro services be by providing what interface worked for java scheduler, Interface cannot open to the outside world, be only java scheduler and provide service.Because being java engineering, micro services are provided in the present invention Interface is then restful interface.Due to being to inner joint, the calling of interface is not needed then using token security mechanism.Two micro- Service is connected by java scheduler engineering, to realize transmission of the data from a database to another data.Two Micro services engineering is equivalent to specific operator in process, and operating has the data of change to be found out in actual data library Be updated in backup database.
Embodiment:
Since data change generally includes: newly-increased, change and deleting, the present embodiment is by the backup to this three kinds of data changes Process is illustrated respectively:
The newly-increased backup of data: as shown in Fig. 2, firstly, java scheduler calling backup database micro services, find certain The id of table tab the last item data is a, recalls actual data library micro services, finds out all numbers that id in this table is greater than a According to here it is the increased data of table tab in this period, finally recall backup database micro services and newly-increased data are inserted into In backup database table tab, to realize the update of table tab data.
The backup of more new data: as shown in figure 3, firstly, java scheduler first obtains current time, when then utilizing current Between subtract timer starting interval time obtain last time java scheduler starting time, then by scheduler call backup number It is I1 according to the id that micro services obtain table tab the last item data, then scheduler calls actual data library micro services, obtains table Id is less than or equal to I1 in tab, and renewal time starts between time and current time between the last time, and deleted marker position is The data of 0 (indicating not carry out logic deletion to data), thus have found the data that table tab is updated in this period, finally Timer calls backup database micro services, and more new data is updated in backup database table tab.
It deletes the backup of data: searching deletion data and be equivalent to special more new data.As shown in figure 4, scheduler is still Current time is obtained, timer starting interval time section is subtracted and obtains starting time last time, then call actual data library in incognito Business finds out in table tab renewal time between starting time last time and current time, and to be 1 (indicate pair for deleted marker position Data perform logic deletion) data then call the micro services of backup database to have found deletion data, will be These data deleted marker positions in backup database are 1, and renewal time field is updated to as actual data library.

Claims (8)

1. the system of automated back-up mysql database, which is characterized in that
Include: actual data library, backup database, actual data library micro services module, backup database micro services module and Java scheduler;Wherein, actual data library micro services module, backup database micro services module and java scheduler deployment in In same server;
The actual data library is the mysql database that projects use;
The backup database is the database that the data in the mysql database for using projects are backed up, And possess identical table and field with actual data library, and contain field in each table: from increasing major key id, renewal time and logic Deleted marker position;
The actual data library micro services module connects actual data library;
The backup database micro services module connects backup database;
The java scheduler timing starting, for leading to by calling actual data library micro services module accesses actual data library Calling backup database micro services module accesses backup database is crossed, based in the table in backup database and actual data library Changed data are searched in the comparison of field in actual data library, and changed data are updated to backup database.
2. the system of automated back-up mysql database as described in claim 1, which is characterized in that
The data of the variation include: newly-increased, change and the data deleted.
3. the system of automated back-up mysql database as claimed in claim 2, which is characterized in that
The comparison of field in the table based in backup database and actual data library is searched in actual data library and is occurred Changed data are updated to backup database, specifically included by the data of variation:
The id for obtaining the last item data in the table in backup database, by each data in the table in this id and actual data library Id is compared, and all data of the id greater than this id that possess are newly-increased data in the table in actual data library, by newly-increased number According in the correspondence table for being inserted into backup database;
The id for obtaining the last item data in the table in backup database, by each data in the table in this id and actual data library Id is compared, and all id that possess are less than or equal to this id in the table in actual data library, and renewal time is between last time java Scheduler starts between time and current time, and the data that logic deleted marker position is 0 are the data updated, by the number of update According in the correspondence table for being updated to backup database;
Renewal time starts between time and current time between last time java scheduler in table in lookup actual data library, and The data that logic deleted marker position is 1 are the data deleted, by the logic deleted marker position of corresponding data in backup database It is set to 1, and renewal time field is updated to as actual data library.
4. the system of automated back-up mysql database as described in claim 1, which is characterized in that
The actual data library micro services module and backup database micro services module use restful interface, only to java tune It is open to spend device.
It is special applied in the system as described in claim 1-4 any one 5. the method for automated back-up mysql database Sign is, comprising:
The starting of java scheduler timing, it is standby by calling by calling actual data library micro services module accesses actual data library Part database micro services module accesses backup database, the ratio based on the field in the table in backup database and actual data library Compared with searching changed data in actual data library, changed data be updated to backup database.
6. the method for automated back-up mysql database as claimed in claim 5, which is characterized in that
Time of java scheduler timing starting determines with portfolio according to demand.
7. the method for automated back-up mysql database as claimed in claim 5, which is characterized in that
The data of the variation include: newly-increased, change and the data deleted.
8. the method for automated back-up mysql database as claimed in claim 7, which is characterized in that
The comparison of field in the table based in backup database and actual data library is searched in actual data library and is occurred Changed data are updated to backup database, specifically included by the data of variation:
The id for obtaining the last item data in the table in backup database, by each data in the table in this id and actual data library Id is compared, and all data of the id greater than this id that possess are newly-increased data in the table in actual data library, by newly-increased number According in the correspondence table for being inserted into backup database;
The id for obtaining the last item data in the table in backup database, by each data in the table in this id and actual data library Id is compared, and all id that possess are less than or equal to this id in the table in actual data library, and renewal time is between last time java Scheduler starts between time and current time, and the data that logic deleted marker position is 0 are the data updated, by the number of update According in the correspondence table for being updated to backup database;
Renewal time starts between time and current time between last time java scheduler in table in lookup actual data library, and The data that logic deleted marker position is 1 are the data deleted, by the logic deleted marker position of corresponding data in backup database It is set to 1, and renewal time field is updated to as actual data library.
CN201910516092.1A 2019-06-14 2019-06-14 System and method for automatically backing up mysql database Active CN110209534B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910516092.1A CN110209534B (en) 2019-06-14 2019-06-14 System and method for automatically backing up mysql database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910516092.1A CN110209534B (en) 2019-06-14 2019-06-14 System and method for automatically backing up mysql database

Publications (2)

Publication Number Publication Date
CN110209534A true CN110209534A (en) 2019-09-06
CN110209534B CN110209534B (en) 2022-09-16

Family

ID=67792732

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910516092.1A Active CN110209534B (en) 2019-06-14 2019-06-14 System and method for automatically backing up mysql database

Country Status (1)

Country Link
CN (1) CN110209534B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112364103A (en) * 2020-12-08 2021-02-12 四川长虹电器股份有限公司 Data synchronization method based on relational database master-slave asynchronous replication architecture
CN115510166A (en) * 2022-11-23 2022-12-23 云账户技术(天津)有限公司 Data synchronization service method and device, remote platform and electronic equipment

Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104615759A (en) * 2015-02-13 2015-05-13 厦门雅迅网络股份有限公司 Data synchronization method for different business system platforms
CN105488389A (en) * 2014-12-08 2016-04-13 哈尔滨安天科技股份有限公司 Update and reduction method and system of honeypot database
CN105677516A (en) * 2016-01-07 2016-06-15 成都市思叠科技有限公司 Method for efficient and reliable backup recovery in calculation approach storage cloud platform
CN105701218A (en) * 2016-01-14 2016-06-22 四川长虹电器股份有限公司 Method for realizing data synchronism of different terminals on database
US20160217042A1 (en) * 2015-01-23 2016-07-28 Servicenow, Inc. Distributed computing system with resource managed database cloning
CN106446243A (en) * 2016-10-10 2017-02-22 山东浪潮云服务信息科技有限公司 Data integration structure of relational database
CN107247639A (en) * 2017-05-03 2017-10-13 上海动联信息技术股份有限公司 A kind of efficient backup method of mysql databases
CN107577780A (en) * 2017-09-13 2018-01-12 郑州云海信息技术有限公司 A kind of data center's cloud resource synchronous method and device
US20180173562A1 (en) * 2016-12-16 2018-06-21 Red Hat, Inc. Low impact snapshot database protection in a micro-service environment
CN108932588A (en) * 2018-06-29 2018-12-04 华中科技大学 A kind of the GROUP OF HYDROPOWER STATIONS Optimal Scheduling and method of front and back end separation
CN109144785A (en) * 2018-08-27 2019-01-04 北京百度网讯科技有限公司 Method and apparatus for Backup Data
CN109542639A (en) * 2018-11-06 2019-03-29 用友网络科技股份有限公司 A kind of processing method, processing unit for ensureing micro services and calling data consistency
CN109582695A (en) * 2018-12-04 2019-04-05 用友网络科技股份有限公司 Data general-purpose querying method and inquiry system under a kind of micro services framework
US20200349172A1 (en) * 2019-04-30 2020-11-05 Microsoft Technology Licensing, Llc Managing code and data in multi-cluster environments

Patent Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105488389A (en) * 2014-12-08 2016-04-13 哈尔滨安天科技股份有限公司 Update and reduction method and system of honeypot database
US20160217042A1 (en) * 2015-01-23 2016-07-28 Servicenow, Inc. Distributed computing system with resource managed database cloning
CN104615759A (en) * 2015-02-13 2015-05-13 厦门雅迅网络股份有限公司 Data synchronization method for different business system platforms
CN105677516A (en) * 2016-01-07 2016-06-15 成都市思叠科技有限公司 Method for efficient and reliable backup recovery in calculation approach storage cloud platform
CN105701218A (en) * 2016-01-14 2016-06-22 四川长虹电器股份有限公司 Method for realizing data synchronism of different terminals on database
CN106446243A (en) * 2016-10-10 2017-02-22 山东浪潮云服务信息科技有限公司 Data integration structure of relational database
US20180173562A1 (en) * 2016-12-16 2018-06-21 Red Hat, Inc. Low impact snapshot database protection in a micro-service environment
CN107247639A (en) * 2017-05-03 2017-10-13 上海动联信息技术股份有限公司 A kind of efficient backup method of mysql databases
CN107577780A (en) * 2017-09-13 2018-01-12 郑州云海信息技术有限公司 A kind of data center's cloud resource synchronous method and device
CN108932588A (en) * 2018-06-29 2018-12-04 华中科技大学 A kind of the GROUP OF HYDROPOWER STATIONS Optimal Scheduling and method of front and back end separation
CN109144785A (en) * 2018-08-27 2019-01-04 北京百度网讯科技有限公司 Method and apparatus for Backup Data
CN109542639A (en) * 2018-11-06 2019-03-29 用友网络科技股份有限公司 A kind of processing method, processing unit for ensureing micro services and calling data consistency
CN109582695A (en) * 2018-12-04 2019-04-05 用友网络科技股份有限公司 Data general-purpose querying method and inquiry system under a kind of micro services framework
US20200349172A1 (en) * 2019-04-30 2020-11-05 Microsoft Technology Licensing, Llc Managing code and data in multi-cluster environments

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
A. KOZMIRCHUK等: "PostgreSQL service with backup and recovery for cloud foundry", 《2016 INTERNATIONAL FRUCT CONFERENCE ON INTELLIGENCE, SOCIAL MEDIA AND WEB (ISMW FRUCT)》 *
吴坤安等: "基于Docker的数据库微服务系统设计与实现", 《国外电子测量技术》 *
沈进波: "基于SOA技术架构的多并发异构业务系统中台技术设计", 《电子技术与软件工程》 *
科创人: "微服务之数据同步Porter", 《HTTPS://BLOG.CSDN.NET/HEISHAOVVV/ARTICLE/DETAILS/87859552》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112364103A (en) * 2020-12-08 2021-02-12 四川长虹电器股份有限公司 Data synchronization method based on relational database master-slave asynchronous replication architecture
CN115510166A (en) * 2022-11-23 2022-12-23 云账户技术(天津)有限公司 Data synchronization service method and device, remote platform and electronic equipment

Also Published As

Publication number Publication date
CN110209534B (en) 2022-09-16

Similar Documents

Publication Publication Date Title
US10223374B2 (en) Indexing of linked data
US8332358B2 (en) Traversal-free rapid data transfer
US10496618B2 (en) Managing data replication in a data grid
WO2015145536A1 (en) Database management system, and method for controlling synchronization between databases
CN110096476A (en) Data back up method, device and computer readable storage medium
CN106934048A (en) Online data moving method, agent node
CN110019469B (en) Distributed database data processing method and device, storage medium and electronic device
CN106503257A (en) Distributed transaction server method and system based on binlog compensation mechanism
CN110209534A (en) The system and method for automated back-up mysql database
US20150006485A1 (en) High Scalability Data Management Techniques for Representing, Editing, and Accessing Data
CN105577841A (en) File synchronization method, device, client, server side and device
CN103475721A (en) System for updating digital assets and method thereof
CN103139308B (en) A kind of Database Systems and method of data synchronization thereof
CN111737227A (en) Data modification method and system
CN113656384B (en) Data processing method, distributed database system, electronic device and storage medium
CN103778176B (en) For the system of data long term archival, method and computer usable medium in MES system
CN106713032B (en) A kind of method and device for realizing network management service management
CN112486532B (en) Configuration file management method and device, electronic equipment and storage medium
Truica et al. Asynchronous Replication in Microsoft SQL Server, PostgreSQL and MySQL
CN113448939A (en) Data archiving and storing method and device and storage medium
CN105723365A (en) Method for optimizing index, master database node and subscriber database node
CN117093139A (en) Data processing method, device and system for data storage
CN110852701A (en) Product demand management method, device and system
CN112988879A (en) Method, system, device, storage medium and processor for accessing database
US11108862B2 (en) Bi-directional data sync between a client device and an application server

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant