This is a canonical question about capacity planning for databases.
Related:
I'm looking to create a canonical question of tools and methods of capacity planning for databases. This is intended to be a canonical question.
Obviously, the general workflow is:
- Put your scenario in place
- Add monitoring
- Add traffic
- Evaluate results
- Remediate based on results
- Rinse, repeat until reasonably happy
Please feel free to describe different tools and techniques for different web-servers, frameworks, etc., as well as best-practices.