How to connect and query with MySQL server using Azure Machine Learning
Hi, I am currently working on a project where I need to connect to an Azure Database for MySQL using Azure Machine Learning (AML) and Python scripts. However, I want to use AML resources such as Datastore and Dataset for the connection rather than…
I can't select the b1s plan
Hi, I have an issue choosing compute size options. I saw there is a B1s plan in Burstable tier plan. but, I can't find the b1s. the minimum plan starts with B1ms. I tried changing the regions but still can find only b1ms not b1s. I'm using azure for…
Azure Data Factory pipeline is failing as i have migrated to Azure MySQL Flexi server from mySQL single server
I am using azure Data factory which has many pipelines. Pipeline pulls data from Oracle on-Prim data base using integration runtime and puts the data into Azure MySQL database. Initially the destination was a MySQL single server, now i have migrated to…
Default Value of sql_generate_invisible_primary_key in Azure MySQL Flexible Server
Why is the default value of the sql_generate_invisible_primary_key parameter set to ON in Azure Database for MySQL flexible server, and is this a bug? PS - Based on common issues that we have seen from customers and other sources, we are posting these…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Troubleshooting SQL Mode Issues When Upgrading to MySQL 8.0 on Azure
I encountered issues while upgrading my SQL database to MySQL 8.0 on Azure. How can I resolve the problem related to SQL modes? PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Migrate Azure Database for MariaDB servers
We received info about 'Azure Database for MariaDB is scheduled for retirement by September 19, 2025'. I have some questions about this. As info, We can just migrate from Azure Database for MariaDB to Azure Database for MySQL - Flexible Server, not…
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Why can't I create a MySQL server?
I have tried choosing different regions but the deployment keeps failing, and the error messages are all generic and unhelpful. It just says there is some kind of internal server error in the deployment's related event logs. An unexpected error occured…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Azure App Service slow performance when connected to MYSQL Database
I am hosting a PHP 8.2 on Linux Azure App Service (plan B2). My webapp name is fairytaleprod. The database is MySQL 8.0 running on Azure Database for MySQL flexible server(General Purpose, D2ads_v5, 2 vCores, 8 GiB RAM, 32 GiB storage). Both App Service…
Point In Time Restore fails
I'm trying to deploy an Azure Database for MySQL flexible server from Point In Time backup source and it always fails with "Conflict" status. I've tried different server sizes (more vCPUs) and different backup points (different hour/days) and…
How will Microsoft handle reports of "MySQL 8.0.38, 8.4.1 and 9.0.0 crashes on restart if database has 10K tables or more"
My team is currently using Azure Database for MySQL Flexible Server and I've seen recent posts from Percona that there is is an unstable fix release 8.0.38 which is only a few fix release levels from our current environment. See: …
in pass few days, all the metrics of Azure Database for MySQL flexible server is missing
Hi all, I have two running over two year Azure Database for MySQL flexible server, they are missing the metrics data since 5 days and 7days ago. All the metrics data is missing, I can not see any default monitoring metrics data, just like the CPU…
Azure MySql Database to power apps
Dear Azure Expert, I am new in Azure , I want to create table directly to Azure MySQL without using MySQL work bench, is it necessary? btw Im using powerapps I really want to migrate all my data from SP list to Azure, is there other way? Recommended…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Is Azure Support Always This Ineffective?
We've experienced an extremely frustrating situation with Azure Support and would like to know if others have faced similar issues. Here's a brief summary of our ordeal: 1. Production Downtime: On June 18th, we discovered that our CRM was down.…
MYSQL restore DB
while restoring my DB using MYSQL workbench it creates my_row_number on the tables with AI PK, I need to stop the auto creation since causing issues in my API. If I restore the DB locally works fine only while restoring it on azure
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
Major version upgrade to MySQL 8.0 from 5.7: Fails validation process with error "Usage of removed functions" but it doesn't show any detail on what functions are failing.
I am trying to upgrade my Azure MySQL from 5.7 to 8.0 version. I am following the current guide: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade The problem is that it doesn't specify which functions are failing or the…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
Azure Database Access from A Different Virtual Network
Dear Azure Team, I have an azure managed mysql database in virtual network vnet1 and a virtual machine in vnet2. I am unable to get this VM to access the database. I have a hub-spoke architecture with both vnet1 and vnet2 peered with my hub-vnet with…
Azure MySQL single server got auto migrated to flexible server
I have an Azure MySQL single server which got auto migrated to flexible server and currently in stopped state because of which I can't change any settings or can't access it from any client application, when opening in azure portal its showing message…
Azure mysql flexible server data-out Migration
'Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction ''ANONYMOUS'' at source log mysql-bin.000807, end_log_pos 34861197. See error log and/or…
create the dateid table in sql server
Hi , how to populate the dateid and date in dimtime table using script as below output upto 2029 excluding saturday and sunday create table table (dateid int,day varchar(23), dateid | day 20240601 | 2024 June 01 20290601 | 2029 June…
Connecting to MySQL Flexible Server in Azure suddenly failing
I have a MySQL instance in Azure which has run fine for about 2+ years. I have a Function App which inserts some data into on a monthly basis which has failed this month with the following error: Result: Failure Exception: InterfaceError: 2026 (HY000):…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)