CN104598524A - SQL and SERVER database cluster multiple-instance internal storage management and distribution method - Google Patents
SQL and SERVER database cluster multiple-instance internal storage management and distribution method Download PDFInfo
- Publication number
- CN104598524A CN104598524A CN201410806579.0A CN201410806579A CN104598524A CN 104598524 A CN104598524 A CN 104598524A CN 201410806579 A CN201410806579 A CN 201410806579A CN 104598524 A CN104598524 A CN 104598524A
- Authority
- CN
- China
- Prior art keywords
- server
- node
- memory
- database
- 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.)
- Pending
Links
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/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9535—Search customisation based on user profiles and personalisation
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the field of data processing, and relates to an SQL and SERVER database cluster multiple-instance internal storage management and distribution method. The method comprises the following steps: 1. configuring an SQL and SERVER database cluster environment of multiple nodes and multiple instances; 2. configuring the server internal storage which database instances occupy; 3. configuring the occupied server internal storage after cluster nodes break down and the database instances are switched; 4. configuring cluster node fault recovery, the database instances are switched to original nodes, and the server internal storage which instances occupy is recovered to a configuration value. The SQL and SERVER database cluster multiple-instance internal storage management and distribution method have the advantages that a standby node server is saved; dynamic distribution to the server internal storage of an instances objective is conducted. Dynamic configuration to management and distribution of multiple-node cluster SQL and SERVER database multiple-instance internal storage is achieved, and the dynamic configuration is of high efficiency and realtime performance.
Description
Technical field
The invention belongs to data processing field, relate to memory management and the distribution method of SQL SERVER data-base cluster example, for realizing dynamic assignment and the management of the database Multi-instance internal memory of application on site.
Background technology
At present in multinode, many examples field of SQL SERVER data-base cluster, be the configuration of N node, a N-1 example mostly, a node is as secondary node, and on all the other nodes, each node runs an example.This configuration, not too perfect, there are some problems.Particular problem comprises: 1. waste a node server, and under normal circumstances, secondary node server does not have on-line operation database.2. each example is according to business demand, and the resource taken is different, and the configuration of node server is identical, and it is low that resource occupation has height to have, cannot mean allocation resource.3. secondary node is for subsequent use of all nodes, and when appearance more than one node failure, this secondary node can run and multiplely take the high example of resource, and the resource of secondary node is distributed not, affects service operation.And multinode many examples cluster, example is split as multiple little example, each node runs Multi-instance, and the pressure mean allocation run by example is on each database node server.In data-base cluster field, seeking the method for the maximum utilization of server resource, be one of current important research and development problem always.
Summary of the invention
The technical matters solved: fundamental purpose of the present invention is, solve the problem in existing field, a kind of method of new SQL SERVER data-base cluster many examples memory management and distribution is provided, the resource of integrated databases is used to greatest extent.
Technical scheme: the present invention adopts following technical scheme to realize, is divided into four steps.
Step 1: the SQL SERVER data-base cluster environment of the many examples of configuration multinode;
The cluster environment of configuration multinode, is divided into Multi-instance according to nodes, the amount of memory of server configuration, CPU frequency by database; Concrete configuration is distributed by instance number=nodes × 2; Installation database example on clustered node, each example needs be arranged on two nodes; Each node needs installation 4 examples, and 2 examples normally run, and another 2 examples are for subsequent use of all the other node instance;
Step 2: the server memory that configuration database example takies;
The destination server internal memory of built-in system function sp_ configure function to example in usage data storehouse is configured; The destination server internal memory of each example needs be configured to server memory 45%; Databases occupancy volume when each node is run is 90%;
Step 3: allocation cluster node failure, server memory shared after database instance switches;
Usage data storehouse server level objects trigger device reconfigures the example internal memory after cluster switching; Flip-flop toggle after example switches, reads the example number that this server node is running; Calculate according to following formula:
Destination server internal memory=clustered node server memory quantity × 90% ÷ node running example the number of example
The destination server internal memory of usage data built-in function sp_configure function to example is configured;
Step 4: allocation cluster node failure recovers, and database instance switches back origin node, and the server memory that example takies recovers back Configuration Values.
Beneficial effect: multi-node cluster SQL SERVER database many examples memory management of the present invention and distribution method at least have following advantages: 1, save secondary node server.In multi-node cluster SQL SERVER database many examples memory management of the present invention and distribution method, the node server of each cluster runs the example of more than 2 or 2, there is not database node server for subsequent use.2, the waste of node server resource is decreased.In multi-node cluster SQL SERVER database many examples memory management of the present invention and distribution method, the node server internal memory that database instance takies, can be multifactor according to service needed, node memory value etc., calculate, draw optimized memory value, make the memory value on each node server can obtain the most effectively utilizing.3, dynamic assignment is carried out to example goal server memory.In multi-node cluster SQL SERVER database many examples memory management of the present invention and distribution method, after cluster carries out failover, can redistribute the destination server internal memory of each database instance, after there will not be failover, some node running examples are too much, cause the phenomenon that internal memory collapses.In sum, present invention achieves the mobilism configuration of multi-node cluster SQL SERVER database many examples memory management and distribution, the memory source of clustered node is utilized there is high efficiency and real-time.Having significant progress technically, and have obvious good effect, is really a new and innovative, progressive, practical new method.
Embodiment
Be described in detail to the technical scheme in the embodiment of the present invention below, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, the every other embodiment that those of ordinary skill in the art obtain under the prerequisite not making creative work, all belongs to the scope of protection of the invention.
Step 1: the SQL SERVER data-base cluster environment of the many examples of configuration multinode;
The cluster environment of configuration multinode, is divided into Multi-instance according to nodes, the amount of memory of server configuration, CPU frequency by database; Concrete configuration is distributed by instance number=nodes × 2; Installation database example on clustered node, each example needs be arranged on two nodes; Each node needs installation 4 examples, and 2 examples normally run, and another 2 examples are for subsequent use of all the other node instance;
Step 2: the server memory that configuration database example takies;
The destination server internal memory of built-in system function sp_ configure function to example in usage data storehouse is configured; The destination server internal memory of each example needs be configured to server memory 45%; Databases occupancy volume when each node is run is 90%;
Step 3: allocation cluster node failure, server memory shared after database instance switches;
Usage data storehouse server level objects trigger device reconfigures the example internal memory after cluster switching; Flip-flop toggle after example switches, reads the example number that this server node is running; Calculate according to following formula:
Destination server internal memory=clustered node server memory quantity × 90% ÷ node running example the number of example
The destination server internal memory of usage data built-in function sp_configure function to example is configured;
Step 4: allocation cluster node failure recovers, and database instance switches back origin node, and the server memory that example takies recovers back Configuration Values.
Claims (5)
1. the many examples memory management of SQL SERVER data-base cluster and distribution method, is characterized in that comprising the following steps:
The SQL SERVER data-base cluster environment of step 1, the many examples of configuration multinode; The cluster environment of configuration multinode, is divided into Multi-instance according to nodes, the amount of memory of server configuration, CPU frequency by database;
The server memory that step 2, configuration database example take; The destination server internal memory of built-in system function sp_ configure function to example in usage data storehouse is configured;
Step 3, allocation cluster node failure, server memory shared after database instance switches;
Usage data storehouse server level objects trigger device reconfigures the example internal memory after cluster switching; Flip-flop toggle after example switches, reads the example number that this server node is running, and calculates; The destination server internal memory of usage data built-in function sp_configure function to example is configured;
Step 4, allocation cluster node failure recover, and database instance switches back origin node, and the server memory that example takies recovers back Configuration Values.
2. SQL SERVER data-base cluster according to claim 1 many examples memory management and distribution method, it is characterized in that: when database being divided into Multi-instance according to nodes, the amount of memory of server configuration, CPU frequency in step 1, concrete configuration is distributed by instance number=nodes × 2.
3. SQL SERVER data-base cluster according to claim 1 many examples memory management and distribution method, is characterized in that: in step 1 on clustered node installation database example, each example needs be arranged on two nodes; Each node needs installation 4 examples, and 2 examples normally run, and another 2 examples are for subsequent use of all the other node instance.
4. SQL SERVER data-base cluster according to claim 1 many examples memory management and distribution method, is characterized in that: in step 2, the destination server internal memory of each example needs to be configured to 45% of server memory; Databases occupancy volume when each node is run is 90%.
5. SQL SERVER data-base cluster according to claim 1 many examples memory management and distribution method, is characterized in that: in step 3, account form is the destination server internal memory=clustered node server memory quantity × 90% ÷ node running example number of example.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410806579.0A CN104598524A (en) | 2014-12-23 | 2014-12-23 | SQL and SERVER database cluster multiple-instance internal storage management and distribution method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410806579.0A CN104598524A (en) | 2014-12-23 | 2014-12-23 | SQL and SERVER database cluster multiple-instance internal storage management and distribution method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104598524A true CN104598524A (en) | 2015-05-06 |
Family
ID=53124310
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410806579.0A Pending CN104598524A (en) | 2014-12-23 | 2014-12-23 | SQL and SERVER database cluster multiple-instance internal storage management and distribution method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104598524A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114138451A (en) * | 2020-09-03 | 2022-03-04 | 北京金山云网络技术有限公司 | Cluster deployment method and device, disk allocation method, electronic device and medium |
| CN116501764A (en) * | 2023-06-27 | 2023-07-28 | 深圳联友科技有限公司 | Automatic SQL optimization method based on generated pre-training model |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1960521A (en) * | 2006-11-30 | 2007-05-09 | 华为技术有限公司 | Method and system of increasing system capacity of multimedia message service |
| CN101227315A (en) * | 2007-01-17 | 2008-07-23 | 上海市医疗保险信息中心 | Dynamic state server colony and control method thereof |
| CN103430159A (en) * | 2011-03-13 | 2013-12-04 | 国际商业机器公司 | Dynamic memory management in a virtualized computing environment |
| CN103605613A (en) * | 2013-11-21 | 2014-02-26 | 中标软件有限公司 | Method and system for dynamically adjusting virtual-machine memory in cloud computing environment |
| CN103838633A (en) * | 2012-11-20 | 2014-06-04 | 国际商业机器公司 | Out-of-memory avoidance in dynamic virtual machine memory adjustment |
| CN103885838A (en) * | 2014-03-27 | 2014-06-25 | 北京大学 | Method for acquiring virtual machine memory working sets and memory optimization and allocation method |
-
2014
- 2014-12-23 CN CN201410806579.0A patent/CN104598524A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1960521A (en) * | 2006-11-30 | 2007-05-09 | 华为技术有限公司 | Method and system of increasing system capacity of multimedia message service |
| CN101227315A (en) * | 2007-01-17 | 2008-07-23 | 上海市医疗保险信息中心 | Dynamic state server colony and control method thereof |
| CN103430159A (en) * | 2011-03-13 | 2013-12-04 | 国际商业机器公司 | Dynamic memory management in a virtualized computing environment |
| CN103838633A (en) * | 2012-11-20 | 2014-06-04 | 国际商业机器公司 | Out-of-memory avoidance in dynamic virtual machine memory adjustment |
| CN103605613A (en) * | 2013-11-21 | 2014-02-26 | 中标软件有限公司 | Method and system for dynamically adjusting virtual-machine memory in cloud computing environment |
| CN103885838A (en) * | 2014-03-27 | 2014-06-25 | 北京大学 | Method for acquiring virtual machine memory working sets and memory optimization and allocation method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114138451A (en) * | 2020-09-03 | 2022-03-04 | 北京金山云网络技术有限公司 | Cluster deployment method and device, disk allocation method, electronic device and medium |
| CN116501764A (en) * | 2023-06-27 | 2023-07-28 | 深圳联友科技有限公司 | Automatic SQL optimization method based on generated pre-training model |
| CN116501764B (en) * | 2023-06-27 | 2023-08-25 | 深圳联友科技有限公司 | Automatic SQL optimization method based on generated pre-training model |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110225074B (en) | A communication message distribution system and method based on device address field | |
| CN101227315B (en) | Dynamic state server colony and control method thereof | |
| CN101977124B (en) | Service clustering method and system based on ZooKeeper technology | |
| CN109783577B (en) | A policy-based cloud database elastic scaling method | |
| CN103095806B (en) | A kind of load balancing management system of the real-time dataBase system towards bulk power grid | |
| CN104486445A (en) | Distributed extendable resource monitoring system and method based on cloud platform | |
| CN104133727A (en) | Load distribution method based on real-time resources | |
| CN105141456A (en) | Method for monitoring high-availability cluster resource | |
| CN105337780B (en) | A kind of server node configuration method and physical node | |
| CN102117225B (en) | Industrial automatic multi-point cluster system and task management method thereof | |
| CN102571499A (en) | Monitoring method of cloud database server cluster | |
| CN106685724A (en) | Election-based node server management method, device and system | |
| CN105577430A (en) | Node management method of high-end fault-tolerant server | |
| CN204650507U (en) | Virtual resources integration platform in a kind of system for cloud computing | |
| WO2014135011A1 (en) | Database system and data synchronization method | |
| CN105977975A (en) | Switch adjacency relationship-based disperse configuration method of feeder topology | |
| CN104598524A (en) | SQL and SERVER database cluster multiple-instance internal storage management and distribution method | |
| US20170192488A1 (en) | Dynamically adapting to demand for server computing resources | |
| CN104102301A (en) | 2U (unit) ultrahigh-density storage server | |
| CN111418187A (en) | Scalable statistics and analysis mechanism in cloud networks | |
| CN105069170A (en) | Mass spacial information storage and service integrated machine system | |
| CN102831016B (en) | A cloud computing physical machine recycling method and device thereof | |
| CN104518995A (en) | Switch virtualization system based on distributed architecture | |
| CN108090011A (en) | A kind of SAS Switch controllers extension framework and design method | |
| CN103136336A (en) | Mass data integration system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150506 |