Load Testing a Database Server
Microservices architectures are increasingly being used, which involves more and more databases being used as well.
Usually, databases are accessed through an API, and therefore, for a load test to be as realistic as possible, it is necessary to test the API, and not the database directly:
Figure 9.1: Microservices architecture versus monolithic architecture
However, it may be useful to test the database directly when:
- The API is not yet ready
- To compare JDBC drivers easily
- To tune database parameters
- To compare different databases
- To compare AWS RDS engine implementations (such as Aurora, Oracle, and SQL Server)
- To check the database configuration
- To check whether the cluster (as in, the VIP and load balancing strategy) is behaving well
- To test the database production server before going live without having an API server production-ready
- To do load testing on a database when a batch is...