Azure SQL Database
An Azure relational database service.
5,550 questions
0 answers
how to fix connect timeout while copiying from mysql to azure sql using AZURE DATA FACTORY
I have this error while deploying the task of copiying 5 tables from mysql to azure sql on datafactory Operation on target ForEach_qx9 failed: Activity failed because an inner activity failed; Inner activity name: Copy_qx9, Error:…
asked 2024-08-20T10:06:29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Arturo Beltran
0
Reputation points
commented 2024-08-28T15:29:08.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NIKHILANETHIKUNTA
1,115
Reputation points Microsoft Vendor
0 answers
Has Azure database for MySQL changed its IO percentage counting?
We have Azure Database for MySQL flexible server service running as the database for a WordPress site. We have some periodic sync tasks that fetch data from our backend server using WP All Import and it saves the data to this MySQL database. We have also…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
0 answers
Azure MySQL event scheduler Issue
I'm using the Azure Database for MySQL service. After a maintenance event on Azure, MySQL restarted. After the restart, the event_scheduler was turned OFF, and the MySQL events we had registered are now in a "DISABLED ON SLAVE" state, which is…
asked 2024-08-27T06:21:10.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 85%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
정석 오
0
Reputation points
commented 2024-08-28T06:31:07.3066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,801
Reputation points
2 answers
Im losing Azure credits for using Azure MySQL database without exceeding the limits
Hi, I recently setup an Azure MySQL database and it said that it is free to use up to a certain amount like: compute: Free upto 750 hours storage: Free upto 32 GB And as u can see in the below image, my usage limit hasn't exceeded at all. But for some…
asked 2024-07-26T09:24:59.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 42%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Siddhesh Sreedar
45
Reputation points
commented 2024-08-28T05:38:28.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
0
Reputation points Microsoft Vendor
1 answer
Azure SQL Database vs Azure Database for MySQL
"I'm working on a project We're considering using either Azure SQL Database or Azure Database for MySQL for the relational data. I've noticed that Azure SQL Database tends to be more expensive. Can someone explain the main differences between Azure…
asked 2024-08-27T22:27:41.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 91%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Likitha Bommasani
0
Reputation points
edited an answer 2024-08-28T02:40:43.9966667+00:00
Alberto Morillo
33,526
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
restore azure mysql flexible server failed
I tried to restore my MySQL flexible server but it keep failed. The error message said: " { "status": "Failed", "error": { "code": "ProvisioningDisabled", "message":…
asked 2024-08-22T13:26:16.0966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 89%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZZ%3C/text%3E%3C/svg%3E)
Zhong Zhou
20
Reputation points
accepted 2024-08-27T18:55:53.45+00:00
Zhong Zhou
20
Reputation points
1 answer
Support of Group Replication for Flexible Server for Azure MySQL Database
Hey guys. Does Azure Database for MySQL - Flexible Server support a mechanism of "Group Replication" as described in the documentation - https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
asked 2024-08-23T19:45:12.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Andrej Weigandt
0
Reputation points
commented 2024-08-27T16:20:16.36+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
0 answers
Connection time out issue after selecting recommended drive option
Hi Team, Currently I can see below notification in Azure data factory portal. Your pipeline is currently utilizing legacy drivers. To avoid any unexpected behavior, please migrate to the latest driver version at your earliest convenience. Click I have…
asked 2024-08-27T09:48:32.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 9%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sharad Gawade
20
Reputation points
commented 2024-08-27T15:10:36.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
14,055
Reputation points Microsoft Vendor
0 answers
Registro de Auditoria Servidor Flexible MYSQL.
Servidor Flexible MYSQL dejo de almacenar registros en Cuenta de almacenamiento si causa aparente. cómo puedo solucionar esto?
asked 2024-08-20T21:41:19.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Miguel Angel Jimenez Gonzalez
0
Reputation points
commented 2024-08-23T17:38:51.58+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
0 answers
Azure Database for MySQL In-Place Auto Migration Failure: Migration timeout in step: wait until replication lag below threshold
Hi, We have scheduled an in-place auto migration for Azure Database for MySQL in order to migrate from a single server to a flexible server. It was scheduled to migrate on August 16th, 2024 (1:00 a.m. P.S.T.–8:00 a.m. P.S.T.). However, we got a…
asked 2024-08-19T17:57:46.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 99%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SKori
0
Reputation points
commented 2024-08-21T22:39:26.7366667+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
2 answers
ADF copy activity is failed due to the source side error
Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Divide by zero error…
asked 2022-12-22T12:11:15.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 64%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ramanjaneyulu, Maram Venkata
6
Reputation points
commented 2024-08-21T11:59:45.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anjali Ghosh
0
Reputation points Microsoft Employee
0 answers
MySQL Single Server auto-migration issue / status after EOL / cancelation of auto-migration
Hello, I've tried to set up the auto-migration of two Azure Databse for MySQL instances and provided the additional info (private DNS zone, VNet access, removal of locks) - faced the same issue as this Question:…
asked 2024-08-20T13:18:09.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 88%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Artur Kraus
0
Reputation points
commented 2024-08-21T08:54:10.9366667+00:00
Artur Kraus
0
Reputation points
1 answer
String Type does not handle special characters "(", ")", "&", "="
I am loading a csv file with fields Speciality and Webpage URL. Datatype for both of these is set to string Few Examples: Speciality Nephrology (NEP) Internal Medicine (IM) Nephrology (NEP) Dermatology (D) Webpage…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Internal Error trying to restore from backup mysql flexible server
Hello, I am experiencing an issue while attempting to restore a MySQL Flexible Server using the Azure web portal. The restoration process fails and I receive the following error message: { "status": "Failed", …
asked 2024-07-31T23:52:38.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 4%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Douglas Delefrati
20
Reputation points
accepted 2024-08-18T20:48:52.88+00:00
Douglas Delefrati
20
Reputation points
0 answers
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 45%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Deploying an Azure MySQL single server for testing and upgrading to Flexible
source: https://learn.microsoft.com/en-us/azure/mysql/migrate/whats-happening-to-mysql-single-server From the above link it is mentioned to reach out to raise an Azure Support ticket if there is a need for MySQL Single Server instance creation. We…
asked 2024-08-14T10:12:56.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 90%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESO%3C/text%3E%3C/svg%3E)
Stavros Orfanoudakis
20
Reputation points
commented 2024-08-14T12:35:34.24+00:00
Stavros Orfanoudakis
20
Reputation points
1 answer
Internal server error while creating azure mysql server
{ "status": "Failed", "error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…
asked 2024-07-31T16:14:29.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
Dev Ops
0
Reputation points
answered 2024-08-14T02:40:13.88+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive
9,426
Reputation points
0 answers
Azure mySql auto-migration from single to flexible server issue
I am attempting to select the Private DNS zone for a private link associated with a MySQL single server instance scheduled for auto-migration. When doing so, I received a green checkmark indicating that the private endpoint was ready to migrate. Upon…
asked 2024-08-12T16:31:28.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Josh Killion
0
Reputation points
commented 2024-08-13T22:21:54.06+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
1 answer
SSH Connection error - deploying a Django web app with MYSQL using the Azure portal
Hi, I am deploying a Django web app with MYSQL using the Azure portal, and all is well until I get to Run Django database migrations. When I try to connect to the SSH, it errors with "ssh://root@172.16.3.3:2222 SSH CONNECTION CLOSE - Error: connect…
asked 2024-08-06T10:20:31.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 19%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
YogeshMct
0
Reputation points
answered 2024-08-09T13:23:17.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SnehaAgrawal-MSFT
21,336
Reputation points
1 answer
MySQL Flexible Entra ID does not start after crash
When starting MySQL flexible after server crash (after memory leak), plugin aad_auth cannot start, because Function 'aad_auth' already exists. This leads to server to not be able to authorize connections using EntraID. There is need to reenable EntraID…
asked 2024-08-05T18:00:23.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jakub Adamus
0
Reputation points
answered 2024-08-08T06:10:37.8266667+00:00
ShaktiSingh-MSFT
14,801
Reputation points