CN105468625A - Database cluster constructing method by using virtual machine - Google Patents
Database cluster constructing method by using virtual machine Download PDFInfo
- Publication number
- CN105468625A CN105468625A CN201410447817.3A CN201410447817A CN105468625A CN 105468625 A CN105468625 A CN 105468625A CN 201410447817 A CN201410447817 A CN 201410447817A CN 105468625 A CN105468625 A CN 105468625A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- virtual
- cluster
- virtual machine
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a database cluster constructing method by using a virtual machine. The method comprises: installing a virtual database on each virtual machine deployed in a server to form a virtual database cluster; and by adjusting a software configuration, making an acquisition program can automatically write data in a corresponding database and quickly analyze some data by using functions of the database, and making an application interface can automatically visit the corresponding database to display data. According to the method provided by the present invention, a multi-core architecture of the server is fully used, thereby improving a CPU utilization rate of the server; and a MySQL standalone version is implemented, thereby reducing application costs of the database cluster, reducing maintenance work of the database, and making the whole application effect reach the cluster database demand, so that the software operation efficiency can be efficiently improved.
Description
Technical field
The present invention relates to Computer Applied Technology field, particularly relate to a kind of method utilizing Imaginary Mechanism database construction cluster.
Background technology
The data volume that cluster resource supervisory system gathers is very large, and form large data form, for single menology, use 1000 nodes, the record number of so single menology just can reach 8,640 ten thousand.So just form the bottleneck of a whole set of software operation efficiency.
Summary of the invention
The object of the invention is to solve above technical matters, proposing a kind of method utilizing Imaginary Mechanism database construction cluster improving software operation efficiency.
The present invention is achieved by the following technical measures:
A kind of method of Imaginary Mechanism database construction cluster that utilizes comprises:
Step 1, is arranged on virtual data base in each virtual machine of server deploy, thus forms virtual data base cluster; And
Step 2, by adjustment software merit rating, enable capture program automatically data be write corresponding database, the function utilizing database to carry carries out express-analysis to some data, and application interface can the corresponding database of automatic access, carries out the display of data.
Such scheme also comprises:
In step 1, the MySQL database standalone version adopting linux system to carry is as the basis of data-base cluster, a station server is set up multiple stage virtual machine, the a set of database of every platform virtual machine deploy, organically one group of MySQL database is formed a whole, form data-base cluster, by to the analysis of multiple virtual platform in operability, managerial, second development interface ease for use, the optimal virtual platform a physical server deploy, then multiple virtual machine is installed on virtual platform, has formed cluster virtual machine;
In step 2, software parameter is configured, makes the node that each virtual data base is corresponding different.
Such scheme comprises further:
In step 1, on every platform virtual machine, MySQL database is installed, forms virtual data base cluster;
In step 2, by large Data Segmentation, leave in different virtual data bases, the function utilizing database to carry carries out express-analysis to some data.
In step 2, display routine can to read in associated databases data by analysis according to configuration, and result is shown to user fast.
The present invention utilizes the method for Imaginary Mechanism database construction cluster, the free MySQL database standalone version that this virtual data base Clustering adopts linux system to carry is as the basis of data-base cluster, a station server is set up multiple stage virtual machine, the a set of database of every platform virtual machine deploy, organically one group of MySQL database is formed a whole, form data-base cluster.This virtual data base Clustering takes full advantage of the multicore architecture of server, improves the cpu busy percentage of server; And owing to adopting MySQL standalone version, reduce the application cost of data-base cluster, decrease the maintenance of database, overall applicability effect reaches the requirement of Cluster Database, thus effective operational efficiency that must improve software.
Accompanying drawing explanation
Fig. 1 is a kind of process flow diagram utilizing the specific embodiment of the method for Imaginary Mechanism database construction cluster of the present invention.
Fig. 2 is a kind of principle schematic utilizing the method for Imaginary Mechanism database construction cluster of the present invention.
Embodiment
For making above and other object of the present invention, feature and advantage can become apparent, cited below particularly go out preferred embodiment, and coordinate institute's accompanying drawings, be described in detail below.
As shown in Figure 1, Fig. 1 is a kind of process flow diagram utilizing the method for Imaginary Mechanism database construction cluster of the present invention.In step 101, on a physical server, the KVM virtual software selecting linux system to carry is as virtual platform, and dispose multiple stage virtual machine, every platform virtual machine takies a CPU core.Flow process enters into step 102.
In step 102, on every platform virtual machine, MySQL database standalone version is installed, forms virtual data base cluster.Fig. 2 is a kind of principle schematic utilizing the method for Imaginary Mechanism database construction cluster of the present invention.Database 01 is an entity data bak, deposits the data such as center configuration; Virtual data base 02 ~ virtual data base N is multiple virtual data base, deposits the information that supervisory system gathers.Flow process enters into step 103.
In step 103, carry out software merit rating, make the corresponding virtual data base of a group node, reach the object split by large list.Flow process enters into step 104.
In step 104, configured by reading software, capture program can dynamic conditioning, the nodal information collected is write associated databases automatically according to configuration, comprises process number, cpu usage, internal memory service condition, local disk read or write speed, network transfer speeds etc.Flow process enters into step 105.
In step 105, due to the foundation of virtual data base cluster, the list of large data is decomposed, so the function that database can be utilized to carry carries out express-analysis to some data.Flow process enters into step 106.
In step 106, display routine can automatically extract data from associated databases according to configuration and show, thus improves reading speed.
Claims (4)
1. utilize a method for Imaginary Mechanism database construction cluster, it is characterized in that comprising:
Step 1, is arranged on virtual data base in each virtual machine of server deploy, thus forms virtual data base cluster; And
Step 2, by adjustment software merit rating, enable capture program automatically data be write corresponding database, the function utilizing database to carry carries out express-analysis to some data, and application interface can the corresponding database of automatic access, carries out the display of data.
2. the method utilizing Imaginary Mechanism database construction cluster according to claim 1, is characterized in that:
In step 1, the MySQL database standalone version adopting linux system to carry is as the basis of data-base cluster, a station server is set up multiple stage virtual machine, the a set of database of every platform virtual machine deploy, organically one group of MySQL database is formed a whole, form data-base cluster, by to the analysis of multiple virtual platform in operability, managerial, second development interface ease for use, the optimal virtual platform a physical server deploy, then multiple virtual machine is installed on virtual platform, has formed cluster virtual machine;
In step 2, software parameter is configured, makes the node that each virtual data base is corresponding different.
3. the method utilizing Imaginary Mechanism database construction cluster according to claim 2, is characterized in that:
In step 1, on every platform virtual machine, MySQL database is installed, forms virtual data base cluster;
In step 2, by large Data Segmentation, leave in different virtual data bases, the function utilizing database to carry carries out express-analysis to some data.
4. the method utilizing Imaginary Mechanism database construction cluster according to claim 1,2 or 3, it is characterized in that: in step 2, display routine can to read in associated databases data by analysis according to configuration, and result is shown to user fast.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410447817.3A CN105468625A (en) | 2014-09-04 | 2014-09-04 | Database cluster constructing method by using virtual machine |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410447817.3A CN105468625A (en) | 2014-09-04 | 2014-09-04 | Database cluster constructing method by using virtual machine |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105468625A true CN105468625A (en) | 2016-04-06 |
Family
ID=55606332
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410447817.3A Pending CN105468625A (en) | 2014-09-04 | 2014-09-04 | Database cluster constructing method by using virtual machine |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105468625A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106506191A (en) * | 2016-09-23 | 2017-03-15 | 郑州云海信息技术有限公司 | The automatically dispose serviced based on virtual platform Redis and maintaining method |
| CN107247744A (en) * | 2017-05-18 | 2017-10-13 | 杭州沃趣科技股份有限公司 | A kind of quick establishment and the efficient database that manages are for the method in storehouse |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090063123A1 (en) * | 2007-08-31 | 2009-03-05 | International Business Machines Corporation | Systems, methods and computer products for database cluster modeling |
| CN101859317A (en) * | 2010-05-10 | 2010-10-13 | 浪潮电子信息产业股份有限公司 | Method for establishing database cluster by utilizing virtualization |
| CN103067501A (en) * | 2012-12-28 | 2013-04-24 | 广州杰赛科技股份有限公司 | Large data processing method of PaaS platform |
| CN103345431A (en) * | 2013-07-23 | 2013-10-09 | 中国联合网络通信有限公司海南省分公司 | Service cloud platform system based on virtualization technology |
-
2014
- 2014-09-04 CN CN201410447817.3A patent/CN105468625A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090063123A1 (en) * | 2007-08-31 | 2009-03-05 | International Business Machines Corporation | Systems, methods and computer products for database cluster modeling |
| CN101859317A (en) * | 2010-05-10 | 2010-10-13 | 浪潮电子信息产业股份有限公司 | Method for establishing database cluster by utilizing virtualization |
| CN103067501A (en) * | 2012-12-28 | 2013-04-24 | 广州杰赛科技股份有限公司 | Large data processing method of PaaS platform |
| CN103345431A (en) * | 2013-07-23 | 2013-10-09 | 中国联合网络通信有限公司海南省分公司 | Service cloud platform system based on virtualization technology |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106506191A (en) * | 2016-09-23 | 2017-03-15 | 郑州云海信息技术有限公司 | The automatically dispose serviced based on virtual platform Redis and maintaining method |
| CN107247744A (en) * | 2017-05-18 | 2017-10-13 | 杭州沃趣科技股份有限公司 | A kind of quick establishment and the efficient database that manages are for the method in storehouse |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wang et al. | Performance prediction for apache spark platform | |
| CN109756364B (en) | Micro-service performance optimization system and analysis method based on log analysis | |
| Liu et al. | A hybrid ICT-solution for smart meter data analytics | |
| Di et al. | Characterizing and modeling cloud applications/jobs on a Google data center | |
| CN106611046A (en) | Big data technology-based space data storage processing middleware framework | |
| CN101650687B (en) | Large-scale parallel program property-predication realizing method | |
| CN106469103B (en) | The maintaining method and device of hard disk | |
| CN111355606B (en) | Web application-oriented container cluster self-adaptive expansion and contraction system and method | |
| CN102170474A (en) | Method and system for dynamic scheduling of virtual resources in cloud computing network | |
| CN105653398B (en) | A kind of smart allocation operating system mirror method | |
| CN106126601A (en) | A kind of social security distributed preprocess method of big data and system | |
| CN102915269A (en) | Method for analyzing common logs of B/S (browser/server) software system | |
| CN102880709A (en) | Data warehouse management system and data warehouse management method | |
| CN103927368A (en) | Method of lightweight framework for generating thermodynamic diagram according to streaming data concept | |
| CN102426475A (en) | Energy saving method, energy saving management server and system under desktop virtual environment | |
| CN111198918B (en) | Data processing system based on big data platform and link optimization method | |
| CN103914307A (en) | Interactive-interface fast implementation method based on reusable library | |
| CN105068934A (en) | Benchmark test system and method for cloud platform | |
| CN103136244A (en) | Parallel data mining method and system based on cloud computing platform | |
| CN103778050A (en) | Database server high-availability performance detecting system | |
| CN109190025A (en) | information monitoring method, device, system and computer readable storage medium | |
| Liu et al. | On construction of an energy monitoring service using big data technology for smart campus | |
| CN103685564A (en) | Plug-in application ability layer introduced industry application online operation cloud platform architecture | |
| CN102567186A (en) | Automated software testing method | |
| CN105354127A (en) | Cloud management platform based monitoring 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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160406 |