CN107066480B - 主备数据库的管理方法、系统及其设备 - Google Patents

主备数据库的管理方法、系统及其设备 Download PDF

Info

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
primary
request
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
Application number
CN201611183638.9A
Other languages
English (en)
Chinese (zh)
Other versions
CN107066480A (zh
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.)
Beijing Oceanbase Technology Co Ltd
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
Priority to CN201611183638.9A priority Critical patent/CN107066480B/zh
Publication of CN107066480A publication Critical patent/CN107066480A/zh
Priority to TW106130943A priority patent/TWI677797B/zh
Priority to SG10202012899PA priority patent/SG10202012899PA/en
Priority to EP17884001.3A priority patent/EP3561694B1/en
Priority to SG10201913120SA priority patent/SG10201913120SA/en
Priority to PCT/CN2017/115392 priority patent/WO2018113543A1/zh
Priority to MYPI2019003464A priority patent/MY199572A/en
Priority to JP2019533442A priority patent/JP6905161B2/ja
Priority to KR1020197021325A priority patent/KR102142233B1/ko
Priority to US16/394,315 priority patent/US10592361B2/en
Priority to PH12019501392A priority patent/PH12019501392A1/en
Application granted granted Critical
Publication of CN107066480B publication Critical patent/CN107066480B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 operations
    • 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 OR CALCULATING; 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 operations
    • 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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)
CN201611183638.9A 2016-12-20 2016-12-20 主备数据库的管理方法、系统及其设备 Active CN107066480B (zh)

Priority Applications (11)

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 主備資料庫的管理方法、系統及其設備
MYPI2019003464A MY199572A (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
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
JP2019533442A JP6905161B2 (ja) 2016-12-20 2017-12-11 マスタおよびスタンバイデータベースのための管理方法、システム、およびデバイス
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 (10)

Country Link
US (1) US10592361B2 (https=)
EP (1) EP3561694B1 (https=)
JP (1) JP6905161B2 (https=)
KR (1) KR102142233B1 (https=)
CN (1) CN107066480B (https=)
MY (1) MY199572A (https=)
PH (1) PH12019501392A1 (https=)
SG (2) SG10201913120SA (https=)
TW (1) TWI677797B (https=)
WO (1) WO2018113543A1 (https=)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
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
CN114490231A (zh) * 2020-11-11 2022-05-13 网联清算有限公司 一种数据库仲裁服务调度方法及系统
CN115168322A (zh) * 2022-07-08 2022-10-11 北京奥星贝斯科技有限公司 数据库系统、主库选举方法及装置
CN116048886A (zh) * 2022-12-30 2023-05-02 蚂蚁区块链科技(上海)有限公司 一种进行区块链节点主备切换的方法和装置
US20240406060A1 (en) * 2023-05-31 2024-12-05 Rakuten Symphony, Inc. Communication network failure detection and restoration

Citations (2)

* Cited by examiner, † Cited by third party
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 (32)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP3572928B2 (ja) * 1998-03-18 2004-10-06 富士通株式会社 バックアップ機能付オンラインデータベース情報処理システム
US6957251B2 (en) * 2001-05-07 2005-10-18 Genworth Financial, Inc. System and method for providing network services using redundant resources
WO2003005245A2 (en) * 2001-07-06 2003-01-16 Computer Associates Think, Inc. Systems and methods of information backup
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 华为技术有限公司 数据库同步方法及系统
JP5199464B2 (ja) * 2009-01-20 2013-05-15 株式会社日立製作所 ストレージシステム及びストレージシステムの制御方法
JP5625243B2 (ja) * 2009-02-26 2014-11-19 日本電気株式会社 情報処理システム、ディザスタリカバリ方法及びディザスタリカバリプログラム
JP2011076512A (ja) * 2009-10-01 2011-04-14 Hitachi Solutions Ltd ジョブ管理サーバーの統合管理システム
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
JP2013161252A (ja) * 2012-02-03 2013-08-19 Fujitsu Ltd 冗長コンピュータ制御プログラム、方法、及び装置
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 中兴通讯股份有限公司 一种数据库主备切换的方法及装置
JP2017102834A (ja) * 2015-12-04 2017-06-08 日本電気株式会社 バックアップシステム
CN105933379B (zh) * 2016-04-01 2018-10-09 浪潮电子信息产业股份有限公司 一种业务处理方法、设备及系统
CN107066480B (zh) * 2016-12-20 2020-08-11 创新先进技术有限公司 主备数据库的管理方法、系统及其设备

Patent Citations (2)

* Cited by examiner, † Cited by third party
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
PH12019501392A1 (en) 2020-02-10
JP6905161B2 (ja) 2021-07-21
EP3561694B1 (en) 2022-06-22
EP3561694A4 (en) 2019-12-18
US10592361B2 (en) 2020-03-17
SG10202012899PA (en) 2021-01-28
JP2020502686A (ja) 2020-01-23
WO2018113543A1 (zh) 2018-06-28
CN107066480A (zh) 2017-08-18
KR20190095443A (ko) 2019-08-14
MY199572A (en) 2023-11-07
KR102142233B1 (ko) 2020-08-07
US20190251008A1 (en) 2019-08-15
SG10201913120SA (en) 2020-03-30
TW201824030A (zh) 2018-07-01
TWI677797B (zh) 2019-11-21
EP3561694A1 (en) 2019-10-30

Similar Documents

Publication Publication Date Title
CN107066480B (zh) 主备数据库的管理方法、系统及其设备
US8169856B2 (en) Time synchronization in cluster systems
US9460183B2 (en) Split brain resistant failover in high availability clusters
JP6382454B2 (ja) 分散ストレージ及びレプリケーションシステム、並びに方法
CN103795553B (zh) 基于监控的主、备服务器切换
CN112887368B (zh) 对复制型数据库的访问进行负载平衡
CN103117901B (zh) 一种分布式心跳检测方法、装置及系统
CN101751415B (zh) 元数据服务系统、元数据同步方法与写服务器更新方法
CN107168970A (zh) 一种分布式文件系统hdfs的管理方法、装置及系统
CN112910694B (zh) 一种归档日志传输的方法、系统及介质
CN104767794A (zh) 一种分布式系统中的节点选举方法及节点
CN116346582A (zh) 一种实现主备双网冗余方法、装置、设备及存储介质
CN109189854B (zh) 提供持续业务的方法及节点设备
CN102841895B (zh) 一种处理数据库状态转移的方法和系统
CN111752758B (zh) 一种双主架构的InfluxDB高可用系统
JP4491167B2 (ja) 通信システムにおける管理装置のバックアップシステム
CN112256484A (zh) 一种数据备份的方法、装置和系统
US20090106781A1 (en) Remote call handling methods and systems
JP2002149459A (ja) 冗長化データベース管理・検索システム
CN114301763B (zh) 分布式集群故障的处理方法及系统、电子设备及存储介质
CN114201473A (zh) 日志管理方法及服务器集群
CA2619778A1 (en) Method and apparatus for sequencing transactions globally in a distributed database cluster with collision monitoring
HK1175563B (zh) 一种处理数据库状态转移的方法和系统
CN116361073A (zh) 数据安全管理方法、装置、设备及存储介质
CN117472691A (zh) 一种数据库集群系统

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

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.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant
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.

TR01 Transfer of patent right