We are planning to deploy ERPNext in AWS. It will be used by a user base of 100 . Concurrently 30 users might be using the system. Do we have any recommendation with respect to the type of AWS EC2 instance ( interms of vCPU and RAM) to handle this workload? Would love to hear the feedback on the current AWS Deployment configuration and their performance?
Hello. Welcome to the community! I currently have an instance running on AWS with 35 concurrent users. I currently use t2 medium with 2 processors and 8GB RAM. However, performance is determined by more than just your hardware. You have to fine-tune your setup such as mariadb config, nginx and other stuff to get the best performance out of ERPNext.
For my setup though the hardware works just fine as just tweaked my mariadb config a little. But as @bkm would say, “your mileage may vary”.
For my setup i ran mysqltuner and applied some of the recommended fixes. As my database knowledge is limited i skipped some of the recommendations as they were too complex for my understanding and didn’t want to break my production server. My instance runs well with the few tweaks i made as mysql queries respond faster but i presume you would want more than just a few tweaks so as to improve your e-commerce site performance.