CN107066480B - 主备数据库的管理方法、***及其设备 - Google Patents
主备数据库的管理方法、***及其设备 Download PDFInfo
- Publication number
- CN107066480B CN107066480B CN201611183638.9A CN201611183638A CN107066480B CN 107066480 B CN107066480 B CN 107066480B CN 201611183638 A CN201611183638 A CN 201611183638A CN 107066480 B CN107066480 B CN 107066480B
- Authority
- CN
- China
- Prior art keywords
- database
- lock
- backup
- master
- main
- 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.)
- Active
Links
Images
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
- 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/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
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
Abstract
Description
Claims (21)
Priority Applications (10)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611183638.9A CN107066480B (zh) | 2016-12-20 | 2016-12-20 | 主备数据库的管理方法、***及其设备 |
TW106130943A TWI677797B (zh) | 2016-12-20 | 2017-09-11 | 主備資料庫的管理方法、系統及其設備 |
JP2019533442A JP6905161B2 (ja) | 2016-12-20 | 2017-12-11 | マスタおよびスタンバイデータベースのための管理方法、システム、およびデバイス |
PCT/CN2017/115392 WO2018113543A1 (zh) | 2016-12-20 | 2017-12-11 | 主备数据库的管理方法、***及其设备 |
SG10202012899PA SG10202012899PA (en) | 2016-12-20 | 2017-12-11 | Method, system and apparatus for managing primary and secondary databases |
EP17884001.3A EP3561694B1 (en) | 2016-12-20 | 2017-12-11 | Management method, system, and device for master and standby databases |
SG10201913120SA SG10201913120SA (en) | 2016-12-20 | 2017-12-11 | Method, system and apparatus for managing primary and secondary databases |
KR1020197021325A KR102142233B1 (ko) | 2016-12-20 | 2017-12-11 | 기본 및 보조 데이터베이스를 관리하기 위한 방법, 시스템 및 장치 |
US16/394,315 US10592361B2 (en) | 2016-12-20 | 2019-04-25 | Method, system and apparatus for managing primary and secondary databases |
PH12019501392A PH12019501392A1 (en) | 2016-12-20 | 2019-06-18 | Method, system and apparatus for managing primary and secondary databases |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611183638.9A CN107066480B (zh) | 2016-12-20 | 2016-12-20 | 主备数据库的管理方法、***及其设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107066480A CN107066480A (zh) | 2017-08-18 |
CN107066480B true CN107066480B (zh) | 2020-08-11 |
Family
ID=59619184
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611183638.9A Active CN107066480B (zh) | 2016-12-20 | 2016-12-20 | 主备数据库的管理方法、***及其设备 |
Country Status (9)
Country | Link |
---|---|
US (1) | US10592361B2 (zh) |
EP (1) | EP3561694B1 (zh) |
JP (1) | JP6905161B2 (zh) |
KR (1) | KR102142233B1 (zh) |
CN (1) | CN107066480B (zh) |
PH (1) | PH12019501392A1 (zh) |
SG (2) | SG10202012899PA (zh) |
TW (1) | TWI677797B (zh) |
WO (1) | WO2018113543A1 (zh) |
Families Citing this family (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107066480B (zh) | 2016-12-20 | 2020-08-11 | 创新先进技术有限公司 | 主备数据库的管理方法、***及其设备 |
US10999392B2 (en) | 2019-03-01 | 2021-05-04 | Accenture Global Solutions Limited | Message recovery system for computing nodes with replicated databases |
CN110442650A (zh) * | 2019-08-09 | 2019-11-12 | 中国工商银行股份有限公司 | 数据库切换方法、装置、***、电子设备及存储介质 |
CN110765143B (zh) * | 2019-10-10 | 2022-08-02 | 腾讯科技(深圳)有限公司 | 数据处理方法、装置、服务器和存储介质 |
CN111159156B (zh) * | 2019-12-31 | 2023-04-28 | 杭州迪普科技股份有限公司 | SQLite数据库的备份方法和装置 |
US11379477B2 (en) | 2020-03-31 | 2022-07-05 | Sap Se | Efficient workload balancing in replicated databases based on result lag computation |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102739451A (zh) * | 2012-06-29 | 2012-10-17 | 华为技术有限公司 | 一种主备切换条件更新方法、装置、服务器及*** |
CN102891849A (zh) * | 2012-09-25 | 2013-01-23 | 北京星网锐捷网络技术有限公司 | 业务数据同步方法、恢复方法及装置和网络设备 |
Family Cites Families (24)
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 (zh) * | 2005-07-21 | 2008-01-16 | 上海华为技术有限公司 | 一种双机备份实现方法及*** |
CN100449548C (zh) * | 2007-04-11 | 2009-01-07 | 华为技术有限公司 | 数据库同步方法及*** |
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 (zh) * | 2011-06-17 | 2019-03-01 | 中兴通讯股份有限公司 | Enum-dns的容灾方法及enum-dns |
US8719225B1 (en) * | 2012-01-17 | 2014-05-06 | Amazon Technologies, Inc. | System and method for log conflict detection and resolution in a data store |
US9116862B1 (en) * | 2012-01-17 | 2015-08-25 | Amazon Technologies, Inc. | System and method for data replication using a single master failover protocol |
US9009444B1 (en) * | 2012-09-29 | 2015-04-14 | Emc Corporation | System and method for LUN control management |
CN102945195B (zh) * | 2012-11-26 | 2015-11-18 | 国电南瑞科技股份有限公司 | 一种基于SQLite数据库的主备冗余复制方法 |
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 (zh) * | 2013-11-12 | 2016-06-22 | 浪潮(北京)电子信息产业有限公司 | 一种基于仲裁盘机制的双机热备方法 |
US20150339200A1 (en) * | 2014-05-20 | 2015-11-26 | Cohesity, Inc. | Intelligent disaster recovery |
TWI529624B (zh) * | 2015-03-19 | 2016-04-11 | Univ Nat Central | Method and system of fault tolerance for multiple servers |
CN104778102A (zh) * | 2015-03-27 | 2015-07-15 | 深圳市创梦天地科技有限公司 | 一种主备切换方法及*** |
CN106202075B (zh) * | 2015-04-29 | 2021-02-19 | 中兴通讯股份有限公司 | 一种数据库主备切换的方法及装置 |
CN105933379B (zh) * | 2016-04-01 | 2018-10-09 | 浪潮电子信息产业股份有限公司 | 一种业务处理方法、设备及*** |
CN107066480B (zh) * | 2016-12-20 | 2020-08-11 | 创新先进技术有限公司 | 主备数据库的管理方法、***及其设备 |
-
2016
- 2016-12-20 CN CN201611183638.9A patent/CN107066480B/zh active Active
-
2017
- 2017-09-11 TW TW106130943A patent/TWI677797B/zh active
- 2017-12-11 SG SG10202012899PA patent/SG10202012899PA/en unknown
- 2017-12-11 JP JP2019533442A patent/JP6905161B2/ja active Active
- 2017-12-11 WO PCT/CN2017/115392 patent/WO2018113543A1/zh unknown
- 2017-12-11 KR KR1020197021325A patent/KR102142233B1/ko active IP Right Grant
- 2017-12-11 EP EP17884001.3A patent/EP3561694B1/en active Active
- 2017-12-11 SG SG10201913120SA patent/SG10201913120SA/en unknown
-
2019
- 2019-04-25 US US16/394,315 patent/US10592361B2/en active Active
- 2019-06-18 PH PH12019501392A patent/PH12019501392A1/en unknown
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102739451A (zh) * | 2012-06-29 | 2012-10-17 | 华为技术有限公司 | 一种主备切换条件更新方法、装置、服务器及*** |
CN102891849A (zh) * | 2012-09-25 | 2013-01-23 | 北京星网锐捷网络技术有限公司 | 业务数据同步方法、恢复方法及装置和网络设备 |
Also Published As
Publication number | Publication date |
---|---|
EP3561694B1 (en) | 2022-06-22 |
CN107066480A (zh) | 2017-08-18 |
PH12019501392A1 (en) | 2020-02-10 |
JP6905161B2 (ja) | 2021-07-21 |
TWI677797B (zh) | 2019-11-21 |
SG10202012899PA (en) | 2021-01-28 |
US10592361B2 (en) | 2020-03-17 |
KR20190095443A (ko) | 2019-08-14 |
KR102142233B1 (ko) | 2020-08-07 |
JP2020502686A (ja) | 2020-01-23 |
EP3561694A4 (en) | 2019-12-18 |
US20190251008A1 (en) | 2019-08-15 |
SG10201913120SA (en) | 2020-03-30 |
TW201824030A (zh) | 2018-07-01 |
EP3561694A1 (en) | 2019-10-30 |
WO2018113543A1 (zh) | 2018-06-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107066480B (zh) | 主备数据库的管理方法、***及其设备 | |
US8169856B2 (en) | Time synchronization in cluster systems | |
CN109005045B (zh) | 主备服务***及主节点故障恢复方法 | |
CN104717077B (zh) | 一种管理数据中心的方法、装置及*** | |
CN111427728B (zh) | 状态管理方法、主备切换方法及电子设备 | |
CN106062717A (zh) | 一种分布式存储复制***和方法 | |
CN110417600B (zh) | 分布式***的节点切换方法、装置及计算机存储介质 | |
CN108600284B (zh) | 一种基于Ceph的虚拟机高可用实现方法及*** | |
US20110161724A1 (en) | Data management apparatus, monitoring apparatus, replica apparatus, cluster system, control method and computer-readable medium | |
CN105959078B (zh) | 一种集群时间同步方法、集群及时间同步*** | |
US20120030323A1 (en) | Method and apparatus for managing data of operation system | |
CN109189854B (zh) | 提供持续业务的方法及节点设备 | |
CN111708668A (zh) | 集群故障的处理方法、装置及电子设备 | |
US8717167B2 (en) | Event detection control method and system | |
EP3570169B1 (en) | Method and system for processing device failure | |
CN108009045B (zh) | 一种主备数据库故障处理方法及装置 | |
JP4491167B2 (ja) | 通信システムにおける管理装置のバックアップシステム | |
CN114301763B (zh) | 分布式集群故障的处理方法及***、电子设备及存储介质 | |
CN113961402A (zh) | 一种虚拟化集群的管理方法、装置、设备及介质 | |
CN112256484A (zh) | 一种数据备份的方法、装置和*** | |
CN114598711A (zh) | 一种数据迁移方法、装置、设备及介质 | |
CN108933873B (zh) | 一种用户数据的同步方法及装置 | |
CN112527552A (zh) | 容灾方法、装置、局点和存储介质 | |
CN112714143A (zh) | 分布式存储***的服务协调方法、装置及电子设备 | |
JP6289214B2 (ja) | 情報処理システム及びその方法 |
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 | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20191211 Address after: P.O. Box 31119, grand exhibition hall, hibiscus street, 802 West Bay Road, Grand Cayman, Cayman Islands Applicant after: Innovative advanced technology Co., Ltd Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Co., Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210209 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: Ky1-1205 P.O. Box 31119, hibiscus street, 802 Sai Wan Road, Grand Cayman Islands, ky1-1205 Patentee before: Innovative advanced technology Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210914 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Patentee after: Beijing Aoxing Beisi Technology Co., Ltd Address before: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Patentee before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |