CN105446827B - 一种数据库故障时的数据存储方法和设备 - Google Patents
一种数据库故障时的数据存储方法和设备 Download PDFInfo
- Publication number
- CN105446827B CN105446827B CN201410389882.5A CN201410389882A CN105446827B CN 105446827 B CN105446827 B CN 105446827B CN 201410389882 A CN201410389882 A CN 201410389882A CN 105446827 B CN105446827 B CN 105446827B
- Authority
- CN
- China
- Prior art keywords
- service
- database
- data value
- stored
- service identification
- 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
- 238000000034 method Methods 0.000 title claims abstract description 137
- 230000001360 synchronised effect Effects 0.000 claims abstract description 15
- 238000011144 upstream manufacturing Methods 0.000 claims description 40
- 235000013399 edible fruits Nutrition 0.000 claims 1
- 238000011084 recovery Methods 0.000 description 5
- 230000006399 behavior Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000013500 data storage Methods 0.000 description 2
- 230000004888 barrier function Effects 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
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/2053—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 persistent mass storage functionality or persistent mass storage control functionality is redundant
- G06F11/2094—Redundant storage or storage 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/2365—Ensuring data consistency and integrity
-
- 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
-
- 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
- G06F11/1469—Backup restoration techniques
-
- 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/1474—Saving, restoring, recovering or retrying in transactions
-
- 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/2379—Updates performed during online database operations; commit processing
-
- 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
- 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
-
- 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/1448—Management of the data involved in backup or backup restore
-
- 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/855—Details of asynchronous mirroring using a journal to transfer not-yet-mirrored changes
-
- 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/87—Monitoring of transactions
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)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Computing Systems (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (12)
Priority Applications (9)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410389882.5A CN105446827B (zh) | 2014-08-08 | 2014-08-08 | 一种数据库故障时的数据存储方法和设备 |
KR1020177002848A KR102077898B1 (ko) | 2014-08-08 | 2015-08-07 | 데이터베이스 고장 시의 데이터 저장 |
PL15829030T PL3178022T3 (pl) | 2014-08-08 | 2015-08-07 | Przechowywanie danych po awarii bazy danych |
SG11201700236WA SG11201700236WA (en) | 2014-08-08 | 2015-08-07 | Data storage upon database failure |
EP15829030.4A EP3178022B1 (en) | 2014-08-08 | 2015-08-07 | Data storage upon database failure |
JP2017503894A JP6557323B2 (ja) | 2014-08-08 | 2015-08-07 | データベース障害時のデータ記憶 |
ES15829030T ES2846851T3 (es) | 2014-08-08 | 2015-08-07 | Almacenamiento de datos tras fallo de base de datos |
PCT/US2015/044319 WO2016022976A1 (en) | 2014-08-08 | 2015-08-07 | Data storage upon database failure |
US14/821,385 US10210055B2 (en) | 2014-08-08 | 2015-08-07 | Method and system for data storage upon database failure |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410389882.5A CN105446827B (zh) | 2014-08-08 | 2014-08-08 | 一种数据库故障时的数据存储方法和设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105446827A CN105446827A (zh) | 2016-03-30 |
CN105446827B true CN105446827B (zh) | 2018-12-14 |
Family
ID=55264669
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410389882.5A Active CN105446827B (zh) | 2014-08-08 | 2014-08-08 | 一种数据库故障时的数据存储方法和设备 |
Country Status (9)
Country | Link |
---|---|
US (1) | US10210055B2 (zh) |
EP (1) | EP3178022B1 (zh) |
JP (1) | JP6557323B2 (zh) |
KR (1) | KR102077898B1 (zh) |
CN (1) | CN105446827B (zh) |
ES (1) | ES2846851T3 (zh) |
PL (1) | PL3178022T3 (zh) |
SG (1) | SG11201700236WA (zh) |
WO (1) | WO2016022976A1 (zh) |
Families Citing this family (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106201826B (zh) * | 2016-07-13 | 2018-11-20 | 焦点科技股份有限公司 | 一种诊断Oracle数据库大事务和热点事务的方法 |
CN106909486B (zh) * | 2016-08-03 | 2020-04-17 | 阿里巴巴集团控股有限公司 | 处理业务异常的方法、装置及系统 |
US10810662B1 (en) * | 2016-11-10 | 2020-10-20 | Amazon Technologies, Inc. | Utilizing time-series tables for tracking accumulating values |
CN106776753B (zh) * | 2016-11-14 | 2020-08-21 | 平安科技(深圳)有限公司 | 业务数据处理方法及装置 |
CN109271277B (zh) * | 2017-07-17 | 2022-03-08 | 阿里巴巴集团控股有限公司 | 数据库宕机后的访问方法、装置和系统 |
CN107943619A (zh) * | 2017-12-08 | 2018-04-20 | 四川金英科技有限责任公司 | 一种在数据库故障条件下保证数据完整性的方法 |
CN108089945A (zh) * | 2017-12-08 | 2018-05-29 | 四川金英科技有限责任公司 | 一种在数据库故障条件下保证数据完整性的方法和系统 |
CN108089944A (zh) * | 2017-12-08 | 2018-05-29 | 四川金英科技有限责任公司 | 一种在数据库故障条件下保证数据完整性的系统 |
CN110298666B (zh) * | 2019-06-21 | 2022-08-30 | 网联清算有限公司 | 交易处理过程中的异常处理方法及装置 |
CN111835846B (zh) * | 2020-07-09 | 2022-10-11 | 北京字节跳动网络技术有限公司 | 信息更新方法、装置和电子设备 |
US11409605B2 (en) | 2020-10-20 | 2022-08-09 | Sap Se | Failover system for database unavailability |
CN114244690A (zh) * | 2021-12-30 | 2022-03-25 | 深圳市潮流网络技术有限公司 | 故障处理方法、装置、网络设备和存储介质 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO1998040827A1 (en) * | 1997-03-14 | 1998-09-17 | Lakeview Technology | Method and system for defining transactions from a database log |
US7437609B2 (en) * | 2002-05-22 | 2008-10-14 | Oracle International Corporation | Reliable standby database failover |
CN102299904A (zh) * | 2010-06-23 | 2011-12-28 | 阿里巴巴集团控股有限公司 | 一种实现业务数据备份的系统及方法 |
CN102891849A (zh) * | 2012-09-25 | 2013-01-23 | 北京星网锐捷网络技术有限公司 | 业务数据同步方法、恢复方法及装置和网络设备 |
Family Cites Families (19)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5799323A (en) | 1995-01-24 | 1998-08-25 | Tandem Computers, Inc. | Remote duplicate databased facility with triple contingency protection |
JP4689137B2 (ja) * | 2001-08-08 | 2011-05-25 | 株式会社日立製作所 | リモートコピー制御方法、及びストレージシステム |
US6751636B1 (en) | 2000-12-05 | 2004-06-15 | Silicon Graphics, Inc. | System and method for maintaining and recovering data consistency across multiple instances of a database |
US7464113B1 (en) | 2001-05-10 | 2008-12-09 | Oracle International Corporations | Disaster recovery with bounded data loss |
JP4289056B2 (ja) * | 2003-03-27 | 2009-07-01 | 株式会社日立製作所 | 計算機システム間のデータ二重化制御方法 |
JP2005309550A (ja) * | 2004-04-19 | 2005-11-04 | Hitachi Ltd | リモートコピー方法及びリモートコピーシステム |
JP4412989B2 (ja) * | 2003-12-15 | 2010-02-10 | 株式会社日立製作所 | 複数の記憶システムを有するデータ処理システム |
JP4452533B2 (ja) * | 2004-03-19 | 2010-04-21 | 株式会社日立製作所 | システムおよび記憶装置システム |
US7499954B2 (en) | 2004-11-01 | 2009-03-03 | International Business Machines Corporation | Consistent reintegration of a failed primary instance |
US7519859B2 (en) * | 2005-08-30 | 2009-04-14 | International Business Machines Corporation | Fault recovery for transaction server |
US7711712B2 (en) | 2007-03-12 | 2010-05-04 | Hitachi, Ltd. | System and method for managing consistency among volumes based on application information |
US8086564B2 (en) * | 2007-12-12 | 2011-12-27 | Oracle International Corporation | Techniques for the logical replication of high-level procedures |
GB2472620B (en) * | 2009-08-12 | 2016-05-18 | Cloudtran Inc | Distributed transaction processing |
JP5691246B2 (ja) * | 2010-05-27 | 2015-04-01 | 富士通株式会社 | データベース二重化システム、情報処理装置及びデータベース二重化方法 |
US8490088B2 (en) * | 2010-09-10 | 2013-07-16 | International Business Machines Corporation | On demand virtual machine image streaming |
US8775381B1 (en) | 2011-05-14 | 2014-07-08 | Pivotal Software, Inc. | Parallel database mirroring |
US8667033B1 (en) | 2011-05-14 | 2014-03-04 | Gopivotal, Inc. | Persistent file system objects for management of databases |
US8850261B2 (en) * | 2011-06-01 | 2014-09-30 | Microsoft Corporation | Replaying jobs at a secondary location of a service |
US20150006478A1 (en) | 2013-06-28 | 2015-01-01 | Silicon Graphics International Corp. | Replicated database using one sided rdma |
-
2014
- 2014-08-08 CN CN201410389882.5A patent/CN105446827B/zh active Active
-
2015
- 2015-08-07 ES ES15829030T patent/ES2846851T3/es active Active
- 2015-08-07 PL PL15829030T patent/PL3178022T3/pl unknown
- 2015-08-07 US US14/821,385 patent/US10210055B2/en active Active
- 2015-08-07 EP EP15829030.4A patent/EP3178022B1/en active Active
- 2015-08-07 KR KR1020177002848A patent/KR102077898B1/ko active IP Right Grant
- 2015-08-07 JP JP2017503894A patent/JP6557323B2/ja active Active
- 2015-08-07 SG SG11201700236WA patent/SG11201700236WA/en unknown
- 2015-08-07 WO PCT/US2015/044319 patent/WO2016022976A1/en active Application Filing
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO1998040827A1 (en) * | 1997-03-14 | 1998-09-17 | Lakeview Technology | Method and system for defining transactions from a database log |
US7437609B2 (en) * | 2002-05-22 | 2008-10-14 | Oracle International Corporation | Reliable standby database failover |
CN102299904A (zh) * | 2010-06-23 | 2011-12-28 | 阿里巴巴集团控股有限公司 | 一种实现业务数据备份的系统及方法 |
CN102891849A (zh) * | 2012-09-25 | 2013-01-23 | 北京星网锐捷网络技术有限公司 | 业务数据同步方法、恢复方法及装置和网络设备 |
Also Published As
Publication number | Publication date |
---|---|
KR102077898B1 (ko) | 2020-02-14 |
JP6557323B2 (ja) | 2019-08-07 |
WO2016022976A1 (en) | 2016-02-11 |
PL3178022T3 (pl) | 2021-05-17 |
EP3178022A1 (en) | 2017-06-14 |
ES2846851T3 (es) | 2021-07-29 |
JP2017524190A (ja) | 2017-08-24 |
SG11201700236WA (en) | 2017-02-27 |
US10210055B2 (en) | 2019-02-19 |
EP3178022A4 (en) | 2018-01-24 |
US20160041886A1 (en) | 2016-02-11 |
KR20170041712A (ko) | 2017-04-17 |
CN105446827A (zh) | 2016-03-30 |
EP3178022B1 (en) | 2020-12-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105446827B (zh) | 一种数据库故障时的数据存储方法和设备 | |
CN105357038B (zh) | 监控虚拟机集群的方法和系统 | |
CN110213371A (zh) | 消息消费方法、装置、设备及计算机存储介质 | |
CN105302676B (zh) | 一种分布式文件系统的主备机制数据传输方法及装置 | |
CN105426275B (zh) | 双活集群系统中容灾的方法及装置 | |
CN110807064B (zh) | Rac分布式数据库集群系统中的数据恢复装置 | |
CN109743358A (zh) | 异步消息接口熔断控制方法、装置、计算机设备及存储介质 | |
CN110505141B (zh) | 即时通讯消息的处理方法、装置、可读介质及电子设备 | |
US10609133B2 (en) | Method and device for establishing communication connection | |
CN104182683B (zh) | 一种联机事务的监控方法、装置及系统 | |
CN108805667A (zh) | 订单流程处理方法和系统 | |
CN105528264B (zh) | 防误操作的数据恢复方法及其系统 | |
CN107797896B (zh) | 一种流量数据自恢复处理方法和服务器 | |
CN108052094A (zh) | 一种扩展卡识别方法、装置及变频器 | |
CN106331081B (zh) | 一种信息同步方法及装置 | |
CN116974874A (zh) | 数据库的测试方法、装置、电子设备及可读存储介质 | |
CN105760251B (zh) | 一种备份数据的方法和装置 | |
CN107908481A (zh) | 一种数据同步方法、装置和系统 | |
CN106060048A (zh) | 一种网络资源访问方法和装置 | |
CN108156061A (zh) | esb监控服务平台 | |
CN112134764A (zh) | 测试环境连通性的确定方法及装置 | |
CN110399290A (zh) | 消息推送的测试装置、方法及存储介质 | |
CN110046199A (zh) | 交易数据的同步方法、装置及电子设备 | |
CN109634787A (zh) | 分布式文件系统监控器切换方法、装置、设备及存储介质 | |
JPH0888672A (ja) | インテリジェント通信プロトコルモニタ装置 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20200928 Address after: 27 Hospital Road, George Town, Grand Cayman ky1-9008 Patentee after: Innovative advanced technology Co.,Ltd. Address before: 27 Hospital Road, George Town, Grand Cayman ky1-9008 Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200928 Address after: 27 Hospital Road, George Town, Grand Cayman ky1-9008 Patentee after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20240222 Address after: Guohao Times City # 20-01, 128 Meizhi Road, Singapore Patentee after: Advanced Nova Technology (Singapore) Holdings Ltd. Country or region after: Singapore Address before: 27 Hospital Road, George Town, Grand Cayman ky1-9008 Patentee before: Innovative advanced technology Co.,Ltd. Country or region before: United Kingdom |