I would like to know if there's anyone in here having experience with google cloud SQL platform.
We are experimenting a very annoying issue which is very hard to troubleshoot.
Randomly, there's an "mysql server has gone away" popping out.
Our architecture is using Compute engines machine connected to a google cloud SQL database.
We don't have that many possibility to customize the my.cnf, since it's a managed service.
Here is a copy of the show variables: https://pastebin.com/Xaswtt72
I will add an example of an incident and the corresponding screenshot in New Relic
As you can see, the connect takes forever. While i checked in the cloud SQL plateform logs, the CPU was not charged at all (less than 10%), neither the RAM/network/I/O
We know that our code can be highly optimized, for sure, but still, we don't understand why with such a oversized architecture (10 front servers, database has 8vcpu and 30go of ram, and 500GO of SSD storage) we are experimenting those kind of issues, specially when our website is not loaded that much (less than 60RPM average).
Google support can't find anything. If one of you would have any kind of lead it would be already a big help.
Thanks in advance!