Hello
I´m running a Wordpress on Azure (webapp + MySQL in App) and recently ran into an issue accessing the database. Due to the increased amount of traffic coming into the app had to scale out the application.
That said, the "MySQL in App" was replicated but not accessible and the App Settings where updated in the wrong way.
Troubleshooting:
Noticed that when accessing PHPMyAdmin I was getting two instances to choose. Therefore the app couldn´t stablish communication through the right database.
Solution:
Removed the application setting for MySQL which was causing this issue and that fixed the issue.
Is not advisable to scale out when you use MySQL in app. Instead you can use Azure DB for MySQL if want to scale out. There is an option to easily migrate from "MySQL in App" to "Azure Database for MySQL"
Next Steps:
Recommended documents for Azure DB for MySQL.
https://docs.microsoft.com/en-us/azure/mysql/quickstart-create-mysql-server-database-using-azure-por...
https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers
https://azure.microsoft.com/en-in/blog/scaling-out-read-workloads-in-azure-database-for-mysql/
