CN108595116A - Based on Oracle RAC company-data readwrite performance optimization methods - Google Patents

Based on Oracle RAC company-data readwrite performance optimization methods Download PDF

Info

Publication number
CN108595116A
CN108595116A CN201810271075.1A CN201810271075A CN108595116A CN 108595116 A CN108595116 A CN 108595116A CN 201810271075 A CN201810271075 A CN 201810271075A CN 108595116 A CN108595116 A CN 108595116A
Authority
CN
China
Prior art keywords
oracle rac
server
company
memory space
oracle
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.)
Granted
Application number
CN201810271075.1A
Other languages
Chinese (zh)
Other versions
CN108595116B (en
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.)
Zhejiang Wisu Technology Co Ltd
Original Assignee
Zhejiang Wisu Technology 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 Zhejiang Wisu Technology Co Ltd filed Critical Zhejiang Wisu Technology Co Ltd
Priority to CN201810271075.1A priority Critical patent/CN108595116B/en
Publication of CN108595116A publication Critical patent/CN108595116A/en
Application granted granted Critical
Publication of CN108595116B publication Critical patent/CN108595116B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
    • G06F3/0601—Interfaces specially adapted for storage systems
    • G06F3/0602—Interfaces specially adapted for storage systems specifically adapted to achieve a particular effect
    • G06F3/061—Improving I/O performance
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
    • G06F3/0601—Interfaces specially adapted for storage systems
    • G06F3/0628—Interfaces specially adapted for storage systems making use of a particular technique
    • G06F3/0629—Configuration or reconfiguration of storage systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
    • G06F3/0601—Interfaces specially adapted for storage systems
    • G06F3/0668—Interfaces specially adapted for storage systems adopting a particular infrastructure
    • G06F3/067—Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]

Abstract

The invention discloses one kind being based on distributed storage Oracle RAC company-data readwrite performance optimization methods, includes the following steps：One, a part of memory space is divided in the server node of 2 or 2 or more Oracle Rac clusters；Two, drawn memory space is passed through into common Ethernet or infinite bandwidth（infiniband）High bandwidth low latency network operation iSCSI protocol carry has the server of database instance to other in Oracle Rac clusters；Three, the server in Oracle RAC is created by DM and polymerize identified iscsi disk, and realizes multi-route management.The present invention provides getting around network to the drawn space of the machine to carry out the ability that local direct read/write accesses, the influence of network bottleneck is reduced to greatest extent.

Description

Based on Oracle RAC company-data readwrite performance optimization methods
Technical field
It is specifically a kind of based on distributed storage Oracle RAC company-datas read-write property the present invention relates to database field It can optimization method.
Background technology
Current storage media（Such as：NVMe flash memory disks, PCI-E flash cards, polylith SSD disks etc.）Local IP access bandwidth, IOPS Surmount common Ethernet, even higher than infinite bandwidth significantly（Infiniband）The transmission bandwidth and IOPS of network, especially exist In the case of polylith storage medium, network bottleneck becomes apparent.
Invention content
In order to solve the above technical problems existing in the prior art, the present invention provides one kind being based on distributed storage Oracle RAC company-data readwrite performance optimization methods, include the following steps：
One, a part of memory space is divided in the server node of 2 or 2 or more Oracle Rac clusters；
Two, drawn memory space is passed through into common Ethernet or infinite bandwidth（infiniband）High bandwidth low latency network is transported Row iSCSI protocol carry has the server of database instance to other in Oracle Rac clusters；
Three, the server in Oracle RAC is created by DM and polymerize identified iscsi disk, and realizes multipath pipe Reason.
Further, server where the memory space drawn does not have to directly access the memory space by any network.
Further, Oracle Rac clusters Servers-all node manages all memory spaces of institute's carry by ASM, And configure the data redundancy of 2 or 3 copies.
Further, algorithm is read by local first and makes the identification of Oracle RAC servers, mark local medium, and examined Survey data to be accessed whether there is in local medium, if any then preferentially being read from local medium.
The present invention provides getting around network to the drawn space of the machine to carry out the ability that local direct read/write accesses, to greatest extent The influence for reducing network bottleneck.In Automatic Storage Management device（ASM）It is configured with 2 node R AC clusters of 2 copies and deposits automatically Store up manager（ASM）It is configured in 3 node R AC clusters of 3 copies, can reach 100% effect locally read, because of each node There is a complete data copy.In 3 node R AC clusters, under 10Gb/s Ethernet environment, enables local first and read work( Can Oracle IOPS performances compared with have before not enabled 100% or more performance growth（Storage medium is NVMe disks）, IO performances and Conventional Oracle RAC clusters using the Infiniband exchange networks of 56Gb/s are substantially suitable.And as the NVMe per node When number of disks increases, enabling the IO performances of the Oracle RAC clusters of this method can further increase, and surmount current use The conventional Oracle RAC clustering performances of the Infiniband exchange networks of 56Gb/s.
Description of the drawings
Fig. 1 is the method topology schematic diagram of the present invention.
Specific implementation mode
The invention will be further described below in conjunction with the accompanying drawings.
As shown in Figure 1, the present invention based on distributed storage Oracle RAC company-data readwrite performance optimization method packets Include following steps：
One, a part of memory space is divided in the server node of 2 or 2 or more Oracle Rac clusters；
Two, drawn memory space is passed through into common Ethernet or infinite bandwidth（infiniband）High bandwidth low latency network is transported Row iSCSI protocol carry has the server of database instance to other in Oracle Rac clusters；
Three, the server in Oracle RAC is created by DM and polymerize identified iscsi disk, and realizes multipath pipe Reason.
Server where the memory space drawn does not have to directly access the memory space by any network；Oracle Rac Cluster Servers-all node manages all memory spaces of institute's carry by ASM, and configures the data redundancy of 2 or 3 copies.
Algorithm is read by local first and makes the identification of Oracle RAC servers, mark local medium, and is detected and be intended to access Data whether there is in local medium, if any then preferentially being read from local medium.

Claims (4)

1. one kind being based on distributed storage Oracle RAC company-data readwrite performance optimization methods, include the following steps：
One, a part of memory space is divided in the server node of 2 or 2 or more Oracle Rac clusters；
Two, drawn memory space is passed through into common Ethernet or infinite bandwidth（infiniband）High bandwidth low latency network is transported Row iSCSI protocol carry has the server of database instance to other in Oracle Rac clusters；
Three, the server in Oracle RAC is created by DM and polymerize identified iscsi disk, and realizes multipath pipe Reason.
2. it is based on distributed storage Oracle RAC company-data readwrite performance optimization methods as described in claim 1, it is special Sign is：Server where the memory space drawn does not have to directly access the memory space by any network.
3. it is based on distributed storage Oracle RAC company-data readwrite performance optimization methods as described in claim 1, it is special Sign is：Oracle Rac cluster Servers-all nodes manage all memory spaces of institute's carry by ASM, and configure 2 or 3 The data redundancy of copy.
4. it is based on distributed storage Oracle RAC company-data readwrite performance optimization methods as described in claim 1, it is special Sign is：Algorithm is read by local first and makes the identification of Oracle RAC servers, mark local medium, and detects number to be accessed It whether there is according in local medium, if any then preferentially being read from local medium.
CN201810271075.1A 2018-03-29 2018-03-29 Cluster data read-write performance optimization method based on Oracle RAC Expired - Fee Related CN108595116B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810271075.1A CN108595116B (en) 2018-03-29 2018-03-29 Cluster data read-write performance optimization method based on Oracle RAC

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810271075.1A CN108595116B (en) 2018-03-29 2018-03-29 Cluster data read-write performance optimization method based on Oracle RAC

Publications (2)

Publication Number Publication Date
CN108595116A true CN108595116A (en) 2018-09-28
CN108595116B CN108595116B (en) 2021-04-20

Family

ID=63624884

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810271075.1A Expired - Fee Related CN108595116B (en) 2018-03-29 2018-03-29 Cluster data read-write performance optimization method based on Oracle RAC

Country Status (1)

Country Link
CN (1) CN108595116B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113111122A (en) * 2021-03-08 2021-07-13 北京世纪安图数码科技发展有限责任公司 Real estate registration data read-write separation method facing RAC cluster
CN114356239A (en) * 2021-12-30 2022-04-15 苏州浪潮智能科技有限公司 Distributed storage IO unloading method, system, device and storage medium

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7512707B1 (en) * 2005-11-03 2009-03-31 Adobe Systems Incorporated Load balancing of server clusters
CN102164177A (en) * 2011-03-11 2011-08-24 浪潮(北京)电子信息产业有限公司 Method, device and system for sharing storage pool by cluster
CN102164161A (en) * 2011-01-10 2011-08-24 清华大学 Method and device for performing file layout extraction on parallel file system
CN103595799A (en) * 2013-11-18 2014-02-19 北京中创信测科技股份有限公司 Method for achieving distributed shared data bank
CN103873559A (en) * 2014-02-13 2014-06-18 南京斯坦德通信股份有限公司 Database all-in-one machine capable of realizing high-speed storage
CN106686099A (en) * 2017-01-03 2017-05-17 杭州沃趣科技股份有限公司 Method of realizing active-active mode across machine rooms of OracleRAC database based on infiniband network

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7512707B1 (en) * 2005-11-03 2009-03-31 Adobe Systems Incorporated Load balancing of server clusters
CN102164161A (en) * 2011-01-10 2011-08-24 清华大学 Method and device for performing file layout extraction on parallel file system
CN102164177A (en) * 2011-03-11 2011-08-24 浪潮(北京)电子信息产业有限公司 Method, device and system for sharing storage pool by cluster
CN103595799A (en) * 2013-11-18 2014-02-19 北京中创信测科技股份有限公司 Method for achieving distributed shared data bank
CN103873559A (en) * 2014-02-13 2014-06-18 南京斯坦德通信股份有限公司 Database all-in-one machine capable of realizing high-speed storage
CN106686099A (en) * 2017-01-03 2017-05-17 杭州沃趣科技股份有限公司 Method of realizing active-active mode across machine rooms of OracleRAC database based on infiniband network

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113111122A (en) * 2021-03-08 2021-07-13 北京世纪安图数码科技发展有限责任公司 Real estate registration data read-write separation method facing RAC cluster
CN114356239A (en) * 2021-12-30 2022-04-15 苏州浪潮智能科技有限公司 Distributed storage IO unloading method, system, device and storage medium
CN114356239B (en) * 2021-12-30 2023-08-29 苏州浪潮智能科技有限公司 Distributed storage IO unloading method, system, equipment and storage medium

Also Published As

Publication number Publication date
CN108595116B (en) 2021-04-20

Similar Documents

Publication Publication Date Title
US11620064B2 (en) Asynchronous semi-inline deduplication
CN103268318B (en) A kind of distributed key value database system of strong consistency and reading/writing method thereof
US7529830B2 (en) Storage system and communication control method
US9628299B2 (en) Method and system for data transfer between compute clusters and file system
US10769024B2 (en) Incremental transfer with unused data block reclamation
US10353870B2 (en) Tracking structure for data replication synchronization
CN100561447C (en) Storage volume is rendered as device, the system and method for virtual volume
US11169927B2 (en) Efficient cache management
JP6288596B2 (en) Data processing method and apparatus
US10031682B1 (en) Methods for improved data store migrations and devices thereof
WO2019028799A1 (en) Data access method, device and system
CN106066890A (en) A kind of distributed high-performance data storehouse integrated machine system
WO2023207492A1 (en) Data processing method and apparatus, device, and readable storage medium
CN106375425A (en) Processing method and device for distributed caching
CN108595116A (en) Based on Oracle RAC company-data readwrite performance optimization methods
CN105187502A (en) Method and system based on distributed elastic block storage
US20080028147A1 (en) Affecting a caching algorithm used by a cache of a storage system
US20150331894A1 (en) System and Method for Location-Based Device Naming
CN110663034B (en) Method for improved data replication in cloud environment and apparatus therefor
CN108282516B (en) Distributed storage cluster load balancing method and device based on iSCSI
US20170220258A1 (en) Resilient implementation of client file operations and replication
US8171178B2 (en) Scaling of small computer system interface input output (SCSI I/O) referrals
WO2024021470A1 (en) Cross-region data scheduling method and apparatus, device, and storage medium
US11297010B2 (en) In-line data operations for storage systems
CN104811647B (en) The double subregion wiring methods of distributed memory system disk towards video stream data

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
GR01 Patent grant
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20210420