Re: High concurrency for master and high reading from slave slowing down insert

[Frwa Onto]

Hi Peter,
No in normal instance when you say huge ram is 48Gb consider big enough or need more ? How many insert can mysql support per second or per minute?

What I plan to do for the Java Api is to break it into multiple server e.g. one server will host 5000 devices but at the back end it will be just one db server. Any idea on how to test the Java Api and I am planning to use Hikari CP as the connection pooling solution.

Any idea how to simulate around 30K insert. The problem I know bulk insert is faster in my scenario they are all different insert concurrently cause each device will connect send data and close the connection for both socket n db. So there is no room for me to do the bulk inserts. Maybe you may have other work arounds on this?