CN111046108A - Ceph-based cross-data center Oracle high-availability implementation method - Google Patents
Ceph-based cross-data center Oracle high-availability implementation method Download PDFInfo
- Publication number
- CN111046108A CN111046108A CN201911328587.8A CN201911328587A CN111046108A CN 111046108 A CN111046108 A CN 111046108A CN 201911328587 A CN201911328587 A CN 201911328587A CN 111046108 A CN111046108 A CN 111046108A
- Authority
- CN
- China
- Prior art keywords
- ceph
- center
- storage
- oracle
- data
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000003860 storage Methods 0.000 claims abstract description 49
- 238000005516 engineering process Methods 0.000 claims abstract description 11
- 230000000694 effects Effects 0.000 claims abstract description 9
- 238000011084 recovery Methods 0.000 claims description 5
- 239000000835 fiber Substances 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 description 4
- 230000001360 synchronised effect Effects 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010367 cloning Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- 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/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
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45533—Hypervisors; Virtual machine monitors
- G06F9/45558—Hypervisor-specific management and integration aspects
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a cross-data center Oracle high availability implementation method based on Ceph, which is based on an open source community edition Ceph, wherein the Ceph uses an extension cluster technology in an A production center, a B production center and a C same city backup center, can also realize the cross-double activity data center high availability of application, the Ceph provides block storage for the Oracle Rac cluster to use, the data is stored in multiple copies in different data centers, and the Ceph is divided into three blocks according to scenes, namely object storage, block equipment storage and file system service. The technology of Ceph extension cluster and multiple copies replaces EMC VEPLX double-activity technology, high availability of the applied double-activity crossing data center can be achieved, data are stored in different data centers in multiple copies, Ceph uses an X86 server to form storage hardware, professional storage equipment does not need to be purchased, the price is low, hardware does not need to be locked, and only an X86 server needs to be configured with an SSD and an HDD hard disk.
Description
Technical Field
The invention belongs to the technical field of Ceph, and particularly relates to a cross-data center Oracle high-availability implementation method based on Ceph.
Background
The Oracle RAC is called Oracle Real Application Cluster in full, and is a Real Application Cluster as the name suggests, the whole Cluster system consists of two parts, namely Oracle Cluster Ready software and Real Application Cluster (RAC), the main advantages of the RAC are high availability and load balance, one node fails, and the operation of the whole service cannot be influenced.
At present, storage manufacturers such as EMC, IBM, HDS and the like have double-active storage products and solutions. But generally have limited functionality: native snapshots, clones, or copies, etc. are not supported; simplified provisioning is not supported; only supports FC SAN, does not have NAS and iscsi and the like, and has high price: the purchase price of storage is too high, and the double-active software also needs license, and the expansibility is poor: the storage space is not enough and needs the dilatation storage, needs purchase storage expansion cabinet, hard disk etc. and license also needs the dilatation, and the later stage drops into greatly.
Disclosure of Invention
To solve the problems set forth in the background art described above. The invention provides a cross-data center Oracle high-availability implementation method based on Ceph.
In order to achieve the purpose, the invention provides the following technical scheme: a cross-data center Oracle high-availability implementation method based on Ceph is characterized in that: based on open source community edition Ceph, the Ceph uses an extension cluster technology in an A production center, a B production center and a C city backup center, data is stored in multiple copies in different data centers, the Ceph provides block storage for an Oracle Rac cluster, and the Ceph is divided into three large blocks according to scenes, namely object storage, block device storage and file system service.
Preferably, a plurality of X86 servers are respectively configured in the double live A, B production center and the C city backup center to form a ceph extension cluster.
Preferably, the production center A is configured with 2 copies, the production center B is configured with 2 copies, and the C is configured with 1 copy in the same city backup center, and the total number of the copies is 5, so that the storage plane data multi-copy redundancy is realized.
Preferably, the network implementation method includes that bare fibers are built among a production center A, a production center B and 1 same city backup center on the network level, and wavelength division equipment is used for connecting two layers of 3 central storage X86 servers.
Preferably, the storage implementation method includes configuring a Ceph cluster in 3 centers after a network is opened, configuring a production center 2 copy, a production center 2 copy and a city-shared backup center 1 copy.
Preferably, the disaster recovery switching is divided into 3 disaster switching situations, and the specific situations are related to the environment.
Compared with the prior art, the invention has the beneficial effects that:
1. the technology of Ceph extension cluster and multiple copies replaces EMC VEPLX double-activity technology, high availability of the applied cross double-activity data center can be realized, and data can be stored in multiple copies in different data centers;
2. the Ceph uses the X86 server to form storage hardware, professional storage equipment does not need to be purchased, the price is low, the hardware does not need to be locked, and only the X86 server needs to be configured with the SSD and the HDD hard disk;
3. the method has the advantages that the performance bottleneck is not needed to be worried about by horizontal expansion, and only the number of servers needs to be expanded;
4. the technology is advanced, the functions of simplified configuration, cloning, snapshot and the like are supported, the interfaces are rich, and FC, NAS and iscsi can be provided.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
FIG. 1 is an architectural diagram of the present invention;
fig. 2 is a diagram showing a network structure in the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In this embodiment: a Ceph-based cross-data center Oracle high-availability implementation method is based on an open source community edition Ceph, wherein the Ceph uses an extension cluster technology in A, B production centers and a C city-sharing backup center, an EMC VEPLX double-activity technology is replaced by a Ceph extension cluster and a multi-copy technology, high availability of the cross double-activity data center of application can be achieved, data are stored in multiple copies in different data centers, the Ceph provides block storage for an Oracle Rac cluster, the Ceph is divided into three blocks according to scenes, namely object storage, block equipment storage and file system service, the Ceph is a reliable, automatic rebalancing and automatic recovery distributed storage system, and the Ceph can be divided into three blocks according to scene division, namely object storage, block equipment storage and file system service. In the field of virtualization, block device storage of Ceph is commonly used, for example, in an OpenStack project, block device storage of Ceph can interface with shader backend storage of OpenStack, mirror storage of Glance, and data storage of a virtual machine, and it is more intuitive that a cluster of Ceph can provide block storage in raw format as a hard disk of a virtual machine instance.
Compared with other storages, the Ceph has the advantages that the Ceph not only stores data, but also fully utilizes the computing capacity on storage nodes, the data storage position can be obtained through calculation when each data is stored, the data distribution is balanced as much as possible, and due to the good design of the Ceph, the method of a CRUSH algorithm, a HASH ring and the like is adopted, so that the problem of traditional single-point failure does not exist, the performance cannot be influenced along with the expansion of the scale, the interfaces are rich, and the FC, the NAS and the iscsi can be provided.
And (4) storing a Ceph block:
the Block storage, abbreviated as rbd (RADOS Block device), is an ordered endian Block, and is also the most commonly used storage method in the three storage types of Ceph, and the Block storage of Ceph is based on RADOS, so that it also provides operations such as snapshot, clone, and backup by virtue of the characteristics such as snapshot, copy, and consistency of RADOS. The block device of the Ceph is a thin provisioning mode, the size of the block storage can be expanded, and the stored data is stored in a striped manner in a plurality of OSDs in the Ceph cluster.
In the double-activity A, B production center and the C same city backup center, a plurality of X86 servers are respectively configured to form a ceph extension cluster. And the center A is provided with a copy 2, the center B is provided with a copy 2, the center C is provided with a copy 1, and 5 copies are used as the multi-copy redundancy of the data of the storage layer.
The network implementation method comprises the following steps: on the network level, a bare fiber is built among a production center A, a production center B and 1 same city backup center, and wavelength division equipment is used for connecting two layers of 3 central storage X86 servers.
The storage implementation method comprises the following steps: after the network is opened, a Ceph cluster is configured in 3 centers, a production center 2 copy is configured, and a C same city backup center 1 copy is configured. The Ceph cluster provides block storage externally. The upper level virtualization cluster, the X86 server or the mini-machine, is served by the oracle rac cluster through mount block storage. A. And B, respectively configuring one rac node by the production center and providing services to the outside. And C, the copy of the city backup center 1 is only used for backup, and no external service is provided.
Disaster recovery handover
In this environment, there are 3 disaster handover cases:
4.4.1: when the A production center fails to store the 1 server node, the A production center 1 copy is disconnected, the other 1 copy is in a normal state, the Oracle Rac state is in a normal state, and the external service is normally accessed. And after the storage server is recovered, the off-line node is connected, normal synchronous data is stored, data synchronization is completed, the node is connected, and the copy 5 is recovered. RTO =0 and RPO = 0.
4.4.2: when the A production center has a catastrophic failure, the copy of the A production center 2 is disconnected, the copy of the B production center 2 is online, and the copy of the C city backup center 1 is also online, under the condition, the Oracle Rac cluster is in a normal state at the node of the B production center and provides normal access to the outside service. And after the production center A recovers to be normal, the copy of the production center A2 is online, normal synchronous data is stored, data synchronization is completed, the node is online, and the copy 5 is recovered. RTO =0 and RPO = 0.
4.4.3: when the A and B production centers have catastrophic failures, the copies of the A and B production centers 4 are disconnected, and only the remaining copies of the C same city backup center 1 are online. In this case, when the Oracle Rac cluster is down, a database standby machine needs to be started in the C production center, and a copy of the C data center 1 provides data support and service recovery. And after the production centers A and B are recovered to be normal, 4 copies are online, normal synchronous data are stored, data synchronization is completed, nodes are online, and 5 copies are recovered. RTO <30 (min), RPO = 0.
Finally, it should be noted that: although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art will understand that various changes, modifications and substitutions can be made without departing from the spirit and scope of the invention as defined by the appended claims. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (6)
1. A cross-data center Oracle high-availability implementation method based on Ceph is characterized in that: based on the open source community edition Ceph, the open source community edition Ceph uses an extension cluster technology in an A production center, a B production center and a C same city backup center, high availability of the applied cross double-living data center can be achieved, the Ceph provides block storage for an Oracle Rac cluster to use, data are stored in multiple copies in different data centers, the Ceph is divided into three large blocks according to scenes, and the three large blocks are respectively used for object storage, block device storage and file system service.
2. The method for realizing cross-data center Oracle high availability based on Ceph as claimed in claim 1, wherein: in the double-activity A, B production center and the C same city backup center, a plurality of X86 servers are respectively configured to form a ceph extension cluster.
3. The method for realizing cross-data center Oracle high availability based on Ceph as claimed in claim 1, wherein: and the production center A is configured with 2 copies, the production center B is configured with 2 copies, and the C is configured with 1 copy in the same city backup center, and 5 copies are totally used for the redundancy of the multiple copies of the storage layer data.
4. The method for realizing cross-data center Oracle high availability based on Ceph as claimed in claim 1, wherein: the network implementation method is characterized in that bare fibers are built among a production center A, a production center B and 1 same-city backup center on the network level, and wavelength division equipment is used for connecting two layers of 3 central storage X86 servers.
5. The method for realizing cross-data center Oracle high availability based on Ceph as claimed in claim 1, wherein: the storage implementation method comprises the steps that after a network is opened, Ceph clusters are configured in 3 centers, a production center 2 copy is configured, and a city-shared backup center 1 copy is configured.
6. The method for realizing cross-data center Oracle high availability based on Ceph as claimed in claim 1, wherein: disaster recovery switching is divided into 3 disaster switching situations, and the specific situation is related to the environment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911328587.8A CN111046108A (en) | 2019-12-20 | 2019-12-20 | Ceph-based cross-data center Oracle high-availability implementation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911328587.8A CN111046108A (en) | 2019-12-20 | 2019-12-20 | Ceph-based cross-data center Oracle high-availability implementation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111046108A true CN111046108A (en) | 2020-04-21 |
Family
ID=70237289
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911328587.8A Pending CN111046108A (en) | 2019-12-20 | 2019-12-20 | Ceph-based cross-data center Oracle high-availability implementation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111046108A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110309128A (en) * | 2019-07-05 | 2019-10-08 | 广东铭太信息科技有限公司 | Oracle backup file automatic leading-in device and its implementation, the method that the importing of backup file is carried out using the device |
| CN113630317A (en) * | 2021-07-28 | 2021-11-09 | 星辰天合（北京）数据科技有限公司 | Data transmission method and device, nonvolatile storage medium and electronic device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150160872A1 (en) * | 2013-12-09 | 2015-06-11 | Hsun-Yuan Chen | Operation method of distributed memory disk cluster storage system |
| CN106445741A (en) * | 2016-09-28 | 2017-02-22 | 郑州云海信息技术有限公司 | Method for achieving oracle database disaster tolerance backup on basis of ceph |
| CN109471755A (en) * | 2018-11-14 | 2019-03-15 | 江苏鸿信系统集成有限公司 | A kind of method and its system that the same city strange land calamity based on cloud computing is standby |
| CN110198329A (en) * | 2018-03-26 | 2019-09-03 | 腾讯科技（深圳）有限公司 | Database deployment method, device and system, electronic equipment and readable medium |
-
2019
- 2019-12-20 CN CN201911328587.8A patent/CN111046108A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150160872A1 (en) * | 2013-12-09 | 2015-06-11 | Hsun-Yuan Chen | Operation method of distributed memory disk cluster storage system |
| CN106445741A (en) * | 2016-09-28 | 2017-02-22 | 郑州云海信息技术有限公司 | Method for achieving oracle database disaster tolerance backup on basis of ceph |
| CN110198329A (en) * | 2018-03-26 | 2019-09-03 | 腾讯科技（深圳）有限公司 | Database deployment method, device and system, electronic equipment and readable medium |
| CN109471755A (en) * | 2018-11-14 | 2019-03-15 | 江苏鸿信系统集成有限公司 | A kind of method and its system that the same city strange land calamity based on cloud computing is standby |
Non-Patent Citations (2)
| Title |
|---|
| 段俊;汤澜;: "跨数据中心双活云资源池研究" * |
| 陈庆东;: "双活数据中心解决方案" * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110309128A (en) * | 2019-07-05 | 2019-10-08 | 广东铭太信息科技有限公司 | Oracle backup file automatic leading-in device and its implementation, the method that the importing of backup file is carried out using the device |
| CN110309128B (en) * | 2019-07-05 | 2020-07-17 | 广东铭太信息科技有限公司 | Oracle backup file automatic importing device, implementation method thereof and method for importing backup file by using device |
| CN113630317A (en) * | 2021-07-28 | 2021-11-09 | 星辰天合（北京）数据科技有限公司 | Data transmission method and device, nonvolatile storage medium and electronic device |
| CN113630317B (en) * | 2021-07-28 | 2022-10-11 | 北京星辰天合科技股份有限公司 | Data transmission method and device, nonvolatile storage medium and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11422908B2 (en) | Non-disruptive controller replacement in a cross-cluster redundancy configuration | |
| US10963289B2 (en) | Storage virtual machine relocation | |
| US11681663B2 (en) | Cloned virtual machine disk replication | |
| US11522808B2 (en) | Shared storage model for high availability within cloud environments | |
| US11567674B2 (en) | Low overhead resynchronization snapshot creation and utilization | |
| US9747179B2 (en) | Data management agent for selective storage re-caching | |
| WO2018153218A1 (en) | Resource processing method, related apparatus and communication system | |
| JP5996787B2 (en) | System management method and computer system | |
| US10852984B2 (en) | Mirror vote synchronization | |
| US11341101B2 (en) | Data synchronization | |
| CN110912991A (en) | Super-fusion-based high-availability implementation method for double nodes | |
| JP2023548373A (en) | Asynchronous region-to-region block volume replication | |
| US9058127B2 (en) | Data transfer in cluster storage systems | |
| CN109690494B (en) | Hierarchical fault tolerance in system storage | |
| US7702757B2 (en) | Method, apparatus and program storage device for providing control to a networked storage architecture | |
| CN111046108A (en) | Ceph-based cross-data center Oracle high-availability implementation method | |
| CN110175089A (en) | A kind of dual-active disaster recovery and backup systems with read and write abruption function | |
| CN107193489A (en) | A kind of storage level data migration method and device based on storage virtual gateway | |
| JP2023547895A (en) | Techniques for generating configurations for electrically isolating fault domains within data centers | |
| CN109218386B (en) | High-availability method for managing Hadoop namespace | |
| US9612769B1 (en) | Method and apparatus for automated multi site protection and recovery for cloud storage | |
| US11977510B2 (en) | Configuring a file server | |
| Gong et al. | Research and application of distributed storage technology in power grid enterprise database | |
| Wen et al. | Research on key technologies for database containerized deployment | |
| CN104852969A (en) | Highly reliable RAC and HANS system fusion |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200421 |
|
| RJ01 | Rejection of invention patent application after publication |