search

codecentric / gatling-jdbc

JDBC support for Gatling
Apache License 2.0
23 stars 18 forks source link

Unable to create more than 8 connections to MySQL database #11

Open sparcit opened 4 years ago

sparcit commented 4 years ago

Hi,

I am trying to send through enough load through to our RDS mysql database using jdbc-gatling but I am unable to get to more than 4 connections from a Macbook pro and not more than 8 connections from a Windows 7 machine. Regardless of the number of concurrent users I spawn these are all the connections I can get to

Here below I set the connectionpoolsettings to go upto 200. But it has not helped

val settings = ConnectionPoolSettings(initialSize = 100, maxSize = 200)
 val jdbcConfig = jdbc.url("jdbc:mysql://blah-blah-blah")
    .username(dbusername)  // TODO Change this to perpetual or on demand Authorization
    .password(dbpassword)
    .driver("com.mysql.cj.jdbc.Driver")
    .connectionPoolSettings(settings)
    .build

I am using the following versions of the various dependencies I am using

     <gatling.version>3.3.1</gatling.version>
      <scala-maven-plugin.version>3.3.1</scala-maven-plugin.version>
     <gatling-maven-plugin.version>3.0.5</gatling-maven-plugin.version>
      <jdbc-gatling.version>2.3.0</jdbc-gatling.version>
      <mysql-connector.version>8.0.15</mysql-connector.version>
pshingavi commented 3 years ago

@sparcit was this resolved ? Did you manage to get it working ?

sparcit commented 3 years ago

No. unfortunately not.

So I had to switch to Jmeter to complete my testing.

Be good to know if you do manage to work out a solution.