I host my two MySql databases on Amazon RDS, which is db.m3.medium and db.r3.large having 5.6.27 innodb engine. Now I want to know, how many concurrent connections these instances can handle? How to load test it? What will be the impact if 1000 concurrent users access the databases?
Asked
Active
Viewed 1,300 times
1 Answers
0
It depends on many factors like MySQL servers configuration, data volumes, nature of requests, etc. The only way to tell it for sure is simulating your 1000 users with a load testing tool.
Few examples:
- Tsung -> MySQL
- Apache JMeter -> The Real Secret to Building a Database Test Plan With JMeter
- Grinder -> Grinding a database with JDBC
If you will be happy with the databases performance with 1000 users you can gradually increase the load to identify the breaking point
Dmitri T
- 159,985
- 5
- 83
- 133