Just the same way you do this for a single instance.

The main rule you should remember: well-behaved load test must represent
real-life application usage as close as possible. So if the MySQL cluster is
used by some external system and you want to conduct some performance
testing - you need to use the same configuration as that external system in
terms of  URL
<https://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html>  , 
connection pool <https://en.wikipedia.org/wiki/Connection_pool>  , etc. 

With regards to the URL itself you can specify the protocol like
*loadbalance* and include all your hosts there:


> jdbc:mysql:loadbalance://[host1][:port],[host2][:port][,[host3][:port]]...[/[database]][?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]

More information:

-  Building a Database Test Plan
<https://jmeter.apache.org/usermanual/build-db-test-plan.html>  
-   MySQL Database and JMeter - How to Test Your Connection
<https://www.blazemeter.com/blog/mysql-database-and-jmeter-how-to-test-your-connection>
  
-  Configuring Load Balancing with Connector/J
<https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html>
  





--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to