Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Implementation method and system for keeping high availability of Oracle database service

An implementation method and database technology, applied in the implementation and system fields of maintaining high availability of Oracle database services, can solve problems such as long failover time, inability to provide real-time comprehensive high-availability services, and long-term business suspension, and reduce maintenance complexity. , high availability, the effect of reducing maintenance operations

Active Publication Date: 2012-12-05
BEIJING BYTEDANCE NETWORK TECH CO LTD
View PDF3 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0028] The present invention mainly solves the problem of long-term service interruption caused by service interruption on a large-scale ORACLE database software platform. The traditional DataGuard disaster recovery solution cannot provide real-time and comprehensive high-availability services, and the failover time is long. Once the switchover is performed, the front-end application program Insufficiencies such as modifications must also be made synchronously. By introducing DRBD (Distributed Replicated Block Device) and Keepalived software into the existing DataGuard environment, a fast, reliable, easy-to-implement and maintain, and fast-recovery database service high availability is provided. Comprehensive solution

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Implementation method and system for keeping high availability of Oracle database service
  • Implementation method and system for keeping high availability of Oracle database service
  • Implementation method and system for keeping high availability of Oracle database service

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment approach

[0084] image 3 It shows an infrastructure diagram of an implementation method for maintaining high availability of Oracle database services according to an embodiment of the present invention. The specific implementation is as follows:

[0085] 1. Create a DRBD shared disk

[0086] The DRBD data protection module uses the built-in C-type full synchronization protocol of DRBD to maintain the consistency of the data between the master and the slave, ensuring that data will not be lost even if the master goes down unexpectedly. Using DRBD to ensure that the primary role in the Dataguard environment always exists, which is equivalent to avoiding the failover situation, and realizing that no matter when and under what circumstances the switch operation is performed, it will not affect the Dataguard environment.

[0087] According to the function of the DRBD data protection module mentioned above, DRBD provides data consistency protection between master and slave nodes. Considering that...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method for keeping high availability of an Oracle database service, and discloses an implementation method for keeping the high availability of the Oracle database service. The method comprises the following steps of: distributing virtual Internet protocols (IP) for database nodes; and performing heartbeat detection on the database nodes, judging whether a master database node and a slave database node are alive, when the master database node cannot be accessed, automatically drifting the virtual IP to the slave database node, and switching the identity of the slave database node to be the identity of master database nodes. The invention also discloses a system for keeping the high availability of the Oracle database service. The method and the system are specifically suitable for the DATAGUARD characteristic of the Oracle database; due to combined matching with open source software DRBD and Keepalived, in switchover (planned switchover and lossless switchover) or failover (non-planned switchover and lossy switchover), on the premise that data are not lost, master to slave switching of the database can be realized; and the high availability of the database service can be kept.

Description

Technical field [0001] The present invention relates to a method for maintaining high availability of ORACLE database services, and is particularly suitable for the DATAGUARD feature of ORACLE database. Through the combination of open source software DRBD and Keepalived, whether in switchover (planned switch, lossless switch) or failover (planned switch) In the case of external handover and lossy handover), the master-slave switch of the database can be realized without data loss, and the high availability of database services can be guaranteed. Background technique [0002] At present, the Dataguard feature of ORACLE database software (hereinafter referred to as Dataguard) is a commonly used database high-availability solution. It uses a primary (Primary) and multiple slaves (Standby) operating mechanism. When the main database fails, you can upgrade a certain The role of the slave library is the new master library to achieve high availability of database services. [0003] Datag...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 潘海东梅春李丙洋
Owner BEIJING BYTEDANCE NETWORK TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com