CN103473176A - Four-subsystem server-based integrated server database application testing method - Google Patents
Four-subsystem server-based integrated server database application testing method Download PDFInfo
- Publication number
- CN103473176A CN103473176A CN2013104390914A CN201310439091A CN103473176A CN 103473176 A CN103473176 A CN 103473176A CN 2013104390914 A CN2013104390914 A CN 2013104390914A CN 201310439091 A CN201310439091 A CN 201310439091A CN 103473176 A CN103473176 A CN 103473176A
- Authority
- CN
- China
- Prior art keywords
- test
- server
- database
- address
- pressing 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
Images
Abstract
The invention provides a four-subsystem server-based integrated server database application testing method. The method comprises the steps of: firstly, using one node of a four-subsystem server as a management server, deploying DHCP (Dynamic host configuration protocol) service, setting up the management side of test software BenchmarkFactory, accessing to a special high-speed testing network switch, similarly, accessing other three nodes of the four-substar server into the special high-speed testing network switch as a presses and deploying the pressure side of the test software BenchmarkFactory, extending the number of the presses as required, deploying the pressure side of the BenchmarkFactory to an additional press and accessing a testing network. The database performance of the server can be tested only by setting up a corresponding database into the to-be-tested server and accessing into the testing network, and by monitoring the resource utilization condition of the to-be-tested server and mastering the use change of hardware resources of the server in a testing process, and the ability of the server to deploy the database can be conveniently analyzed and evaluated.
Description
Technical field
The present invention relates to a kind of Computer Applied Technology, is exactly four computing nodes that utilize four component servers specifically, distributes different roles, forms integrated server database test macro.
Background technology
The application of current I T technology, be all much to be based upon on Basis of Database, and therefore, the performance of server database application is to estimate a very important reference index of server performance.Usual way is to use loadrunner to record some database manipulation, then Reusability these operate test database.It is few that this method is limited to the action type of recording, the convictive test model of neither one, the performance of evaluation server database that can't be very proper.
How to set up a data library test system and become a very crucial problem for the people of testing server database application performance, simultaneously, also require test macro to reduce as much as possible workload, and have and quantize and convictive test data, can reuse and be adapted to multitype database.
Due to the deficiency of said method, we reach the purpose of test database with four component servers.Utilize four computing nodes of four component servers, selected A node is as management node, disposing DHCP server makes 3 pressure nodes in test macro obtain fast testing inner IP address and be totally independent of other networks, without manual setting, reduce the generation of network conflict and interference simultaneously, and can dynamically increase and decrease as required pressure node; Utilize the BenchmarkFactory testing software, the database application performance of testing server, and obtain the test data of a quantification, and the scale of test, time and strategy are all highly controlled, are applicable to multitype database; Can apply different test models for different servers, for single channel or two-way server, can select small-scale test model, multipath server can be selected the large test models such as TPCC, TPCE simultaneously; Simultaneously, management node can be collected the hardware resource utilization situation of tested server, so as to bottleneck and the optimization direction of analyzing the current database application.
Summary of the invention
The purpose of this invention is to provide a kind of integrated server database application testing method based on four component servers.
The objective of the invention is to realize in the following manner,
The invention has the beneficial effects as follows:
Usually the database application of testing server, used a main frame that loadrunner is installed while being generally test, by recording the operation of deciding in advance, then repeat these and operated.Be limited to people's subjective idea, test model is science not; Due to the restriction of concurrent testing, the test of multinode simulation practical application can't be reached, and can't be reflected in the multi-user, the situation of the complex situations of many physical link.Simultaneously, the situation inspection that utilizes of resource needs extra computing machine to complete.
The method of application present patent application, can bring following benefit: (1) integrated apparatus, rapid deployment, recycling, database test assignment (2) retractility that four component server can complete most of server is good, can increase and decrease pressing machine according to test case, running into tested server performance when very powerful, all right many pressing machinees of external expansion, the model cogency of resource utilization (4) test that can monitor test machine in (3) simple to operate test is strong, and it is extensive that large (5) test height controlled (6) of reference significance adapts to database.
The accompanying drawing explanation
Fig. 1 is the database measurement system diagram.
Embodiment
With reference to Figure of description, method of the present invention is described in detail below.
Utilize four computing nodes of four components to be divided into different roles, be one of them node definition supervisor, dispose DHCP server thereon, make other pressing machine obtain the IP address defined after being linked into private branch exchange system, without static ip address manually is set, avoided each pressing machine that the operation of IP address is set, simultaneously in the situation for the pressing machine expansion, without considering the problem such as IP address; Dispose the BenchmarkFactory management end software by supervisor, realized the standardization of database test, can select applicable standard testing model, and can select as required measurement scope, the parameters such as time and strategy, be applicable to multitype database; Can see the real-time status of database test in test process, be convenient to the real-time status of analytical database, the resource utilization for pressing machine also has well and presents simultaneously; The report the test of test can provide the data of the various parameters of whole test, for analyzing whole test process, has good with reference to effect.
B, design a model
This designs a model and takes full advantage of the characteristics of BenchmarkFactory software, the role of test is realized out in four component servers, while is in conjunction with the support of DHCP server, realize the automatic distribution of the IP address of 3 pressing machinees and propagation pressure machine, realized that simplification and standard that the database test macro is disposed dissolve shown in Fig. 1
Testing procedure is as follows:
At first, peace is according to measurement scope reasonable disposition switch, using a node installation Windows operating system of four components and be linked on the switch configured as management end, configures the DHCP service, and the network parameters such as the assignable address field of DHCP are set; BenchmarkFactory software administration end is installed, Oracle is installed, SQL Server, the client in the frequently-used data storehouses such as DB2.Other 3 nodes of four components are installed equally to Windows operating system and are linked on the switch configured as pressing machine, obtain DHCP server by exchange opportunity and distribute the IP address defined, each pressing machine can access one or more network interface cards, can be linked into as required on the test private branch exchange system, obtain the test private ip address, certainly can retain the managing I P of non-test use; The pressure end of BenchmarkFactory software is installed on each pressing machine, Oracle is installed, SQL Server, the client in the frequently-used data storehouses such as DB2, and the pressure end software of pressing machine is arranged to the sensing management end.
When test, at the test model of management end choice criteria, and the definition measurement scope, test duration and Test Strategy, simultaneously, can see real-time test data situation and the cpu busy percentage of each pressure node at management end, the information such as test data, convenient understanding test real-time status.
In whole implementation procedure, by each node division role by four component servers, the database test macro is set up on four component servers, reduced the input of testing apparatus, simultaneously, system extension is good, can need to increase or reduce pressing machine according to test; Test macro is powerful, and the multiple standards test is available; Test height is controlled, and measurement scope, test duration, the Test Strategy height is adjustable; Show in real time test case, and the final test report is arranged; Adaptability is extensive, as long as corresponding driving is installed, and just can the test database performance.
Except the described technical characterictic of instructions, be the known technology of those skilled in the art.
Claims (1)
1. the integrated server database application testing method based on four component servers, it is characterized in that utilizing four computing nodes of four components to be divided into different roles, be one of them node definition supervisor, dispose DHCP server thereon, make other three pressing machinees obtain the IP address defined after being linked into private branch exchange system, without static ip address manually is set, avoided each pressing machine that the operation of IP address is set, simultaneously in the situation for the pressing machine expansion, without the problem of considering the IP address; Dispose the BenchmarkFactory management end software by supervisor, realized the standardization of database test, select applicable standard testing model, can select as required measurement scope, time and policing parameter, can be applicable to multitype database; Can see the real-time status of database test in test process, be convenient to the real-time status of analytical database, the resource utilization for pressing machine also has well and presents simultaneously; The report the test of test can provide the data of the various parameters of whole test, for analyzing whole test process, has good with reference to effect;
Modelling
This designs a model and takes full advantage of the characteristics of BenchmarkFactory software, the role of test is realized out in four component servers, while is in conjunction with the support of DHCP server, realize the automatic distribution of the IP address of 3 pressing machinees and propagation pressure machine, realized simplification and standardization that the database test macro is disposed, testing procedure is as follows:
At first, peace is according to measurement scope reasonable disposition switch, using a node installation Windows operating system of four components and be linked on the switch configured as management end, configures the DHCP service, and the network parameters such as the assignable address field of DHCP are set; BenchmarkFactory software administration end is installed, Oracle is installed, SQL Server, the client in the frequently-used data storehouses such as DB2; Other 3 nodes of four components are installed equally to Windows operating system and are linked on the switch configured as pressing machine, obtain DHCP server by exchange opportunity and distribute the IP address defined, each pressing machine can access one or more network interface cards, be linked into as required on the test private branch exchange system, obtain the test private ip address, or retain the managing I P of non-test use; The pressure end of BenchmarkFactory software is installed on each pressing machine, Oracle is installed, SQL Server, the client in the frequently-used data storehouses such as DB2, and the pressure end software of pressing machine is arranged to the sensing management end;
When test, at the test model of management end choice criteria, and the definition measurement scope, test duration and Test Strategy, simultaneously, can see real-time test data situation and the cpu busy percentage of each pressure node at management end, the information such as test data, convenient understanding test real-time status;
In whole test process, by each node division role by four component servers, the database test macro is set up on four component servers, reduced the input of testing apparatus, simultaneously, system extension is good, can need to increase or reduce pressing machine according to test; Test macro is powerful, and the multiple standards test is available; Test height is controlled, and measurement scope, test duration, the Test Strategy height is adjustable; Show in real time test case, and the final test report is arranged; Adaptability is extensive, as long as corresponding driving is installed, and just can the test database performance.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013104390914A CN103473176A (en) | 2013-09-25 | 2013-09-25 | Four-subsystem server-based integrated server database application testing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013104390914A CN103473176A (en) | 2013-09-25 | 2013-09-25 | Four-subsystem server-based integrated server database application testing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103473176A true CN103473176A (en) | 2013-12-25 |
Family
ID=49798040
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013104390914A Pending CN103473176A (en) | 2013-09-25 | 2013-09-25 | Four-subsystem server-based integrated server database application testing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103473176A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104461804A (en) * | 2014-12-29 | 2015-03-25 | 浪潮电子信息产业股份有限公司 | Server stability test method based on VSphere test software |
| CN105389254A (en) * | 2015-10-19 | 2016-03-09 | 浪潮(北京)电子信息产业有限公司 | System and method for verifying compatibility of server and Oracle Linux system |
| CN109726094A (en) * | 2017-10-27 | 2019-05-07 | 北京京东尚科信息技术有限公司 | The method and apparatus of pressure test |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5790425A (en) * | 1997-02-19 | 1998-08-04 | Sun Microsystems, Inc. | Generic server benchmarking framework in a client-server environment |
| CN1304247A (en) * | 2000-01-11 | 2001-07-18 | 国际商业机器公司 | Frame system and method for testing server performance |
| CN1490723A (en) * | 2002-10-15 | 2004-04-21 | 中国科学院计算技术研究所 | User oriented server performance evaluating and measuring system and method |
| CN101246446A (en) * | 2008-03-12 | 2008-08-20 | 浪潮电子信息产业股份有限公司 | Method for testing PC server performance |
| CN102694698A (en) * | 2012-06-07 | 2012-09-26 | 浪潮电子信息产业股份有限公司 | Method for quickly establishing miniature network testing system |
| CN103188116A (en) * | 2011-12-31 | 2013-07-03 | 中国移动通信集团公司 | Network performance detection method and system of blade server |
-
2013
- 2013-09-25 CN CN2013104390914A patent/CN103473176A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5790425A (en) * | 1997-02-19 | 1998-08-04 | Sun Microsystems, Inc. | Generic server benchmarking framework in a client-server environment |
| CN1304247A (en) * | 2000-01-11 | 2001-07-18 | 国际商业机器公司 | Frame system and method for testing server performance |
| CN1490723A (en) * | 2002-10-15 | 2004-04-21 | 中国科学院计算技术研究所 | User oriented server performance evaluating and measuring system and method |
| CN101246446A (en) * | 2008-03-12 | 2008-08-20 | 浪潮电子信息产业股份有限公司 | Method for testing PC server performance |
| CN103188116A (en) * | 2011-12-31 | 2013-07-03 | 中国移动通信集团公司 | Network performance detection method and system of blade server |
| CN102694698A (en) * | 2012-06-07 | 2012-09-26 | 浪潮电子信息产业股份有限公司 | Method for quickly establishing miniature network testing system |
Non-Patent Citations (1)
| Title |
|---|
| 4784645: ""BENCHMARK FACTORY 性能测试软件的使用"", 《HTTP://WENKU.BAIDU.COM/LINK?URL=BDCQXDJSW9TQWSU5Z7DGQPIC1PQ6EP6OVT85XO22HDSWXCHUOKVKFET0VZMF5GXPSYL4NISFWK4WY34OMI-ETUFOSW9EFY9OJEWBTEBTIGO》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104461804A (en) * | 2014-12-29 | 2015-03-25 | 浪潮电子信息产业股份有限公司 | Server stability test method based on VSphere test software |
| CN105389254A (en) * | 2015-10-19 | 2016-03-09 | 浪潮(北京)电子信息产业有限公司 | System and method for verifying compatibility of server and Oracle Linux system |
| CN109726094A (en) * | 2017-10-27 | 2019-05-07 | 北京京东尚科信息技术有限公司 | The method and apparatus of pressure test |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110162471B (en) | Pressure testing method and system based on container cloud | |
| US9229838B2 (en) | Modeling and evaluating application performance in a new environment | |
| US10057182B2 (en) | Method for providing development and deployment services using a cloud-based platform and devices thereof | |
| Kvalbein et al. | The Nornet Edge platform for mobile broadband measurements | |
| EP2572294B1 (en) | System and method for sql performance assurance services | |
| Larsson et al. | Impact of etcd deployment on Kubernetes, Istio, and application performance | |
| CN104182288A (en) | Method for automatically testing power consumption of server cluster system | |
| CN107590075B (en) | Software testing method and device | |
| CN109144813B (en) | System and method for monitoring server node fault of cloud computing system | |
| CN103051500A (en) | Test method and system of service network system | |
| CN105207844A (en) | Method for testing server stability and system thereof | |
| CN106453506A (en) | Resource unified scheduling test system and method | |
| CN105740142A (en) | Pressure test management system for SSR (Server Security Reinforcement) centralized management platform | |
| CN105404580A (en) | Distributed pressure test system and method | |
| CN111597099B (en) | Non-invasive simulation method for monitoring running quality of application deployed on cloud platform | |
| CN103473176A (en) | Four-subsystem server-based integrated server database application testing method | |
| CN104850492A (en) | Test method of server pressure on basis of Windows | |
| Ben-Yehuda et al. | NAP: a building block for remediating performance bottlenecks via black box network analysis | |
| Xu et al. | LIOProf: Exposing Lustre file system behavior for I/O middleware | |
| CN108093075A (en) | A kind of implementation method of application system gray scale issue | |
| CN116405412B (en) | Method and system for verifying cluster effectiveness of simulation server based on chaotic engineering faults | |
| Kiefer et al. | MulTe: a multi-tenancy database benchmark framework | |
| CN109213665B (en) | Distributed concurrent accelerated test technology and platform construction method | |
| Augusto et al. | RETORCH: an approach for resource-aware orchestration of end-to-end test cases | |
| Liu et al. | Towards a community cloud storage |
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 |
Application publication date: 20131225 |
|
| WD01 | Invention patent application deemed withdrawn after publication |