CN114785789B - 数据库故障管理方法、装置、电子设备及存储介质 - Google Patents
数据库故障管理方法、装置、电子设备及存储介质 Download PDFInfo
- Publication number
- CN114785789B CN114785789B CN202210445749.1A CN202210445749A CN114785789B CN 114785789 B CN114785789 B CN 114785789B CN 202210445749 A CN202210445749 A CN 202210445749A CN 114785789 B CN114785789 B CN 114785789B
- Authority
- CN
- China
- Prior art keywords
- database
- service
- master
- management node
- management
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 359
- 238000013515 script Methods 0.000 claims abstract description 89
- 238000001514 detection method Methods 0.000 claims abstract description 70
- 230000002159 abnormal effect Effects 0.000 claims abstract description 64
- 238000011084 recovery Methods 0.000 claims abstract description 34
- 238000000034 method Methods 0.000 claims abstract description 22
- 230000000694 effects Effects 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 11
- 238000012546 transfer Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 abstract description 7
- 230000006870 function Effects 0.000 description 12
- 238000004891 communication Methods 0.000 description 8
- 230000005856 abnormality Effects 0.000 description 6
- 238000013473 artificial intelligence Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 101100264195 Caenorhabditis elegans app-1 gene Proteins 0.000 description 3
- 238000013523 data management Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 238000012384 transportation and delivery Methods 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000000802 evaporation-induced self-assembly Methods 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/06—Management of faults, events, alarms or notifications
- H04L41/0654—Management of faults, events, alarms or notifications using network fault recovery
- H04L41/0668—Management of faults, events, alarms or notifications using network fault recovery by dynamic selection of recovery network elements, e.g. replacement by the most appropriate element after failure
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/08—Monitoring or testing based on specific metrics, e.g. QoS, energy consumption or environmental parameters
- H04L43/0823—Errors, e.g. transmission errors
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/104—Peer-to-peer [P2P] networks
- H04L67/1044—Group management mechanisms
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1095—Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1097—Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Theoretical Computer Science (AREA)
- Environmental & Geological Engineering (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (8)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202210445749.1A CN114785789B (zh) | 2022-04-26 | 2022-04-26 | 数据库故障管理方法、装置、电子设备及存储介质 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202210445749.1A CN114785789B (zh) | 2022-04-26 | 2022-04-26 | 数据库故障管理方法、装置、电子设备及存储介质 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN114785789A CN114785789A (zh) | 2022-07-22 |
CN114785789B true CN114785789B (zh) | 2024-01-16 |
Family
ID=82433228
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202210445749.1A Active CN114785789B (zh) | 2022-04-26 | 2022-04-26 | 数据库故障管理方法、装置、电子设备及存储介质 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114785789B (zh) |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108710673A (zh) * | 2018-05-17 | 2018-10-26 | 招银云创(深圳)信息技术有限公司 | 实现数据库高可用方法、系统、计算机设备和存储介质 |
CN108833131A (zh) * | 2018-04-25 | 2018-11-16 | 北京百度网讯科技有限公司 | 分布式数据库云服务的系统、方法、设备和计算机存储介质 |
CN111460039A (zh) * | 2020-04-07 | 2020-07-28 | 中国建设银行股份有限公司 | 关系型数据库处理系统、客户端、服务器及方法 |
CN111581287A (zh) * | 2020-05-07 | 2020-08-25 | 上海茂声智能科技有限公司 | 一种数据库管理的控制方法、系统和存储介质 |
CN111597079A (zh) * | 2020-05-21 | 2020-08-28 | 山东汇贸电子口岸有限公司 | 针对MySQL Galera集群故障的检测和恢复方法及系统 |
CN111679925A (zh) * | 2019-03-11 | 2020-09-18 | 阿里巴巴集团控股有限公司 | 数据库故障处理方法、装置、计算设备和存储介质 |
CN111966520A (zh) * | 2020-08-10 | 2020-11-20 | 上海中通吉网络技术有限公司 | 数据库高可用切换方法、设备及系统 |
CN114116912A (zh) * | 2022-01-25 | 2022-03-01 | 北京浩瀚深度信息技术股份有限公司 | 一种基于Keepalived实现数据库高可用的方法 |
-
2022
- 2022-04-26 CN CN202210445749.1A patent/CN114785789B/zh active Active
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108833131A (zh) * | 2018-04-25 | 2018-11-16 | 北京百度网讯科技有限公司 | 分布式数据库云服务的系统、方法、设备和计算机存储介质 |
CN108710673A (zh) * | 2018-05-17 | 2018-10-26 | 招银云创(深圳)信息技术有限公司 | 实现数据库高可用方法、系统、计算机设备和存储介质 |
CN111679925A (zh) * | 2019-03-11 | 2020-09-18 | 阿里巴巴集团控股有限公司 | 数据库故障处理方法、装置、计算设备和存储介质 |
CN111460039A (zh) * | 2020-04-07 | 2020-07-28 | 中国建设银行股份有限公司 | 关系型数据库处理系统、客户端、服务器及方法 |
CN111581287A (zh) * | 2020-05-07 | 2020-08-25 | 上海茂声智能科技有限公司 | 一种数据库管理的控制方法、系统和存储介质 |
CN111597079A (zh) * | 2020-05-21 | 2020-08-28 | 山东汇贸电子口岸有限公司 | 针对MySQL Galera集群故障的检测和恢复方法及系统 |
CN111966520A (zh) * | 2020-08-10 | 2020-11-20 | 上海中通吉网络技术有限公司 | 数据库高可用切换方法、设备及系统 |
CN114116912A (zh) * | 2022-01-25 | 2022-03-01 | 北京浩瀚深度信息技术股份有限公司 | 一种基于Keepalived实现数据库高可用的方法 |
Also Published As
Publication number | Publication date |
---|---|
CN114785789A (zh) | 2022-07-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10152382B2 (en) | Method and system for monitoring virtual machine cluster | |
US20070038885A1 (en) | Method for operating an arrangement of a plurality of computers in the event of a computer failure | |
CN113360579A (zh) | 数据库高可用处理方法、装置、电子设备及存储介质 | |
CN105468717A (zh) | 数据库操作方法和装置 | |
CN111651471A (zh) | 目标数据查询方法、装置、电子设备及存储介质 | |
CN111625252A (zh) | 集群的升级维护方法、装置、电子设备及存储介质 | |
CN114816820A (zh) | chproxy集群故障修复方法、装置、设备及存储介质 | |
CN115118738B (zh) | 基于rdma的灾备方法、装置、设备及介质 | |
CN111538573A (zh) | 异步任务处理方法、装置及计算机可读存储介质 | |
CN111858161A (zh) | 云主机的容灾方法、装置、设备及计算机可读存储介质 | |
CN114785789B (zh) | 数据库故障管理方法、装置、电子设备及存储介质 | |
CN114185502B (zh) | 基于产线环境的日志打印方法、装置、设备及介质 | |
CN115687384A (zh) | Uuid标识生成方法、装置、设备及存储介质 | |
CN114385453A (zh) | 数据库集群异常处理方法、装置、设备及介质 | |
CN114237982A (zh) | 系统灾备切换方法、装置、设备及存储介质 | |
CN114371962A (zh) | 数据采集方法、装置、电子设备及存储介质 | |
CN114510400A (zh) | 任务执行方法、装置、电子设备及存储介质 | |
CN117851520B (zh) | 证券核心交易引擎的数据同步方法、系统、设备及介质 | |
CN113542387B (zh) | 系统发布方法、装置、电子设备及存储介质 | |
CN114706715B (zh) | 一种基于bmc的分布式raid的控制方法、装置、设备及介质 | |
CN116860508B (zh) | 分布式系统软件缺陷连续自愈方法、装置、设备及介质 | |
CN113656208B (zh) | 分布式存储系统数据处理方法、装置、设备及存储介质 | |
CN116401104A (zh) | 应用数据源切换方法、装置、设备及介质 | |
CN114185777A (zh) | 基于场景链的测试方法、装置、设备及介质 | |
CN116820988A (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: 20231214 Address after: 730050 27th floor, Lanzhou central office building, No.16 Xijin West Road, Qilihe district, Lanzhou City, Gansu Province Applicant after: Yongcheng Hengyi Network Technology Co.,Ltd. Address before: Room 202, Block B, Aerospace Micromotor Building, No. 7 Langshan 2nd Road, Xili Street, Nanshan District, Shenzhen City, Guangdong Province, 518057 Applicant before: Shenzhen LIAN intellectual property service center Effective date of registration: 20231214 Address after: Room 202, Block B, Aerospace Micromotor Building, No. 7 Langshan 2nd Road, Xili Street, Nanshan District, Shenzhen City, Guangdong Province, 518057 Applicant after: Shenzhen LIAN intellectual property service center Address before: 518000 Room 201, building A, 1 front Bay Road, Shenzhen Qianhai cooperation zone, Shenzhen, Guangdong Applicant before: PING AN PUHUI ENTERPRISE MANAGEMENT Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant |