CN104038556A - Method and system for configuring storage resources in Sybase IQ database cluster - Google Patents
Method and system for configuring storage resources in Sybase IQ database cluster Download PDFInfo
- Publication number
- CN104038556A CN104038556A CN201410295537.5A CN201410295537A CN104038556A CN 104038556 A CN104038556 A CN 104038556A CN 201410295537 A CN201410295537 A CN 201410295537A CN 104038556 A CN104038556 A CN 104038556A
- Authority
- CN
- China
- Prior art keywords
- optical fiber
- data
- sybase
- base cluster
- storage
- 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
Links
Abstract
Disclosed are a method and system for configuring storage resources in a Sybase IQ database cluster. The method comprises the steps that the Sybase IQ database cluster is arranged on a server; the server, optical fiber storage cards, an optical fiber switch and storage equipment are connected through optical fiber links; the optical fiber switch is set to be a load balance strategy capable of meeting the Sybase IQ database cluster; port trunking is carried out on ports of all the storage equipment connected with the optical fiber storage cards, and path pointing is carried out on the different optical fiber storage cards respectively; the optical fiber storage cards are added to the Sybase IQ database cluster in a unified mode through relevant commands; the optical fiber storage cards are set to be in a load balance mode, and different load balance strategies are respectively set according to storage needs. Storage bandwidth resources can be reasonably utilized in a Sybase IQ database, and unified management is carried out on the storage bandwidth resources.
Description
Technical field
The present invention relates to computer realm, be specifically related to storage means and system in a kind of Sybase IQ data-base cluster.
Background technology
In recent years, rapid development of information technology, the arrival of large data age, impels large-scale application to increase sharply to Database Requirements, storage demand explosive growth.Sybase IQ, as database platform, in the time of application deployment environment, there will be following problem often:
A large amount of application systems, a large amount of customer groups, is used a large amount of memory bandwidth resources, so cause memory bandwidth inadequate resource.Traditional deployment scheme can not unified management, and resource can not rationally be utilized.
Summary of the invention
The technical problem to be solved in the present invention is how in Sybase IQ database, rationally to utilize memory bandwidth resource, to memory bandwidth resource unified management.
In order to address the above problem, the invention provides the storage resources collocation method in a kind of Sybase IQ data-base cluster, comprising:
Sybase IQ data-base cluster is installed on server; Described server, optical fiber storage card, optical fiber switch, memory device are coupled together by optical fiber link;
On described optical fiber switch, configure Sybase IQ data-base cluster; Described optical fiber switch is arranged to meet to the load balancing of described Sybase IQ data-base cluster;
The each memory device connecting for polylith optical fiber storage card, carries out port trunking to port, and respectively different optical fiber storage cards is carried out the sensing in path;
Optical fiber storage card unification described in polylith is joined in described Sybase IQ data-base cluster by relevant order;
Each optical fiber storage card is carried out to the setting of load balancing, described polylith optical fiber storage card is arranged to load-sharing mode, according to storage demand, different load balancings is set respectively.
Alternatively, described method also comprises:
The unstructured data of Sybase IQ data-base cluster storage and structural data are distinguished to the Zone the inside that different optical fiber switch is divided;
In the time there is data access in enormous quantities, Sybase IQ data-base cluster is according to the tactful partition database that sets, by described data in enormous quantities by different optical fiber link accesses.
Alternatively, described method also comprises:
In the optical fiber storage card arranging by load balancing and Sybase IQ database, data interact, and data volume is divided and is downloaded on different optical fiber links.
Alternatively, described method also comprises:
Described Sybase IQ data-base cluster carries out unified management to polylith optical fiber storage card.
Alternatively, described method also comprises:
In the time that storage demand is submitted to, distribute corresponding memory load balanced mode by Sybase IQ data-base cluster, and to each server distribution;
In the time that memory load changes, monitor and change its mode of loading by Sybase IQ data-base cluster, reach optimal storage and select.
The present invention also provides the storage resources configuration-system in a kind of Sybase IQ data-base cluster, for Sybase IQ data base cluster system; Described Sybase IQ data base cluster system comprises: by the connected server of optical fiber link, optical fiber storage card, optical fiber switch, memory device; Sybase IQ data-base cluster is installed on described server; Described storage resources configuration-system comprises:
The first configuration module, for configuring Sybase IQ data-base cluster on described optical fiber switch; Described optical fiber switch is arranged to meet to the load balancing of described Sybase IQ data-base cluster;
The second configuration module, for the each memory device connecting for polylith optical fiber storage card, carries out port trunking to port, and respectively different optical fiber storage cards is carried out the sensing in path;
Load-on module, for joining described Sybase IQ data-base cluster by optical fiber storage card unification described in polylith by relevant order;
The 3rd configuration module, for each optical fiber storage card is carried out to the setting of load balancing, is arranged to load-sharing mode by described polylith optical fiber storage card, according to storage demand, different load balancings is set respectively.
Alternatively, described system also comprises:
First divides module, the Zone the inside of dividing for the unstructured data of Sybase IQ data-base cluster storage and structural data being distinguished to different optical fiber switch;
Second divide module, in the time there is data access in enormous quantities, according to the tactful partition database setting, by described data in enormous quantities by different optical fiber link accesses.
Alternatively, in the optical fiber storage card arranging by load balancing and Sybase IQ database, data interact, and data volume is divided and is downloaded on different optical fiber links.
Alternatively, the Sybase IQ data-base cluster on described server is for carrying out unified management to polylith optical fiber storage card.
Alternatively, the Sybase IQ data-base cluster on described server is also for submitting to the time-division match memory load balanced mode of answering in storage demand, and distributes to each server; In the time that memory load changes, monitor and change its mode of loading.
In the present invention, the cluster of Sybase IQ is supported multiple memory load balanced mode, utilizes the characteristic of the concurrent load of storage networking can use the bandwidth of polylith optical fiber storage card simultaneously, has increased overall memory property, has simplified action; Adopt multiple memory load balanced mode in Sybase IQ to work simultaneously, greatly improve the efficiency of storing received and transmission data, also evaded the problem of storage resources waste, therefore in high memory bandwidth transmission system, or in large data handling system, there is vast potential for future development, there is very high technological value.In addition for different optical fiber storage cards, can use according to its performance characteristics, can provide more personalized storage environment support for Sybase IQ data-base cluster, thereby reach better, the cost-saving object of ease for use, improve the utilance of storage, and reduce the problem that artificial switching exists, evaded risk; Moreover, the unified management by Sybase IQ to multiple optical fiber storage card, unified plan, United Dispatching, had both saved administrative time, had reduced again management cost.
Brief description of the drawings
Fig. 1 is the schematic diagram that designs a model of embodiment mono-;
Fig. 2 is the schematic flow sheet of the example of embodiment mono-.
Embodiment
Below in conjunction with drawings and Examples, technical scheme of the present invention is described in detail.
It should be noted that, if do not conflicted, each feature in the embodiment of the present invention and embodiment can mutually combine, all within protection scope of the present invention.In addition, although there is shown logical order in flow process, in some cases, can carry out shown or described step with the order being different from herein.
Storage resources collocation method in embodiment mono-, a kind of Sybase IQ data-base cluster, comprising:
Sybase IQ data-base cluster is installed on server; Described server, optical fiber storage card, optical fiber switch, memory device are coupled together by optical fiber link.
On optical fiber switch, configure Sybase IQ data-base cluster; Described optical fiber switch is arranged to meet to the load balancing of described Sybase IQ data-base cluster;
The each memory device connecting for polylith optical fiber storage card, carries out port trunking to port, and respectively different optical fiber storage cards is carried out the sensing in path;
The unification of polylith optical fiber storage card is joined in described Sybase IQ data-base cluster by relevant order;
Each optical fiber storage card is carried out to the setting of load balancing, described polylith optical fiber storage card is arranged to load-sharing mode, according to storage demand, different load balancings is set respectively.
In the present embodiment, can be, but not limited to, by the associated storage such as multipath, rdac load balancing software, each optical fiber storage card is carried out to the setting of load balancing.
In the present embodiment, active – active pattern is set on memory device, optical fiber storage card all be may be used in this example.
In an embodiment of the present embodiment, described method can also comprise:
The unstructured data of Sybase IQ data-base cluster storage and structural data are distinguished to the Zone the inside that different optical fiber switch is divided;
In the time there is data access in enormous quantities, Sybase IQ data-base cluster is according to the tactful partition database that sets, by described data in enormous quantities by different optical fiber link accesses.
In present embodiment, the Zone dividing for different optical fiber switch can divide according to the data characteristics of Sybase IQ data-base cluster; Can alleviate and mix the problem of storing the inefficiency of bringing by different link access datas.
In an embodiment of the present embodiment, described method can also comprise:
In the optical fiber storage card arranging by load balancing and Sybase IQ database, data interact, and data volume is divided and is downloaded on different optical fiber links.
Present embodiment can reach the object of streamed data amount.
Designing a model as shown in Figure 1 of the present embodiment, wherein the linking (link) of memory device → Sybase IQ data-base cluster is the first step, memory device is connected to Sybase IQ data-base cluster, offers Sybase IQ data-base cluster and use; The share (sharing) of server (server) → server shows second step, and storage is carried out to load balancing to all hosts; Finally memory device being offered to needed APP (application) uses.Whole process only needs shirtsleeve operation to complete.
Large market demand, as current advanced person's technological means, can do unified management to data center, unified plan; The performance of storage resources, with stable, also must become the foundation of large market demand.Based on this kind of thought, carry more storage resources, be the perfect certainty of Sybase IQ clustering functionality.The present embodiment takes into full account that large data age storage demand is huge, adopts multiple load-sharing mode in Sybase IQ, makes its concurrent working; Coordinate corresponding memory technology feature, system is carried out to load balancing work to equipment and equipment to the storage of system both direction, improve the transmission bandwidth utilance of stores processor system with this, thereby reach the object of elevator system performance.
The present embodiment uses polylith optical fiber storage card load balancing, since can bring into play the performance of its storage, can improve again its compatibility.The memory bandwidth that has increased Sybase IQ, has improved its combination property greatly.
In the test and implementation process of Sybase IQ, usually can run into the situation of memory property deficiency, complexity is not only set, also to improve the utilance of storage resources; The present embodiment is successfully incorporated into the technology of Sybase IQ and storage in the middle of application deployment work, the pattern of multiple memory load equilibrium is focused under unified systems organization, simplify action, evade work risk, simultaneously, owing to using SybaseIQ unified management, simplify step and the time of management.
In an embodiment of the present embodiment, described method can also comprise:
Described Sybase IQ data-base cluster carries out unified management to polylith optical fiber storage card.
The method of present embodiment can flexible Application, also for other work facilitates.
In an embodiment of the present embodiment, described method can also comprise:
In the time that storage demand is submitted to, distribute corresponding memory load balanced mode by Sybase IQ data-base cluster, and to each database server distribution;
In the time that memory load changes, monitor and change its mode of loading by Sybase IQ data-base cluster, reach optimal storage and select.
Same, for External memory equipment, also need, by changing corresponding strategy, to complete the load of storage.
Present embodiment, for the storage demand newly adding, is carried out the setting of load balancing, and SybaseIQ data-base cluster carries out unified management.In the time of needs storage resources, carry out primary screening, load to respectively on different optical fiber storage cards for the storage of different performance demand, can make rational use of resources, improve overall performance, also save cost.
A kind of example of the present embodiment as shown in Figure 2, comprises step 201～207:
201, Sybase IQ data-base cluster is installed.
202, configuration optical fiber switch load balancing.
203, divide Zone, partition database according to data characteristics.
204, the port of configure storage devices.
205, each optical fiber storage card is carried out to load balancing setting.
206, judge whether data do not change, and if so, carry out steps 207, otherwise return to step 203.
207, access data.
Storage resources configuration-system in embodiment bis-, a kind of Sybase IQ data-base cluster, for Sybase IQ data base cluster system; Described Sybase IQ data base cluster system comprises: by the connected server of optical fiber link, optical fiber storage card, optical fiber switch, memory device; Sybase IQ data-base cluster is installed on described server; Described storage resources configuration-system comprises:
The first configuration module, for configuring Sybase IQ data-base cluster on described optical fiber switch; Described optical fiber switch is arranged to meet to the load balancing of described Sybase IQ data-base cluster;
The second configuration module, for the each memory device connecting for polylith optical fiber storage card, carries out port trunking to port, and respectively different optical fiber storage cards is carried out the sensing in path;
Load-on module, for joining described Sybase IQ data-base cluster by optical fiber storage card unification described in polylith by relevant order;
The 3rd configuration module, for each optical fiber storage card is carried out to the setting of load balancing, is arranged to load-sharing mode by described polylith optical fiber storage card, according to storage demand, different load balancings is set respectively.
The configuration-system of the present embodiment can be integrated in one independently in equipment, also can be distributed in multiple equipment; Can be existing equipment, can be also newly-increased equipment.
In an embodiment of the present embodiment, described system can also comprise:
First divides module, the Zone the inside of dividing for the unstructured data of Sybase IQ data-base cluster storage and structural data being distinguished to different optical fiber switch;
Second divide module, in the time there is data access in enormous quantities, according to the tactful partition database setting, by described data in enormous quantities by different optical fiber link accesses.
In an embodiment of the present embodiment, the optical fiber storage card arranging by load balancing can also interact with data in Sybase IQ database, and data volume is divided and is downloaded on different optical fiber links.
In an embodiment of the present embodiment, the Sybase IQ data-base cluster on described server can be for carrying out unified management to polylith optical fiber storage card.
In an embodiment of the present embodiment, the Sybase IQ data-base cluster on described server can also be used for submitting to the time-division match memory load balanced mode of answering in storage demand, and distributes to each server; In the time that memory load changes, monitor and change its mode of loading.
Certainly; the present invention also can have other various embodiments; in the situation that not deviating from spirit of the present invention and essence thereof; those of ordinary skill in the art are when making according to the present invention various corresponding changes and distortion, but these corresponding changes and distortion all should belong to the protection range of claim of the present invention.
Claims (10)
1. the storage resources collocation method in Sybase IQ data-base cluster, comprising:
Sybase IQ data-base cluster is installed on server; Described server, optical fiber storage card, optical fiber switch, memory device are coupled together by optical fiber link;
On described optical fiber switch, configure Sybase IQ data-base cluster; Described optical fiber switch is arranged to meet to the load balancing of described Sybase IQ data-base cluster;
The each memory device connecting for polylith optical fiber storage card, carries out port trunking to port, and respectively different optical fiber storage cards is carried out the sensing in path;
Optical fiber storage card unification described in polylith is joined in described Sybase IQ data-base cluster by relevant order;
Each optical fiber storage card is carried out to the setting of load balancing, described polylith optical fiber storage card is arranged to load-sharing mode, according to storage demand, different load balancings is set respectively.
2. the method for claim 1, is characterized in that, also comprises:
The unstructured data of Sybase IQ data-base cluster storage and structural data are distinguished to the Zone the inside that different optical fiber switch is divided;
In the time there is data access in enormous quantities, Sybase IQ data-base cluster is according to the tactful partition database that sets, by described data in enormous quantities by different optical fiber link accesses.
3. method as claimed in claim 2, is characterized in that, also comprises:
In the optical fiber storage card arranging by load balancing and Sybase IQ database, data interact, and data volume is divided and is downloaded on different optical fiber links.
4. the method for claim 1, is characterized in that, also comprises:
Described Sybase IQ data-base cluster carries out unified management to polylith optical fiber storage card.
5. the method for claim 1, is characterized in that, also comprises:
In the time that storage demand is submitted to, distribute corresponding memory load balanced mode by Sybase IQ data-base cluster, and to each server distribution;
In the time that memory load changes, monitor and change its mode of loading by Sybase IQ data-base cluster, reach optimal storage and select.
6. the storage resources configuration-system in Sybase IQ data-base cluster, is characterized in that, for Sybase IQ data base cluster system; Described Sybase IQ data base cluster system comprises: by the connected server of optical fiber link, optical fiber storage card, optical fiber switch, memory device; Sybase IQ data-base cluster is installed on described server; Described storage resources configuration-system comprises:
The first configuration module, for configuring Sybase IQ data-base cluster on described optical fiber switch; Described optical fiber switch is arranged to meet to the load balancing of described Sybase IQ data-base cluster;
The second configuration module, for the each memory device connecting for polylith optical fiber storage card, carries out port trunking to port, and respectively different optical fiber storage cards is carried out the sensing in path;
Load-on module, for joining described Sybase IQ data-base cluster by optical fiber storage card unification described in polylith by relevant order;
The 3rd configuration module, for each optical fiber storage card is carried out to the setting of load balancing, is arranged to load-sharing mode by described polylith optical fiber storage card, according to storage demand, different load balancings is set respectively.
7. system as claimed in claim 6, is characterized in that, also comprises:
First divides module, the Zone the inside of dividing for the unstructured data of Sybase IQ data-base cluster storage and structural data being distinguished to different optical fiber switch;
Second divide module, in the time there is data access in enormous quantities, according to the tactful partition database setting, by described data in enormous quantities by different optical fiber link accesses.
8. system as claimed in claim 7, is characterized in that:
In the optical fiber storage card arranging by load balancing and Sybase IQ database, data interact, and data volume is divided and is downloaded on different optical fiber links.
9. system as claimed in claim 6, is characterized in that:
Sybase IQ data-base cluster on described server is for carrying out unified management to polylith optical fiber storage card.
10. system as claimed in claim 9, is characterized in that:
Sybase IQ data-base cluster on described server is also for submitting to the time-division match memory load balanced mode of answering in storage demand, and distributes to each server; In the time that memory load changes, monitor and change its mode of loading.
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 true CN104038556A (en) | 2014-09-10 |
| CN104038556B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104539671A (en) * | 2014-12-16 | 2015-04-22 | 广东侍卫长卫星应用安全股份公司 | Distributed data collecting method based on Beidou satellite positioning system |
| CN108052393A (en) * | 2017-12-27 | 2018-05-18 | 广州烽睿信息科技有限公司 | A kind of IT resource pools intelligent optimization configuration device |
Citations (3)
| 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 |
-
2014
- 2014-06-26 CN CN201410295537.5A patent/CN104038556B/en active Active
Patent Citations (4)
| 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 |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104539671A (en) * | 2014-12-16 | 2015-04-22 | 广东侍卫长卫星应用安全股份公司 | Distributed data collecting method based on Beidou satellite positioning system |
| CN108052393A (en) * | 2017-12-27 | 2018-05-18 | 广州烽睿信息科技有限公司 | A kind of IT resource pools intelligent optimization configuration device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104038556B (en) | 2017-11-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20100026408A1 (en) | Signal transfer for ultra-high capacity circuits | |
| CN107682871B (en) | Wireless sensor network relay node deployment optimization method and wireless sensor network | |
| CN107220039A (en) | A kind of heterogeneous resource standardized packages system based on cloud environment | |
| CN105339899B (en) | For making the method and controller of application program cluster in software defined network | |
| US11750531B2 (en) | FPGA-based virtual fabric for data center computing | |
| CN109948938A (en) | The bill of materials configuration method and device and equipment of a kind of enterprise resource planning | |
| CN104077138A (en) | Multiple core processor system for integrating network router, and integrated method and implement method thereof | |
| CN106209989A (en) | Spatial data concurrent computational system based on spark platform and method thereof | |
| US20130247038A1 (en) | Device-integration method, terminal-apparatus, and distributed multi-terminal-apparatus system | |
| US9871749B2 (en) | Switch assembly | |
| CN102316043A (en) | Port virtualization method, switch and communication system | |
| US9892042B2 (en) | Method and system for implementing directory structure of host system | |
| Sarikaya et al. | Placement of 5G RAN slices in multi-tier O-RAN 5G networks with flexible functional splits | |
| CN105573672B (en) | A kind of virtualization storage method and system based on NFS | |
| CN103986665A (en) | Method for balancing network load in cloud sea OS | |
| CN114742000B (en) | SoC chip verification system, method and device based on FPGA cluster | |
| CN104580527B (en) | A kind of more I/O high density multi-node server system design methods of cloud service-oriented device application | |
| CN104038556A (en) | Method and system for configuring storage resources in Sybase IQ database cluster | |
| Montone et al. | Wirelength driven floorplacement for FPGA-based partial reconfigurable systems | |
| CN104683249A (en) | Independent configurable interconnection module implementing method for multi-chip interconnection system | |
| CN102508786A (en) | Chip design method for optimizing space utilization rate and chip thereof | |
| CN101963933A (en) | Static instrument matching method adapting to multi-communication protocols in instrument test | |
| CN109064382B (en) | Image information processing method and server | |
| CN209248518U (en) | A kind of solid state hard disk expansion board clamping and server | |
| CN208174743U (en) | A kind of cloud desktop system |
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 |