CN106959989A - The synchronous method and device in master/slave data storehouse - Google Patents
The synchronous method and device in master/slave data storehouse Download PDFInfo
- Publication number
- CN106959989A CN106959989A CN201610532157.8A CN201610532157A CN106959989A CN 106959989 A CN106959989 A CN 106959989A CN 201610532157 A CN201610532157 A CN 201610532157A CN 106959989 A CN106959989 A CN 106959989A
- Authority
- CN
- China
- Prior art keywords
- transaction
- major key
- write queue
- write
- master
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
A kind of master/slave data storehouse sychronisation, including synchronized transaction acquiring unit, for by being read out to the db transaction in primary database, obtaining needs synchronous db transaction information, it is added in db transaction write queue, and regard db transaction major key quantity as major key processing progress value;And synchronized transaction execution unit, for the db transaction in the db transaction write queue to be written in standby database using concurrent writing, and delete the db transaction positioned at the db transaction write queue top.And a master/slave data storehouse synchronous method.The sychronisation and method of the present invention can greatly promote MariaDB cluster performance, effectively extend MariaDB scope on probation, it would be preferable to support higher database access amount;In addition, the mode of multi-threaded parallel write-in reduces the synchronous execution time, MariaDB execution efficiency is greatly improved.
Description
Technical field
The present invention relates to data processing field, relate more specifically to a kind of synchronous method and device in master/slave data storehouse.
Background technology
MySQL is the widely used PostgreSQL database software of internet industry, closes MySQL but due to the inscriptions on bones or tortoise shells is present
The risk in source, many applications based on MySQL all suffer from needing to use alternative PostgreSQL database software, and MariaDB is
The alternative solution best to MySQL compatibility.But for large-scale website, there is a MariaDB number using MariaDB databases
The problem of huge visit capacity can not being supported according to storehouse.
To this, effective solution is to set up MariaDB data-base clusters, wherein being the complete of primary database for database
Whole mirror image, write request is performed first in primary database, and read request can be distributed on all databases, and primary database is being received
Write and be synchronized to by way of synchronization means performs write request according to single thread order on standby database after the completion of data, so that
More powerful data base read-write service is provided.
In the active and standby synchronous version that current official provides, active and standby synchronization uses single thread synchronization, works as primary database
When load is higher, synchronizing relay can be caused to increase, standby database can not read latest data in time, reduce data-base cluster
Availability.
The content of the invention
In view of this, it is a primary object of the present invention to provide a kind of master/slave data storehouse synchronous method and device, to solve
Certainly existing master/slave data storehouse is in the case where standby database is more, the problem of synchronous efficiency is low.
To achieve these goals, it is synchronous the invention provides a kind of master/slave data storehouse as one aspect of the present invention
Device, including:
Synchronized transaction acquiring unit, for by being read out to the db transaction in primary database, obtaining to need together
The db transaction information of step, is added in db transaction write queue, and regard db transaction major key quantity as master
Key processing progress value;And
Synchronized transaction execution unit, for using concurrent writing by the number in the db transaction write queue
It is written to according to storehouse affairs in standby database, and deletes the db transaction positioned at the db transaction write queue top.
Wherein, the synchronized transaction execution unit includes synchronized transaction processing assembly, synchronized transaction write-in component and synchronization
Affairs complete component, wherein each pending db transaction major key processing progress of the synchronized transaction processing assembly poll
Value, enters the synchronized transaction executive module when major key issued transaction progress value is 0;The synchronized transaction executive module will be main
Key processing progress value distributes for 0 db transaction and writes thread execution, using concurrent writing by the transaction write of write queue
Enter in standby database;The synchronized transaction completes component after the completion of the standby wide area information server affairs of write-in, deletes complete
Into db transaction, delete positioned at major key write queue top the db transaction, the Article 2 database of major key write queue
Affairs automatically become the pending affairs of major key write queue, and notify that the db transaction major key processing progress value subtracts one.
As another aspect of the present invention, present invention also offers a kind of master/slave data storehouse synchronous method, including it is following
Step:
By being read out to the db transaction in primary database, obtaining needs synchronous db transaction information, takes
Db transaction major key, the major key of recording synchronism db transaction, and using db transaction major key quantity as at major key
Manage progress value;
According to db transaction major key information, by the db transaction got according to sequentially increasing in primary database
In db transaction major key correspondence major key write queue;Wherein, team is write for the major key that the major key without write queue needs establishment new
Row, and the affairs are set to write queue top, notify that the major key processing progress value subtracts one;
Each pending db transaction major key processing progress value of poll, enters when major key issued transaction progress value is 0
Enter synchronized transaction executive module;
The db transaction that major key processing progress value is 0 is distributed and writes thread execution, team will be write using concurrent writing
In the standby database of affairs write-in of row;
After the completion of the standby wide area information server affairs of write-in, the db transaction completed is deleted, deletes and is located at major key
The db transaction on write queue top, the Article 2 db transaction of major key write queue automatically become major key write queue wait locate
Director is engaged in;Notify that the db transaction major key processing progress value subtracts one.
Understood based on above-mentioned technical proposal, sychronisation of the invention and method, can be by relative to prior art
MariaDB cluster performance is greatly promoted, and effectively extends MariaDB scope on probation, it would be preferable to support higher database is visited
The amount of asking;In addition, using affairs as synchronous least unit, affairs have atomicity, the side that simultaneous multi-threading is written in parallel in itself
Formula reduces the synchronous execution time, greatly improves MariaDB execution efficiency.
Brief description of the drawings
Fig. 1 is the structured flowchart of the sychronisation based on MariaDB master/slave datas storehouse of the present invention;
Fig. 2 is the flow of the synchronous method based on MariaDB master/slave datas storehouse as a preferred embodiment of the invention
Block diagram.
Embodiment
For the object, technical solutions and advantages of the present invention are more clearly understood, below in conjunction with specific embodiment, and reference
Accompanying drawing, the present invention is described in further detail.
MySQL is a Relational DBMS, is developed by MySQLAB companies of Sweden, Oracle is belonged at present
Under company.MySQL is most popular Relational DBMS, and MySQL is best RDBMS in terms of WEB application
One of (Relational Database Management System, relational database management system) application software.
In MySQL, linked database is saved the data in different tables, rather than all data are placed in one big warehouse, this
Sample increases speed and improves flexibility.Also, sql like language used in MySQL is for accessing the most normal of database
Use standardized language.MySQL softwares employ double authorization policies, and it is divided into Community Edition and commercial version, due to its small volume, speed
Hurry up, the total cost of ownership it is low, especially this feature of open source code, the exploitation of general middle-size and small-size website all selects MySQL conducts
Site databases, for general personal use person and medium-sized and small enterprises, the function that MySQL is provided is more than sufficient,
But for large-scale website, in face of the problem of it is more complicated, it is still desirable to more strong instrument.
MariaDB (agate jasmine sub data base) is a MySQL branches version using Maria storage engines, is by original
The database server freely increased income that the company that MySQL author Michael Widenius are established is developed.MySQL is originated
The discontented Sun development teams steps of people Michael Widenius are excessively slow, and PostgreSQL database alliance is set up so angry as leaving office, in addition from existing
Have in MySQL program codes, develop another extension branch version, that is, the enterprise-level of entitled agate jasmine sub data base is increased income
Database.Agate jasmine sub data base is MySQL branch's version (branch), rather than derived version (folk) there is provided
Function can be completely compatible with MySQL.
Maria storage engines of the MariaDB based on affairs, substituted for MySQL MyISAM storage engines, it is used
Percona XtraDB, InnoDB variant, the developer of branch is desirable to provide the upcoming MySQL5.4InnoDB of access
Performance.This version further comprises PrimeBase XT (PBXT) and FederatedX storage engines.It is powerful due to MariaDB
Function, some large enterprises also turn to MariaDB from MySQL, wherein representing producer includes:Google's (in September, 2013), RedHat
(in June, 2013) and wikipedia (in April, 2013).
Although MariaDB is considered as the substitute of MySQL database, but it expanded function, storage engines and some
It is all strong in terms of new function improvement to cross MySQL.And it is also very simple to move to MariaDB from MySQL:
1st, it is binary compatible that data and table, which define file (.frm),;
2nd, all clients API, agreement and structure are all completely the same;
3rd, All Files name, binary system, path, port etc. are all consistent;
4th, all MySQL connectors, such as PHP, Perl, Python, Java .NET, MyODBC, Ruby and
MySQL C connector etc. keep constant in MariaDB;
5th, mysql-client bags also can normally be run in MariaDB servers;
6th, shared client library and MySQL are also binary compatible.
Db transaction (Database Transaction), refers to as a series of of single logical unit of work execution
Operation, otherwise it is completely executed, otherwise do not perform fully.Issued transaction may insure except all behaviour in non-transactional unit
All successfully complete, otherwise will not forever update the resource of data-oriented.Or by the way that one group of associative operation is combined as into one
The unit that all or success all fails, can simplify Fault recovery and make application program relatively reliable.
The present invention is developed in the management system based on MariaDB databases, is taking MariaDB data
In the management system in storehouse, often there is the situation for needing to back up data-base content, and in order to increase redundancy, generally use
The system of two sets of master/slave data storehouse repetition, and such system is when synchronizing, due to needing in face of complicated issued transaction,
And single thread synchronization is used, so synchronous efficiency is lower, have a strong impact on whole MariaDB data base management systems
Operating efficiency, when primary database load is higher, synchronizing relay can be caused to increase, standby database can not read newest number in time
According to reducing the availability of data-base cluster.In order to solve the problem of above-mentioned existing master/slave data storehouse synchronous efficiency is low, this hair
It is bright to disclose a kind of master/slave data storehouse sychronisation based on MariaDB databases, as shown in figure 1, the master/slave data storehouse is synchronous
Device is made up of two parts, is synchronized transaction acquiring unit and synchronized transaction execution unit respectively.
Synchronized transaction execution unit is made up of three components again, is synchronized transaction processing assembly, synchronized transaction write-in respectively
Component, synchronized transaction complete component.
Because synchronous working is lasting progress, therefore in real process, synchronized transaction acquiring unit constantly will be new
Need synchronous affairs to give synchronized transaction execution unit to be handled.Meanwhile, synchronized transaction execution unit is also due to synchronization
Being continuously increased for affairs and repeat according to synchronized transaction processing assembly, synchronized transaction write component, synchronized transaction complete component
Carry out issued transaction.
Lower mask body is described in detail and illustrated to each part of the master/slave data storehouse sychronisation of the present invention.
Synchronized transaction acquiring unit
By being read out to the db transaction in primary database, obtaining needs synchronous db transaction information.
For the db transaction that gets, it is necessary to obtain the major key of db transaction, recording synchronism db transaction
Major key, and it regard db transaction major key quantity as major key processing progress value.
The db transaction got, according to db transaction major key information, according to sequentially increasing in primary database
In db transaction major key correspondence major key write queue, major key write queue is performed according to the sequential system of first in first out.For not having
The major key of write queue is needed to create new major key write queue, and the affairs are set into write queue top, notify the major key handle into
Angle value subtracts one.
Synchronized transaction execution unit
Synchronized transaction execution unit is made up of three components, is synchronized transaction processing assembly, synchronized transaction write-in group respectively
Part and synchronized transaction complete component.
Synchronized transaction processing assembly
Each pending db transaction major key processing progress value of poll, enters when major key issued transaction progress value is 0
Enter synchronized transaction executive module.
Wherein, there are several pending db transaction major keys etc. inside major key write queue pending, and these
Affairs major key is ordered into, and the affairs major key only before the affairs major key can just take turns to new affairs major key after the completion of performing and hold
OK, when affairs major key processing is taken turns to, the affairs major key processing progress value is 0, by the affairs major key after the completion of execution
Processing progress value be set to -1, then remove all affairs major keys of poll, find the pending affairs that affairs major key progress value is 0
Major key.
Synchronized transaction executive module
The db transaction that major key processing progress value is 0 is distributed and writes thread execution, team will be write using concurrent writing
In the standby database of affairs write-in of row.
Synchronized transaction completes component
After the completion of the standby wide area information server affairs of write-in, the db transaction completed is deleted, deletes and is located at major key
The db transaction on write queue top, the Article 2 db transaction of major key write queue automatically become major key write queue wait locate
Director is engaged in.Notify that all affairs major key processing progress values of the database subtract one.
As another aspect of the present invention, the invention also discloses a master/slave data storehouse synchronous method, including it is following
Step:
By being read out to the db transaction in primary database, obtaining needs synchronous db transaction information, takes
Db transaction major key, the major key of recording synchronism db transaction, and using db transaction major key quantity as at major key
Manage progress value;
According to db transaction major key information, by the db transaction got according to sequentially increasing in primary database
In db transaction major key correspondence major key write queue, major key write queue is performed according to the sequential system of first in first out;Wherein, for
There is no the major key of write queue to need to create new major key write queue, and the affairs are set to write queue top, notify at the major key
Reason progress value subtracts one;
Each pending db transaction major key processing progress value of poll, enters when major key issued transaction progress value is 0
Enter synchronized transaction executive module;
The db transaction that major key processing progress value is 0 is distributed and writes thread execution, team will be write using concurrent writing
In the standby database of affairs write-in of row;
After the completion of the standby wide area information server affairs of write-in, the db transaction completed is deleted, deletes and is located at major key
The db transaction on write queue top, the Article 2 db transaction of major key write queue automatically become major key write queue wait locate
Director is engaged in;Notify that the db transaction major key processing progress value subtracts one.
As a preferred embodiment of the present invention, as shown in Fig. 2 the master/slave data storehouse synchronous method of the present invention, including
Following steps:
Reading needs synchronous db transaction information in primary database, obtain the major key of db transaction, recording synchronism
The major key of db transaction, and it regard db transaction major key quantity as major key processing progress value;
Judge whether a db transaction is had been written into major key write queue, if had been written into, according to database thing
Business major key information, db transaction major key correspondence master is sequentially increased by the db transaction got according in primary database
In key write queue, major key write queue is performed according to the sequential system of first in first out;Otherwise, new major key write queue is created, and will
The affairs are set to write queue top, notify that the major key processing progress value subtracts one;
Whether each pending db transaction major key processing progress value of poll is 0, if major key issued transaction progress
It is worth for 0, then into synchronized transaction executive module;Otherwise, all db transaction major key processing progress values are subtracted one.
The db transaction that major key processing progress value is 0 is distributed and writes thread execution, and will using concurrent writing
In the standby database of affairs write-in of write queue;
After the completion of the standby wide area information server affairs of write-in, the db transaction completed is deleted, deletes and is located at major key
The db transaction on write queue top, the Article 2 db transaction of major key write queue automatically become major key write queue wait locate
Director is engaged in;Notify that the db transaction major key processing progress value subtracts one.
Above-mentioned polling steps are repeated, it is synchronous until all db transactions are write in standby database in major key write queue
It is finished.
The present invention all parts embodiment can be realized with hardware, or with one or more processor run
Software module realize, or realized with combinations thereof.It will be understood by those of skill in the art that can use in practice
Microprocessor or digital signal processor (DSP) come realize in relevant device according to embodiments of the present invention some or it is complete
The some or all functions of portion's part.The present invention be also implemented as a part for performing method as described herein or
Person whole equipment or program of device (for example, computer program and computer program product).It is such to realize the present invention's
Program can be stored on a computer-readable medium, or can have the form of one or more signal.Such signal
It can download and obtain from internet website, either provide or provided in any other form on carrier signal.
It should be noted that the present invention will be described rather than limits the invention for above-described embodiment, and ability
Field technique personnel can design alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference symbol between bracket should not be configured to limitations on claims.Word "comprising" is not excluded the presence of not
Element listed in the claims or step.Word "a" or "an" before element does not exclude the presence of multiple such
Element.The present invention can be by means of including the hardware of some different elements and coming real by means of properly programmed computer
It is existing.In if the unit claim of equipment for drying is listed, several in these devices can be by same hardware branch
To embody.
Particular embodiments described above, has been carried out further in detail to the purpose of the present invention, technical scheme and beneficial effect
Describe in detail bright, it should be understood that the foregoing is only the present invention specific embodiment, be not intended to limit the invention, it is all
Within the spirit and principles in the present invention, any modifications, equivalent substitutions and improvements done etc. should be included in the protection of the present invention
Within the scope of.
Claims (9)
1. a kind of master/slave data storehouse sychronisation, including:
Synchronized transaction acquiring unit, for by being read out to the db transaction in primary database, obtaining to need synchronization
Db transaction information, is added in db transaction write queue, and using db transaction major key quantity as at major key
Manage progress value;And
Synchronized transaction execution unit, for using concurrent writing by the database in the db transaction write queue
Affairs are written in standby database, and delete the db transaction positioned at the db transaction write queue top.
2. master/slave data storehouse according to claim 1 sychronisation, wherein the synchronized transaction acquiring unit is being needed
Want to need to obtain the major key of the db transaction, and the master of recording synchronism db transaction during synchronous db transaction information
Key.
3. master/slave data storehouse according to claim 1 sychronisation, wherein the synchronized transaction acquiring unit will need together
It is the major key letter according to the db transaction when db transaction information of step is added in the db transaction write queue
The order ceased in the primary database is write.
4. master/slave data storehouse according to claim 1 sychronisation, wherein the synchronized transaction acquiring unit will need together
When the db transaction information of step is added in the db transaction write queue, write using first in first out pattern.
5. master/slave data storehouse according to claim 1 sychronisation, wherein the synchronized transaction execution unit is included synchronously
Issued transaction component, synchronized transaction write-in component and synchronized transaction complete component, wherein:
Each pending db transaction major key processing progress value of the synchronized transaction processing assembly poll, when major key office
Manage when progress value is 0 and enter the synchronized transaction executive module;
The db transaction that major key processing progress value is 0 is distributed and writes thread execution by the synchronized transaction executive module, is used
Concurrent writing writes the affairs of write queue in standby database;And
The synchronized transaction completes component after the completion of the standby wide area information server affairs of write-in, deletes the database completed
Affairs, delete the db transaction positioned at major key write queue top, the Article 2 db transaction of major key write queue it is automatic into
For the pending affairs of major key write queue, and notify that the db transaction major key processing progress value subtracts one.
6. master/slave data storehouse according to claim 1 sychronisation, wherein master/slave data storehouse sychronisation uses base
In MariaDB database.
7. a kind of master/slave data storehouse synchronous method, comprises the following steps:
By being read out to the db transaction in primary database, obtaining needs synchronous db transaction information, obtains number
According to the major key of storehouse affairs, the major key of recording synchronism db transaction, and using db transaction major key quantity as major key handle into
Angle value;
According to db transaction major key information, the db transaction got is sequentially increased into data according in primary database
In the affairs major key correspondence major key write queue of storehouse;Wherein, need to create new major key write queue for the major key without write queue, and
The affairs are set to write queue top, notify that the major key processing progress value subtracts one;
Each pending db transaction major key processing progress value of poll, enters same when major key issued transaction progress value is 0
Walk affairs executive module;
Major key processing progress value is distributed for 0 db transaction and writes thread and perform, using concurrent writing by write queue
In the standby database of affairs write-in;
After the completion of the standby wide area information server affairs of write-in, the db transaction completed is deleted, deletion writes team positioned at major key
The db transaction on top is arranged, the Article 2 db transaction of major key write queue automatically becomes the pending thing of major key write queue
Business;Notify that the db transaction major key processing progress value subtracts one.
8. master/slave data storehouse according to claim 7 synchronous method, wherein it is described according to db transaction major key information, will
The db transaction got is according to sequentially increasing in db transaction major key correspondence major key write queue in primary database
In step, write using first in first out pattern.
9. master/slave data storehouse according to claim 7 synchronous method, is based on wherein the master/slave data storehouse is used
MariaDB database.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610013943.7A CN105786959A (en) | 2016-01-11 | 2016-01-11 | Synchronization method and device of primary database and spare database |
CN2016100139437 | 2016-01-11 |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106959989A true CN106959989A (en) | 2017-07-18 |
Family
ID=56402317
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610013943.7A Pending CN105786959A (en) | 2016-01-11 | 2016-01-11 | Synchronization method and device of primary database and spare database |
CN201610532157.8A Pending CN106959989A (en) | 2016-01-11 | 2016-07-07 | The synchronous method and device in master/slave data storehouse |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610013943.7A Pending CN105786959A (en) | 2016-01-11 | 2016-01-11 | Synchronization method and device of primary database and spare database |
Country Status (1)
Country | Link |
---|---|
CN (2) | CN105786959A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109918178A (en) * | 2019-03-06 | 2019-06-21 | 恒生电子股份有限公司 | Affairs submit method and relevant apparatus |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110309224B (en) * | 2018-03-14 | 2021-08-31 | 华为技术有限公司 | Data copying method and device |
CN110008284B (en) * | 2019-03-18 | 2021-06-22 | 武汉达梦数据库股份有限公司 | Database data synchronization method and device based on data page preloading and rollback |
CN109977168B (en) * | 2019-03-18 | 2021-11-05 | 武汉达梦数据库股份有限公司 | Database data synchronization method and device based on data page preloading |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020198899A1 (en) * | 2001-06-26 | 2002-12-26 | Hitachi, Ltd. | Method and system of database management for replica database |
CN102098342A (en) * | 2011-01-31 | 2011-06-15 | 华为技术有限公司 | Transaction level-based data synchronizing method, device thereof and system thereof |
CN102629268A (en) * | 2012-03-09 | 2012-08-08 | 华为技术有限公司 | Data synchronization method, system and date access device |
CN103885986A (en) * | 2012-12-21 | 2014-06-25 | 阿里巴巴集团控股有限公司 | Main and auxiliary database synchronization method and device |
CN104111962A (en) * | 2013-04-22 | 2014-10-22 | Sap股份公司 | Enhanced transactional cache with bulk operation |
CN105117304A (en) * | 2015-07-29 | 2015-12-02 | 北京京东尚科信息技术有限公司 | MariaDB-based database recovery system and method |
-
2016
- 2016-01-11 CN CN201610013943.7A patent/CN105786959A/en active Pending
- 2016-07-07 CN CN201610532157.8A patent/CN106959989A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020198899A1 (en) * | 2001-06-26 | 2002-12-26 | Hitachi, Ltd. | Method and system of database management for replica database |
CN102098342A (en) * | 2011-01-31 | 2011-06-15 | 华为技术有限公司 | Transaction level-based data synchronizing method, device thereof and system thereof |
CN102629268A (en) * | 2012-03-09 | 2012-08-08 | 华为技术有限公司 | Data synchronization method, system and date access device |
CN103885986A (en) * | 2012-12-21 | 2014-06-25 | 阿里巴巴集团控股有限公司 | Main and auxiliary database synchronization method and device |
CN104111962A (en) * | 2013-04-22 | 2014-10-22 | Sap股份公司 | Enhanced transactional cache with bulk operation |
CN105117304A (en) * | 2015-07-29 | 2015-12-02 | 北京京东尚科信息技术有限公司 | MariaDB-based database recovery system and method |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109918178A (en) * | 2019-03-06 | 2019-06-21 | 恒生电子股份有限公司 | Affairs submit method and relevant apparatus |
Also Published As
Publication number | Publication date |
---|---|
CN105786959A (en) | 2016-07-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20220058095A1 (en) | System and method for transaction recovery in a multitenant application server environment | |
EP3182300B1 (en) | Table replication in a database environment | |
CN105630863B (en) | Transaction control block for multi-version concurrent commit status | |
US10055440B2 (en) | Database table re-partitioning using trigger-based capture and replay | |
JP6553822B2 (en) | Dividing and moving ranges in distributed systems | |
Baker et al. | Megastore: Providing scalable, highly available storage for interactive services. | |
US9672126B2 (en) | Hybrid data replication | |
US8639677B2 (en) | Database replication techniques for maintaining original linear request order for asynchronous transactional events | |
US8713046B2 (en) | Snapshot isolation support for distributed query processing in a shared disk database cluster | |
CN101133397B (en) | Oplogging for online recovery in direct connection client server systems | |
US8266122B1 (en) | System and method for versioning data in a distributed data store | |
CN104216955B (en) | A kind of operation data and the method, apparatus and distributed system for managing affairs | |
US10754854B2 (en) | Consistent query of local indexes | |
US20150205850A1 (en) | Eager replication of uncommitted transactions | |
US9576038B1 (en) | Consistent query of local indexes | |
CN106959989A (en) | The synchronous method and device in master/slave data storehouse | |
US9390111B2 (en) | Database insert with deferred materialization | |
Padhye et al. | Scalable transaction management with snapshot isolation for NoSQL data storage systems | |
CN106569896A (en) | Data distribution and parallel processing method and system | |
Setty et al. | Realizing the {Fault-Tolerance} Promise of Cloud Storage Using Locks with Intent | |
CN105989049A (en) | Data middle layer realizing method and system | |
US8630976B2 (en) | Fast search replication synchronization processes | |
Ibrahim | Mobile transaction processing for a distributed war environment | |
CN117076147B (en) | Deadlock detection method, device, equipment and storage medium | |
CN109815213A (en) | It is deleted on a kind of Append-Only database and the method and system of modification data |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170718 |
|
RJ01 | Rejection of invention patent application after publication |