SG10202012899PA - Method, system and apparatus for managing primary and secondary databases - Google Patents

Method, system and apparatus for managing primary and secondary databases

Info

Publication number
SG10202012899PA
SG10202012899PA SG10202012899PA SG10202012899PA SG10202012899PA SG 10202012899P A SG10202012899P A SG 10202012899PA SG 10202012899P A SG10202012899P A SG 10202012899PA SG 10202012899P A SG10202012899P A SG 10202012899PA SG 10202012899P A SG10202012899P A SG 10202012899PA
Authority
SG
Singapore
Prior art keywords
secondary databases
managing primary
managing
primary
databases
Prior art date
Application number
SG10202012899PA
Inventor
Zhenkun Yang
Gui Huang
Original Assignee
Advanced New Technologies 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 Advanced New Technologies Co Ltd filed Critical Advanced New Technologies Co Ltd
Publication of SG10202012899PA publication Critical patent/SG10202012899PA/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/202—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant
    • G06F11/2041—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant with more than one idle spare processing component
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14—Error detection or correction of the data by redundancy in operation
    • G06F11/1402—Saving, restoring, recovering or retrying
    • G06F11/1446—Point-in-time backing up or restoration of persistent data
    • G06F11/1458—Management of the backup or restore process
    • 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/21—Design, administration or maintenance of databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14—Error detection or correction of the data by redundancy in operation
    • G06F11/1402—Saving, restoring, recovering or retrying
    • G06F11/1415—Saving, restoring, recovering or retrying at system level
    • G06F11/142—Reconfiguring to eliminate the error
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/202—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant
    • G06F11/2023—Failover techniques
    • G06F11/2025—Failover techniques using centralised failover control functionality
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/202—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant
    • G06F11/2023—Failover techniques
    • G06F11/2028—Failover techniques eliminating a faulty processor or activating a spare
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/202—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant
    • G06F11/2023—Failover techniques
    • G06F11/2033—Failover techniques switching over of hardware resources
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/202—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant
    • G06F11/2043—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where processing functionality is redundant where the redundant components share a common memory address space
    • 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/23—Updating
    • G06F16/2308—Concurrency control
    • G06F16/2336—Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
    • G06F16/2343—Locking methods, e.g. distributed locking or locking implementation details
    • 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80—Database-specific techniques
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/825—Indexing scheme relating to error detection, to error correction, and to monitoring the problem or solution involving locking
SG10202012899PA 2016-12-20 2017-12-11 Method, system and apparatus for managing primary and secondary databases SG10202012899PA (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201611183638.9A CN107066480B (en) 2016-12-20 2016-12-20 Method, system and equipment for managing main and standby databases

Publications (1)

Publication Number Publication Date
SG10202012899PA true SG10202012899PA (en) 2021-01-28

Family

ID=59619184

Family Applications (2)

Application Number Title Priority Date Filing Date
SG10202012899PA SG10202012899PA (en) 2016-12-20 2017-12-11 Method, system and apparatus for managing primary and secondary databases
SG10201913120SA SG10201913120SA (en) 2016-12-20 2017-12-11 Method, system and apparatus for managing primary and secondary databases

Family Applications After (1)

Application Number Title Priority Date Filing Date
SG10201913120SA SG10201913120SA (en) 2016-12-20 2017-12-11 Method, system and apparatus for managing primary and secondary databases

Country Status (9)

Country Link
US (1) US10592361B2 (en)
EP (1) EP3561694B1 (en)
JP (1) JP6905161B2 (en)
KR (1) KR102142233B1 (en)
CN (1) CN107066480B (en)
PH (1) PH12019501392A1 (en)
SG (2) SG10202012899PA (en)
TW (1) TWI677797B (en)
WO (1) WO2018113543A1 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107066480B (en) 2016-12-20 2020-08-11 创新先进技术有限公司 Method, system and equipment for managing main and standby databases
US10999392B2 (en) * 2019-03-01 2021-05-04 Accenture Global Solutions Limited Message recovery system for computing nodes with replicated databases
CN110442650A (en) * 2019-08-09 2019-11-12 中国工商银行股份有限公司 Database switching method, device, system, electronic equipment and storage medium
CN110765143B (en) * 2019-10-10 2022-08-02 腾讯科技（深圳）有限公司 Data processing method, device, server and storage medium
CN111159156B (en) * 2019-12-31 2023-04-28 杭州迪普科技股份有限公司 Backup method and device for SQLite database
US11379477B2 (en) * 2020-03-31 2022-07-05 Sap Se Efficient workload balancing in replicated databases based on result lag computation

Family Cites Families (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040003317A1 (en) * 2002-06-27 2004-01-01 Atul Kwatra Method and apparatus for implementing fault detection and correction in a computer system that requires high reliability and system manageability
US7254736B2 (en) * 2002-12-18 2007-08-07 Veritas Operating Corporation Systems and method providing input/output fencing in shared storage environments
US7284151B2 (en) * 2003-07-21 2007-10-16 Oracle International Corporation Conditional data access after database system failure
TWI306241B (en) * 2004-07-12 2009-02-11 Infortrend Technology Inc A controller capable of self-monitoring, a redundant storage system having the same, and its method
US7496701B2 (en) * 2004-11-18 2009-02-24 International Business Machines Corporation Managing virtual server control of computer support systems with heartbeat message
CN100362482C (en) * 2005-07-21 2008-01-16 上海华为技术有限公司 Dual-machine back-up realizing method and system
CN100449548C (en) * 2007-04-11 2009-01-07 华为技术有限公司 Method and system for synchronizing data base
US9575985B2 (en) * 2009-12-07 2017-02-21 Novell, Inc. Distributed lock administration
US8984328B2 (en) * 2011-03-11 2015-03-17 Microsoft Technology Licensing, Llc Fault tolerance in a parallel database system
US9348883B2 (en) * 2011-06-01 2016-05-24 Clustrix, Inc. Systems and methods for replication replay in a relational database
CN102831038B (en) * 2011-06-17 2019-03-01 中兴通讯股份有限公司 The disaster recovery method and ENUM-DNS of ENUM-DNS
US9116862B1 (en) * 2012-01-17 2015-08-25 Amazon Technologies, Inc. System and method for data replication using a single master failover protocol
US8719225B1 (en) * 2012-01-17 2014-05-06 Amazon Technologies, Inc. System and method for log conflict detection and resolution in a data store
CN102739451B (en) * 2012-06-29 2014-12-03 华为技术有限公司 Method and device for updating master-slave switchover condition, server and system
CN102891849B (en) * 2012-09-25 2015-07-22 北京星网锐捷网络技术有限公司 Service data synchronization method, data recovery method, data recovery device and network device
US9009444B1 (en) * 2012-09-29 2015-04-14 Emc Corporation System and method for LUN control management
CN102945195B (en) * 2012-11-26 2015-11-18 国电南瑞科技股份有限公司 A kind of Master-standby redundancy replication method based on SQLite database
US9667490B1 (en) * 2013-06-05 2017-05-30 Parallels IP Holdings GmbH Method for high availability of services in cloud computing systems
US9274902B1 (en) * 2013-08-07 2016-03-01 Amazon Technologies, Inc. Distributed computing fault management
CN103593266B (en) * 2013-11-12 2016-06-22 浪潮(北京)电子信息产业有限公司 A kind of double hot standby method based on arbitration disk mechanism
US20150339200A1 (en) * 2014-05-20 2015-11-26 Cohesity, Inc. Intelligent disaster recovery
TWI529624B (en) * 2015-03-19 2016-04-11 Univ Nat Central Method and system of fault tolerance for multiple servers
CN104778102A (en) * 2015-03-27 2015-07-15 深圳市创梦天地科技有限公司 Master-slave switching method and system
CN106202075B (en) * 2015-04-29 2021-02-19 中兴通讯股份有限公司 Method and device for switching between main database and standby database
CN105933379B (en) * 2016-04-01 2018-10-09 浪潮电子信息产业股份有限公司 A kind of method for processing business, equipment and system
CN107066480B (en) * 2016-12-20 2020-08-11 创新先进技术有限公司 Method, system and equipment for managing main and standby databases

Also Published As

Publication number Publication date
KR102142233B1 (en) 2020-08-07
US20190251008A1 (en) 2019-08-15
US10592361B2 (en) 2020-03-17
JP6905161B2 (en) 2021-07-21
CN107066480B (en) 2020-08-11
TW201824030A (en) 2018-07-01
EP3561694B1 (en) 2022-06-22
JP2020502686A (en) 2020-01-23
TWI677797B (en) 2019-11-21
WO2018113543A1 (en) 2018-06-28
EP3561694A1 (en) 2019-10-30
PH12019501392A1 (en) 2020-02-10
KR20190095443A (en) 2019-08-14
SG10201913120SA (en) 2020-03-30
EP3561694A4 (en) 2019-12-18
CN107066480A (en) 2017-08-18

Similar Documents

Publication Publication Date Title
HK1249233A1 (en) Methods and apparatus for a distributed database within a network
SG10201913120SA (en) Method, system and apparatus for managing primary and secondary databases
EP3173944A4 (en) Database access method and apparatus and database system
EP3170143A4 (en) System, method, and apparatus for providing and managing intra-day reservations
EP3226152A4 (en) Service data query method and apparatus and database system
EP3341865A4 (en) System and method for database query
EP3680787A4 (en) Method for synchronization between primary database and standby database, database system and device
EP3353957A4 (en) Method and system for identifying network loops
EP3534648A4 (en) Access method for access point, apparatus, and system
EP3147789A4 (en) Method for re-establishing standby database, and apparatus thereof
EP3512610C0 (en) System, apparatus and method for flame arrester
EP3416351A4 (en) Implementation method, apparatus and system for remote access
EP3277006A4 (en) Method, apparatus and system for authorizing access point name
TWI561028B (en) Method for managing a storage system, and associated apparatus
TWI560558B (en) Method for managing a storage system, and associated apparatus
ZA201707590B (en) Method and system for managing trusts
GB2548015B (en) Apparatus and method for gas and beer waste management
GB201602751D0 (en) System and method for knowledge management