CN104038556B - Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster - Google Patents

Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster Download PDF

Info

Publication number
CN104038556B
CN104038556B CN201410295537.5A CN201410295537A CN104038556B CN 104038556 B CN104038556 B CN 104038556B CN 201410295537 A CN201410295537 A CN 201410295537A CN 104038556 B CN104038556 B CN 104038556B
Authority
CN
China
Prior art keywords
sybase
optical fiber
storage
datas storehouse
cluster
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
Application number
CN201410295537.5A
Other languages
Chinese (zh)
Other versions
CN104038556A (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.)
Inspur Beijing Electronic Information Industry Co Ltd
Original Assignee
Inspur Beijing Electronic Information Industry 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 Inspur Beijing Electronic Information Industry Co Ltd filed Critical Inspur Beijing Electronic Information Industry Co Ltd
Priority to CN201410295537.5A priority Critical patent/CN104038556B/en
Publication of CN104038556A publication Critical patent/CN104038556A/en
Application granted granted Critical
Publication of CN104038556B publication Critical patent/CN104038556B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Abstract

Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster;Methods described includes:Sybase I/Q datas storehouse cluster is installed on the server;Server, optical fiber storage card, optical fiber switch, storage device are connected by fiber link;Optical fiber switch is arranged to the load balancing for meeting Sybase I/Q datas storehouse cluster;For each storage device of polylith optical fiber storage card connection, port trunking is carried out to port, and carries out the sensing in path to different optical fiber storage cards respectively;The unified order by correlation of polylith optical fiber storage card is added in the Sybase I/Q datas storehouse cluster;Polylith optical fiber storage card is arranged to load-sharing mode, different load balancings is set respectively according to storage demand.The present invention rationally can utilize memory bandwidth resource in Sybase I/Q datas storehouse, to memory bandwidth resource unified management.

Description

Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster
Technical field
The present invention relates to computer realm, and in particular to a kind of storage method in Sybase I/Q datas storehouse cluster and is System.
Background technology
In recent years, rapid development of information technology, the arrival in big data epoch, promotes large-scale application to swash Database Requirements Increase, storage demand explosive growth.Sybase IQ, in application deployment environment, occur following often as database platform Problem:
Substantial amounts of application system, substantial amounts of customer group, using substantial amounts of memory bandwidth resource, so causing memory bandwidth to provide Source deficiency.Traditional deployment scheme can not be managed collectively, and resource can not be utilized rationally.
The content of the invention
The technical problem to be solved in the present invention is how in Sybase I/Q datas storehouse rationally to utilize memory bandwidth resource, To memory bandwidth resource unified management.
In order to solve the above problems, the invention provides a kind of configuration of the storage resource in Sybase I/Q datas storehouse cluster Method, including:
Sybase I/Q datas storehouse cluster is installed on the server;By the server, optical fiber storage card, optical fiber switch, Storage device is connected by fiber link;
Sybase I/Q datas storehouse cluster is configured on the optical fiber switch;The optical fiber switch is arranged to full The load balancing of the foot Sybase I/Q datas storehouse cluster;
For each storage device of polylith optical fiber storage card connection, port trunking is carried out to port, and respectively to difference Optical fiber storage card carry out path sensing;
The unified order by correlation of optical fiber storage card described in polylith is added to the Sybase I/Q datas storehouse cluster In;
The setting of load balancing is carried out to each optical fiber storage card, it is equal that the polylith optical fiber storage card is arranged into load Weighing apparatus pattern, different load balancings is set respectively according to storage demand.
Alternatively, described method also includes:
The unstructured data of Sybase I/Q datas storehouse cluster-based storage is distinguished to different optical fiber from structural data and handed over Change planes division Zone inside;
When high-volume data access be present, Sybase I/Q datas storehouse cluster according to the tactful partition database set, The high-volume data are accessed by different fiber links.
Alternatively, described method also includes:
Interacted by the optical fiber storage card that load balancing is set and data in Sybase I/Q datas storehouse, number According on amount load sharing to different fiber links.
Alternatively, described method also includes:
The Sybase I/Q datas storehouse cluster is managed collectively to polylith optical fiber storage card.
Alternatively, described method also includes:
When storage demand is submitted, the storage load-sharing mode corresponding to the distribution of Sybase I/Q datas storehouse cluster, and to Each server distribution;
When storage load change, it is monitored by Sybase I/Q datas storehouse cluster and changes its mode of loading, reached and deposit Store up optimal selection.
Present invention also offers the storage resource in a kind of Sybase I/Q datas storehouse cluster to configure system, for Sybase In the group system of I/Q data storehouse;The Sybase I/Q datas storehouse group system includes:By fiber link be connected server, Optical fiber storage card, optical fiber switch, storage device;Sybase I/Q datas storehouse cluster is installed on the server;The storage Resource configuration system includes:
First configuration module, for configuring Sybase I/Q datas storehouse cluster on the optical fiber switch;By the optical fiber Switch configuration is into the load balancing that can meet the Sybase I/Q datas storehouse cluster;
Second configuration module, for each storage device connected for polylith optical fiber storage card, port is carried out to port and gathered Close, and carry out the sensing in path to different optical fiber storage cards respectively;
Load-on module, for the unified order by correlation of optical fiber storage card described in polylith to be added into the Sybase In the cluster of I/Q data storehouse;
3rd configuration module, for carrying out the setting of load balancing to each optical fiber storage card, by the polylith optical fiber Storage card is arranged to load-sharing mode, sets different load balancings respectively according to storage demand.
Alternatively, described system also includes:
First division module, for by the unstructured data and structural data of Sybase I/Q datas storehouse cluster-based storage Inside the Zone for distinguishing different optical fiber switch divisions;
Second division module, for when high-volume data access be present, according to the tactful partition database set, inciting somebody to action The high-volume data are accessed by different fiber links.
Alternatively, the optical fiber storage card set by load balancing and data phase interaction in Sybase I/Q datas storehouse With on data volume load sharing to different fiber links.
Alternatively, the Sybase I/Q datas storehouse cluster on the server is used to carry out polylith optical fiber storage card unification Management.
Alternatively, the Sybase I/Q datas storehouse cluster on the server is additionally operable to submit time-division pairing in storage demand The storage load-sharing mode answered, and distribute to each server;It is monitored when storage load change and changes its load Mode.
In the present invention, Sybase IQ cluster supports a variety of storage load-sharing modes, is loaded using network concurrent is stored Characteristic can simultaneously use polylith optical fiber storage card bandwidth, add overall storage performance, simplify action;Adopt Worked simultaneously with a variety of storage load-sharing modes in Sybase IQ, substantially increase the efficiency that storage receives and sends data, Also the problem of storage resource wastes has been evaded, therefore in high memory bandwidth Transmission system, or have in big data processing system Vast potential for future development, there is very high technological value., can be according to its performance characteristics in addition for different optical fiber storage cards Use, more personalized storage environment support can be provided for Sybase I/Q datas storehouse cluster, so as to reach ease for use more preferably, Cost-effective purpose, improves the utilization rate of storage, and reduces the problem of artificial switching is present, and has evaded risk;Again Person, pass through unified managements of the Sybase IQ to a variety of optical fiber storage cards, unified plan, United Dispatching, when both having saved management Between, reduce management cost again.
Brief description of the drawings
Fig. 1 is the schematic diagram that designs a model of embodiment one;
Fig. 2 is the schematic flow sheet of the example of embodiment one
Embodiment
Technical scheme is described in detail below in conjunction with drawings and Examples.
If it should be noted that not conflicting, each feature in the embodiment of the present invention and embodiment can be tied mutually Close, within protection scope of the present invention.In addition, though logical order is shown in flow charts, but in some situations Under, can be with the step shown or described by being performed different from order herein.
A kind of storage resource collocation method in embodiment one, Sybase I/Q datas storehouse cluster, including:
Sybase I/Q datas storehouse cluster is installed on the server;By the server, optical fiber storage card, optical fiber switch, Storage device is connected by fiber link.
Sybase I/Q datas storehouse cluster is configured on optical fiber switch;The optical fiber switch is arranged to meet institute State the load balancing of Sybase I/Q datas storehouse cluster;
For each storage device of polylith optical fiber storage card connection, port trunking is carried out to port, and respectively to difference Optical fiber storage card carry out path sensing;
The unified order by correlation of polylith optical fiber storage card is added in the Sybase I/Q datas storehouse cluster;
The setting of load balancing is carried out to each optical fiber storage card, it is equal that the polylith optical fiber storage card is arranged into load Weighing apparatus pattern, different load balancings is set respectively according to storage demand.
In the present embodiment, it can be, but not limited to by the associated storage load balancing software such as multipath, rdac to each light Fine storage card carries out the setting of load balancing.
In the present embodiment, active-active patterns are set on a storage device, optical fiber storage card is may be used on this In example.
In an embodiment of the present embodiment, methods described can also include:
The unstructured data of Sybase I/Q datas storehouse cluster-based storage is distinguished to different optical fiber from structural data and handed over Change planes division Zone inside;
When high-volume data access be present, Sybase I/Q datas storehouse cluster according to the tactful partition database set, The high-volume data are accessed by different fiber links.
In present embodiment, the Zone divided for different optical fiber switch can be according to Sybase I/Q datas storehouse cluster Data characteristicses divided;And by different links access data can then mitigate mix storage tape come efficiency lowly ask Topic.
In an embodiment of the present embodiment, methods described can also include:
Interacted by the optical fiber storage card that load balancing is set and data in Sybase I/Q datas storehouse, number According on amount load sharing to different fiber links.
Present embodiment can reach the purpose of streamed data amount.
The present embodiment designs a model as shown in figure 1, wherein storage device → Sybase I/Q datas storehouse cluster Linking (link) is the first step, storage device is connected into Sybase I/Q datas storehouse cluster, there is provided give Sybase I/Q datas Storehouse cluster uses;Server (server) → server share (shared) shows second step, and storage is carried out into load balancing gives All hosts;Finally it is supplied to required APP (application) to use storage device.Whole process only needs simply Operation can be completed.
Big data is applied as currently advanced technological means, data center can be managed collectively, unified plan;Deposit The performance and stably of resource is stored up, also necessarily turns into the foundation of big data application.Based on such a thought, more storage moneys are carried Source, it is the perfect certainty of Sybase IQ clustering functionalitys.The present embodiment takes into full account that the storage demand of big data epoch is huge, A variety of load-sharing modes are used in Sybase IQ, make its concurrent working;Coordinate corresponding memory technology feature, system is arrived The storage of equipment and equipment to system both direction carries out load balancing work, and the transmission bandwidth of storage processing system is improved with this Utilization rate, so as to reach the purpose of lifting system performance.
The present embodiment uses polylith optical fiber storage card load balancing, since the performance of its storage can be played, and can improves it Compatibility.Sybase IQ memory bandwidth is added, substantially increases its combination property.
In Sybase IQ test and implementation process, the situation of storage performance deficiency can be usually run into, is not only set multiple It is miscellaneous, also to improve the utilization rate of storage resource;Sybase IQ and storage technology are successfully incorporated into using deployment by the present embodiment Among work, the pattern of a variety of storage load balancing is focused under unified systems organization, action is simplified, evades Work risk, simultaneously as be managed collectively using SybaseIQ, the step of simplifying management and time.
In an embodiment of the present embodiment, methods described can also include:
The Sybase I/Q datas storehouse cluster is managed collectively to polylith optical fiber storage card.
The method of present embodiment also can provide facility with flexible Application for other work.
In an embodiment of the present embodiment, methods described can also include:
When storage demand is submitted, the storage load-sharing mode corresponding to the distribution of Sybase I/Q datas storehouse cluster, and to Each database server distribution;
When storage load change, it is monitored by Sybase I/Q datas storehouse cluster and changes its mode of loading, reached and deposit Store up optimal selection.
Likewise, for External memory equipment, it is also desirable to by changing corresponding strategy, to complete the load of storage.
Present embodiment carries out the setting of load balancing, SybaseIQ databases for the storage demand newly added Cluster carries out unified management.When storage resource is needed, primary screening is carried out, the storage for different performance demand point Do not load on different optical fiber storage cards, can rationally utilize resource, improve overall performance, also save cost.
A kind of example of the present embodiment as shown in Fig. 2 including step 201~207:
The 201st, Sybase I/Q datas storehouse cluster is installed.
202nd, optical fiber switch load balancing is configured.
203rd, Zone, partition database are divided according to data characteristicses.
204th, the port of storage device is configured.
205th, load balancing setting is carried out to each optical fiber storage card.
206th, judge whether data do not change, if it is, carrying out step 207, otherwise return to step 203.
207th, data are accessed.
Storage resource configuration system in embodiment two, a kind of Sybase I/Q datas storehouse cluster, for Sybase IQ numbers According in the group system of storehouse;The Sybase I/Q datas storehouse group system includes:Server, the optical fiber being connected by fiber link Storage card, optical fiber switch, storage device;Sybase I/Q datas storehouse cluster is installed on the server;The storage money Source configuration system includes:
First configuration module, for configuring Sybase I/Q datas storehouse cluster on the optical fiber switch;By the optical fiber Switch configuration is into the load balancing that can meet the Sybase I/Q datas storehouse cluster;
Second configuration module, for each storage device connected for polylith optical fiber storage card, port is carried out to port and gathered Close, and carry out the sensing in path to different optical fiber storage cards respectively;
Load-on module, for the unified order by correlation of optical fiber storage card described in polylith to be added into the Sybase In the cluster of I/Q data storehouse;
3rd configuration module, for carrying out the setting of load balancing to each optical fiber storage card, by the polylith optical fiber Storage card is arranged to load-sharing mode, sets different load balancings respectively according to storage demand.
The configuration system of the present embodiment can be integrated in an independent equipment, can also be distributed in multiple equipment; Can be existing equipment or newly-increased equipment.
In an embodiment of the present embodiment, the system can also include:
First division module, for by the unstructured data and structural data of Sybase I/Q datas storehouse cluster-based storage Inside the Zone for distinguishing different optical fiber switch divisions;
Second division module, for when high-volume data access be present, according to the tactful partition database set, inciting somebody to action The high-volume data are accessed by different fiber links.
In an embodiment of the present embodiment, the optical fiber storage card set by load balancing can also be with Data interact in Sybase I/Q datas storehouse, on data volume load sharing to different fiber links.
In an embodiment of the present embodiment, the Sybase I/Q datas storehouse cluster on the server can be used for pair Polylith optical fiber storage card is managed collectively.
In an embodiment of the present embodiment, the Sybase I/Q datas storehouse cluster on the server can be also used for The time-division is submitted with corresponding storage load-sharing mode in storage demand, and is distributed to each server;When storage load change When be monitored and change its mode of loading.
Certainly, the present invention can also have other various embodiments, ripe in the case of without departing substantially from spirit of the invention and its essence Know those skilled in the art when can be made according to the present invention it is various it is corresponding change and deformation, but these it is corresponding change and Deformation should all belong to the scope of the claims of the present invention.

Claims (8)

1. the storage resource collocation method in a kind of Sybase I/Q datas storehouse cluster, including:
Sybase I/Q datas storehouse cluster is installed on the server;By the server, optical fiber storage card, optical fiber switch, storage Equipment is connected by fiber link;
Sybase I/Q datas storehouse cluster is configured on the optical fiber switch;The optical fiber switch is arranged to meet institute State the load balancing of Sybase I/Q datas storehouse cluster;
For each storage device of polylith optical fiber storage card connection, port trunking is carried out to port, and respectively to different light Fine storage card carries out the sensing in path;
The unified order by correlation of optical fiber storage card described in polylith is added in the Sybase I/Q datas storehouse cluster;
The setting of load balancing is carried out to each optical fiber storage card, the polylith optical fiber storage card is arranged to load balancing mould Formula, different load balancings is set respectively according to storage demand;
The unstructured data of Sybase I/Q datas storehouse cluster-based storage is distinguished from structural data and arrives different optical fiber switch Inside the Zone of division;
When high-volume data access be present, Sybase I/Q datas storehouse cluster is according to the tactful partition database set, by institute High-volume data are stated to access by different fiber links.
2. the method as described in claim 1, it is characterised in that also include:
Interacted by the optical fiber storage card that load balancing is set and data in Sybase I/Q datas storehouse, data volume Load sharing is in different fiber links.
3. the method as described in claim 1, it is characterised in that also include:
The Sybase I/Q datas storehouse cluster is managed collectively to polylith optical fiber storage card.
4. the method as described in claim 1, it is characterised in that also include:
When storage demand is submitted, by Sybase I/Q datas storehouse cluster distribute corresponding to storage load-sharing mode, and to each Server is distributed;
When storage load change, it is monitored by Sybase I/Q datas storehouse cluster and changes its mode of loading, reach storage most It is preferred that select.
5. the storage resource configuration system in a kind of Sybase I/Q datas storehouse cluster, it is characterised in that for Sybase IQ numbers According in the group system of storehouse;The Sybase I/Q datas storehouse group system includes:Server, the optical fiber being connected by fiber link Storage card, optical fiber switch, storage device;Sybase I/Q datas storehouse cluster is installed on the server;The storage resource Configuration system includes:
First configuration module, for configuring Sybase I/Q datas storehouse cluster on the optical fiber switch;The optical fiber is exchanged Machine is arranged to the load balancing for meeting the Sybase I/Q datas storehouse cluster;
Second configuration module, for each storage device connected for polylith optical fiber storage card, port trunking is carried out to port, and And the sensing in path is carried out to different optical fiber storage cards respectively;
Load-on module, for the unified order by correlation of optical fiber storage card described in polylith to be added into the Sybase IQ numbers According in the cluster of storehouse;
3rd configuration module, for carrying out the setting of load balancing to each optical fiber storage card, the polylith optical fiber is stored Card is arranged to load-sharing mode, sets different load balancings respectively according to storage demand;
First division module, for the unstructured data of Sybase I/Q datas storehouse cluster-based storage and structural data to be distinguished Inside the Zone divided to different optical fiber switch;
Second division module, for when high-volume data access be present, according to the tactful partition database set, will described in High-volume data are accessed by different fiber links.
6. system as claimed in claim 5, it is characterised in that:
Interacted by the optical fiber storage card that load balancing is set and data in Sybase I/Q datas storehouse, data volume Load sharing is in different fiber links.
7. system as claimed in claim 5, it is characterised in that:
Sybase I/Q datas storehouse cluster on the server is used to be managed collectively polylith optical fiber storage card.
8. system as claimed in claim 7, it is characterised in that:
Sybase I/Q datas storehouse cluster on the server is additionally operable to submit the time-division to load with corresponding storage in storage demand Balanced mode, and distribute to each server;It is monitored when storage load change and changes its mode of loading.
CN201410295537.5A 2014-06-26 2014-06-26 Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster Active CN104038556B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410295537.5A CN104038556B (en) 2014-06-26 2014-06-26 Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410295537.5A CN104038556B (en) 2014-06-26 2014-06-26 Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster

Publications (2)

Publication Number Publication Date
CN104038556A CN104038556A (en) 2014-09-10
CN104038556B true CN104038556B (en) 2017-11-17

Family

ID=51469144

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410295537.5A Active CN104038556B (en) 2014-06-26 2014-06-26 Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster

Country Status (1)

Country Link
CN (1) CN104038556B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104539671B (en) * 2014-12-16 2018-05-18 广东侍卫长卫星应用安全股份公司 A kind of distributed data collection method based on big-dipper satellite alignment system
CN108052393A (en) * 2017-12-27 2018-05-18 广州烽睿信息科技有限公司 A kind of IT resource pools intelligent optimization configuration device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1610238A2 (en) * 2004-06-21 2005-12-28 Microsoft Corporation API for programmatic retrieval and replay of database trace
CN101325603A (en) * 2008-07-24 2008-12-17 上海众恒信息产业有限公司 Network memory structure for special certificate management system
CN101616375A (en) * 2009-07-28 2009-12-30 中兴通讯股份有限公司 A kind of method and system of optimizing the multimedia message storage

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1610238A2 (en) * 2004-06-21 2005-12-28 Microsoft Corporation API for programmatic retrieval and replay of database trace
CN1722086A (en) * 2004-06-21 2006-01-18 微软公司 API for programmatic retrieval and replay of database trace
CN101325603A (en) * 2008-07-24 2008-12-17 上海众恒信息产业有限公司 Network memory structure for special certificate management system
CN101616375A (en) * 2009-07-28 2009-12-30 中兴通讯股份有限公司 A kind of method and system of optimizing the multimedia message storage

Also Published As

Publication number Publication date
CN104038556A (en) 2014-09-10

Similar Documents

Publication Publication Date Title
CN108921551B (en) Alliance block chain system based on Kubernetes platform
CN103109271B (en) The implementation method of migrate application and system between a kind of platform
CN106533804A (en) Network operation support system
CN106358245A (en) Load sharing method of mobile edge computing application and controller
CN107580083A (en) A kind of method and system of container IP address distribution
CN109617986A (en) A kind of load-balancing method and the network equipment
CN106656630A (en) Electric marketing service application system, and construction method and platform thereof
CN105468435A (en) NFV dynamic resource distribution method
CN110213304B (en) Block chain network interconnection method and system
CN110162388A (en) A kind of method for scheduling task, system and terminal device
CN103399781B (en) Cloud Server and virtual machine management method thereof
CN104239567B (en) Dimension treating method and apparatus in data warehouse
CN105339899B (en) For making the method and controller of application program cluster in software defined network
CN104484233B (en) A kind of resource allocation methods
CN107819867A (en) The load-balancing method and device of a kind of cluster network
CN101071434B (en) User distributing method, device and system for distributed database system
CN106909529B (en) Machine learning tool middleware and machine learning training method
CN106569898A (en) Resource distribution method and mobile terminal
CN109462508A (en) Node deployment method, device and storage medium
CN105279263A (en) Database connection system and method capable of supporting multi-application sharing
CN104038556B (en) Storage resource collocation method and system in a kind of Sybase I/Q datas storehouse cluster
CN106385330A (en) Network function virtualization composer realization method and device
CN107493184A (en) Virtualize network function dispositions method and system
CN103077127B (en) A kind of method and apparatus of specified data migrating objects
CN105630603A (en) Method and device for deploying virtual servers

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