JMeter connection Configuration MySQL server with a springboard (SSH)

JMeter connection when configuring the MySQL server, if the database server is not connected via SSH, you only need to configure the appropriate JDBC parameters, that is, the request domain name or IP address: 3306, if the database server is connected via SSH, it needs to be logged through the Intermediate Remote Connection tool, The remote connection tool used here is putty, which needs to map the request domain name in the database's ssh->tunnel to the local 3306 port (general MySQL's request port is set to 3306, just meet the VW Flow ~ ~ ~), Then through the SSH server IP and the port to access, the specific configuration please refer to the following: 1. First, download and open putty, in the Putty configuration interface, category->session the address and port of the board, and then saved Sessions inside enter a name that you want to save, click "Save", you can save, the next time you open putty, directly select the session name has been saved, and then click "Load" will be loaded in the previous configuration.

2. Configure the Ssh->tunnels, because the SSH connection is bound to configure the corresponding SSH map channel, add new forwarded port, that is, the addition of the desired port, the port is arbitrarily defined, is not occupied on its own host port, Destination is the requested domain name (or IP address) + port (for example:uattest.test.mysql.com:3306) of the database server that needs to be accessed, because this is to be automatically mapped to the local port, so it is the default and auto, then click "Add", so it's OK. You can return to the session page and save it in case you lost it! ~ ~ ~

3.OK, so Putty is well, point open Bar, enter the session name and password, where the password is not displayed, only need to lose the doom can, lose enter. This is connected to the SSH server.

4. Open JMeter, now start to configure the JMeter, this is the main, the previous configuration is mainly for this Zhu ER service.

Add a test plan, user Configuration elements (I used to configure the environment parameters, so that's it ~ ~ ~), simple controller (this is also my habit, I am a very juicy person, do not like casually ~ ~ ~ haha), jdbc Connection Configuration and JDBC Request.

5.Ok, I simply say that the JDBC configuration, Variable name, the name must be consistent with your JDBC request, the other parameters slowly study it, we first default, then the database Connection configuration This piece, first database Url:jdbc:mysql://${jdbc}/mydb (this parameter is to configure which library to connect to the database, because we have mapped the database to be accessed locally, So the JDBC parameter here actually should be localhost:3306, this parameter I was configured in the user configuration element, so I just refer to it to make it easier to later modify the database access address for the other environment, then the JDBC Driver class: Com.mysql.jdbc.Driver (JMeter to be equipped with a JDBC jar package, placed in the Lib can find this drive, hehe, here is also unknown), input username and passwored. It's well-equipped ~ ~ ~

6. Then write the JDBC request, run it, over, and complete it.

The first time to write a blog, please give us a lot of advice, only for learning, not for others ~ ~ ~

JMeter connection Configuration MySQL server with a springboard (SSH)