Hi Team,
A couple of months ago, we migrated our MySQL cluster from version 5.7 to 8.0. We are using a PHP application as the web server and have started noticing that some connections do not occur from the application to MySQL. Our setup includes a master-master 3-node cluster with HAProxy in front to handle requests.
We did not encounter any issues when using version 5.7, and there are no errors in the MySQL logs related to “too many connections” or similar issues.
Could you please help us diagnose this problem? Let me know if any further information is needed.
Hi @Harish_m.r,
Your application should be generating error logs when connections to MySQL fail, along with a reason/code. If not, add such logging to your PHP code. You should also be looking at HAProxy’s logs. Increase log verbosity in HAProxy if you don’t see anything. Ensure MySQL’s log_verbosity is == 3. Please provide all such logs here.
Thank you for providing the suggestion. We are trying to add some logs on the application side. If that does not help, we will let you know the configurations in our cluster, along with the logs.
Hi @Harish_m.r ,
As Matthew mentioned, you need to look at HAProxy logs as well for the connection issues. However, collecting logs at the application end is also a good start.
Regards,
Vinodh Guruji