This weekend we deployed an application based on the Magento framework, which was extensively tested in a number of scenarios, with a high user load making multiple database requests, such as queries, updates and insertions, the entire course of the final customers was simulated.
In the tests the settings were the same as the one at the time of deploy, the only difference was the subdomain, that we were using a homologation and then we pointed to the www, and to our surprise the application was totally unstable, database, actually just an error:
MySQL error 2006: mysql server has gone away
This error occurred in several tables, and in the test application did not occur once, with 50 concurrent users making purchases, and at the time of deployment we had 20 users (according to analytics).
The configuration of the infra is:
- 2 Web servers
- 1 File server
- RDS
- Redis Server
The question is: How is it possible that in identical configuration cases the application behaved so differently? does the subdomain have any influence on this?
Note: if you need more details, please request
Thank you