MySQL in App: The server is not responding

Jean Carlos de Almeida 21 Reputation points
2022-08-18T14:49:24.067+00:00

I have an Application hosted in a Windows WebApp with MySQL in APP enabled.
After realize the aplication wasn't responding I could see in the logs errors about MySQL not responding.

So when I try to access the PHPMyAdmin from the console (clicking in the manage button) I got this error:
232440-image.png

I already tried to restart my application, and also stop/start but nothing works.
What can I do to solve this?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
709 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,030 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,773 questions
0 comments No comments
{count} votes

Accepted answer
  1. ajkuma 21,921 Reputation points Microsoft Employee
    2022-08-19T12:08:09.527+00:00

    @Jean Carlos de Almeida ,

    Just to clarify, were there any changes made prior to this issue? What App Service Plan (ASP) are you leveraging?

    As quick steps to isolate the issue:

    1. You may try to scale out to more instances to handle the socket load.
    2. You may try to scale up to a higher ASP tier
    3. If the Always On setting is off, please enable it from Azure Portal – Your WebApp > Configuration blade (> General settings).

    To fetch more details about the issue, you may try these:

    4.You may leverage App Service diagnostics from Azure Portal> Navigate to your App Service app in the Azure Portal. (screenshot below)

    -- In the left navigation, click on Diagnose and solve problems - Review - “Configuration and Management and “Availability and Performance” options.

    5.Navigate through Kudu site on: https://<sitename>.scm.azurewebsites.net/api/logs/ and review the log files + MySQL logs from D:\home\LogFiles\mysql folder

    App Service Diagnostics

    0 comments No comments

0 additional answers

Sort by: Most helpful