0
This weekend we deployed an application based on the Magento framework, which has been thoroughly tested in various scenarios, with high load of users making various requests to the database, such as queries, updates and insertions, the entire course of the final customers was simulated.
In the tests the configurations were identical to those at the time of the deployment, the only difference was the subdomain, which we were using an homologation and then pointed to www, and to our surprise the application became totally unstable, presenting database errors, actually just a mistake:
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 simultaneous users shopping, and at deploy time we were with 20 users (according to Analytics).
The configuration of the below is:
- 2 Web Servers
- 1 File server
- RDS
- Server for Redis
The question is: How is it possible that in identical configuration cases the application behaved so differently? the subdomain has some influence on this?
Note: if you need more details, please request
Thank you
Subdomain does not influence. Use Docker? How do you know it is identical?
– Maniero
We don’t use Docker. I know it’s identical because we tested the project in the subdomain, with an infra X, which was composed of the items I mentioned in the question, at the time of release we simply pointed to it the www subdomain, you know? I forgot to mention that we have a haproxy for the load balance of webservers.
– Matheus Battisti
Really weird guy, I went through a similar situation once ( keep giving error 2006) To fix, I changed the variable mysql wait_timeout in my.cnf configuration file, if mysqld gets a package that is too big or incorrect, He assumes something went wrong with the client and closes the connection. To fix, also to increase the max limit of the max_allowed_packet package, for example, max_allowed_packet = 128M and restart MYSQL, the bizarre is that you have only pointed from the subdomain to the domain and it starts piping.
– Regis Marta