Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
615 questions
Content
0 answers
Azure Database for MySQL flexible server: How does manual backup limit really works and can we customize the automated backups time?
Hi everyone, I'm working with a non-profit organization using WordPress for a large website (over 6000 posts). I understand that the Azure backups work as follows: The database server backup occurs once a day. You can take up to 50 manual backups…
asked 2023-11-28T06:47:00.2666667+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(32, 27%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jeremie Litzler
0
Reputation points
asked 2023-11-28T06:47:00.2666667+00:00
Jeremie Litzler
0
Reputation points
1 answer
"Invalid source server id provided"Getting this error when restoring mysql database from recent deleted mysql database
Invalid source server id provided. The source server should be an existing server which belongs to same subscription and region as the target server
asked 2023-06-05T15:48:18.99+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(252.8, 24%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Popkornfintech Popkornfintech
0
Reputation points
commented 2023-11-28T01:35:34.0533333+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(182.40000000000003, 15%, 27%)' 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)
adminhotel
0
Reputation points
2 answers
Azure Mysql db Cost Problem
I got a 8.5 USD subscription. but now it shows a bill of 10.91 USD cost and the 18 USD forecasted value.How can I fix that?
asked 2023-11-21T09:20:21.9733333+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(262.40000000000003, 83%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Dushan Jalath
0
Reputation points
commented 2023-11-27T15:58:58.26+00:00
GeethaThatipatri-MSFT
23,612
Reputation points Microsoft Employee
1 answer
Connection between App Service (Web App) and MySQL Database
Hi everyone, The connection between our App Service (Web App) and Azure Database for MySQL has always been based on "Public Access", by whitelisting IP's on the Azure Database MySQL firewall. Recently, we disabled Public Access on the Azure…
![](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, 7.000000000000001%, 34%)' 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)
1 answer
One of the answers was accepted by the question author.
vcore's mean!
I wonder if vcore means real physical core. Does it mean the same as the CPU of the physical core 4 cores, 4 vcpu = 2 cores for AWS and 1 OCPU = 1 core for OCI? Is the 4vcpu of AWS and the 4 cores of Azure the same?
![](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(304, 85%, 39%)' 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)
1 answer
Error during database migration: Need to increase the max_allowed_packet limit
Context: Currently, our team has decided to use Azure Database for MySQL to migrate the database service from a VPS server and subsequently automate all processes in Azure applications. However, we believe that our project doesn't require more than the…
asked 2023-11-17T23:45:20.9833333+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(64, 15%, 16%)' 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 Aguayo
0
Reputation points
answered 2023-11-20T10:06:31.6366667+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
10,986
Reputation points Microsoft Employee
0 answers
Azure MySQL Replication Lag Issues
I have two Azure Database for MySQL single servers running in our Azure cloud, these are accessed from a number of virtual machines running Ubuntu (code base is mostly PHP), also within the same cloud. The virtual machines use ProxySQL to access the two…
asked 2023-11-15T10:14:08.1133333+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(35.2, 61%, 13%)' 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)
Andrew Bolton
5
Reputation points
commented 2023-11-15T15:45:36.42+00:00
Andrew Bolton
5
Reputation points
0 answers
How to populate a MySQL database with email logs from Exchange Microsoft O365 logs?
I have a MySQL database in Azure. I'd like to add some tables such as EmailOutreach with some columns such as: EmailUniqueID | Sender | To Recipients (comma delimit) [or may be one row per each recipient] | DeliveryStatus [bounced, etc.] |…
asked 2023-11-14T17:09:16.53+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(54.400000000000006, 6%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ5%3C/text%3E%3C/svg%3E)
Joad-5499
0
Reputation points
edited the question 2023-11-15T01:13:42.05+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(246.4, 22%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
Kael Yao-MSFT
33,541
Reputation points Microsoft Vendor
2 answers
Integration between Asana and Microsoft SQL Servers using Microsoft Azure DevOps?
Hi, I work for a bespoke kitchen company. We currently are using SQL Servers (on-premise). A lot of our software is integrated whereby any data input onto one system, would update on our other systems. We have recently started using Asana which is not…
asked 2023-11-14T10:33:06.87+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(89.60000000000001, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
William Ko
0
Reputation points
answered 2023-11-14T15:26:27.0533333+00:00
William Ko
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Cant turn of enforce_gtid_consistency and gtid_mode on Azure Database for MySQL flexible server - Server Parameters
Getting below error when try to set Server Parameters for enforce_gtid_consistency, gtid_mode. tried both at the same time and also one at a time but all the time its failed. Error message/details: [ { 'code': 'Conflict', …
asked 2022-05-31T17:19:17.84+00:00
HitenBhavsar-MSFT
381
Reputation points Microsoft Employee
edited the question 2023-11-14T14:06:00.69+00:00
GeethaThatipatri-MSFT
23,612
Reputation points Microsoft Employee
1 answer
Is the backup cycle of Azure MySQL Flexible Server's binary logs real-time?
Hi. I checked this page. - https://learn.microsoft.com/ko-kr/azure/mysql/single-server/concepts-backup For a single server, the transaction log (bin log) was backed up every 5 minutes. However, According to the contents of this page, it is possible to…
asked 2023-04-24T06:52:57.95+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, 78%, 31%)' 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)
안예리
41
Reputation points
commented 2023-11-14T02:29:29.6666667+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(313.6, 35%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nathan Chen
0
Reputation points
1 answer
How to connect to the azure mysql flexible server using dbforge with SSL connection?
I have downloaded the cert on the azure portal and tried to connect using dbforge. But showing the error, anyone experience?
asked 2023-11-08T02:15:59.46+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, 32%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Khristian Dave Poleracio
0
Reputation points
commented 2023-11-13T14:26:28.7633333+00:00
GeethaThatipatri-MSFT
23,612
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Does Azure Database for MySQL Server keep transaction log backups? Where can they be checked?
Good morning to everyone, I would like to have some answer on a doubt that I cannot solve using Microsoft documentation, which I have read at those…
asked 2023-11-10T12:02:51.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(211.20000000000002, 82%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Michele
20
Reputation points
edited a comment 2023-11-10T17:47:36.4+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' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
5,506
Reputation points Microsoft Employee
2 answers
Resource missing in portal. However the resource is there and accessible
Very strange issue- My resources in VSE subscription were paused when the billing usage met the limit. When the new billing cycle began, resources became accessible again. However Azure database for mySQL resource is missing in portal. But I am still…
asked 2023-11-08T19:44:53.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(108.80000000000001, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Martin Kallukalam
0
Reputation points
answered 2023-11-10T15:45:19.9466667+00:00
Rahul Randive
5,506
Reputation points Microsoft Employee
1 answer
Cost anomaly mySQL 76% Memory, "Paid IO LRS IO Rate Operations" at $20/m for inactive (dev) wordpress website
For a Wordpress website in development almost inactive, the cost of the Azure Database MySQL is at IOPS CA$20/month, and it says the CPU at 7% but Memory constantly at 74% , and the bulk of the cost comes from "Paid IO LRS IO Rate…
asked 2023-10-30T09:49:55.7133333+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(217.60000000000002, 64%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Christopher Mary
0
Reputation points
commented 2023-11-09T19:57:25.9933333+00:00
GeethaThatipatri-MSFT
23,612
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Connecting to MySQL using Managed Identity in Azure Function
Hi I am trying to use a managed identity to read&write a mysql from an Azure function (pytho http trigger). I created a User Managed Identity from the portal by going to my MySQL db -> Authentication -> Select Identity -> Create. I named it…
![](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(89.60000000000001, 5%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
3 answers
Mysql flexible server : how to set parameter who is not present ?
Hello, I created a mysql flexible server. I want to set the server parameter "optimizer_switch" to "prefer_ordering_index=off". But this parameter is not present in the azure portal. When I connect directly to the database and set…
asked 2023-06-09T08:01:53.7233333+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(3.2, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
Thibault LE RESTE
0
Reputation points
commented 2023-11-09T17:42:20.4233333+00:00
GeethaThatipatri-MSFT
23,612
Reputation points Microsoft Employee
2 answers
To Microsoft Support Team, I hope you can assist me with a concerning issue. My Azure account has been disabled due to suspicious activity. How can I resolve this and reactivate my account? Your help is greatly appreciated. Thank you,
To Microsoft Support Team, I hope you can assist me with a concerning issue. My Azure account has been disabled due to suspicious activity. How can I resolve this and reactivate my account? Your help is greatly appreciated. Thank you,
asked 2023-11-01T19:25:46.5833333+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(249.60000000000002, 75%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
ASIM ALLI
0
Reputation points
commented 2023-11-09T17:33:04.2633333+00:00
Rahul Randive
5,506
Reputation points Microsoft Employee
1 answer
How to connect to the azure mysql flexible server using dbforge with SSL connection?
Hi everyone, I have downloaded the certificate from the azure portal and renamed in to baltimore... but it is showing cannot load private key. Is anyone here using dbforge with ssl connection in azure mysql - flexible server? Thank you
asked 2023-11-08T02:14:41.72+00:00
Khristian Dave Poleracio
0
Reputation points
answered 2023-11-08T14:57:09.09+00:00
GeethaThatipatri-MSFT
23,612
Reputation points Microsoft Employee
2 answers
How can I get column names from a table in SQL Server?
I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?
asked 2023-11-04T07:00:34.4766667+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(208, 13%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
nora devids
0
Reputation points
commented 2023-11-07T15:34:11.1133333+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(35.2, 21%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Boris Von Dahle
2,661
Reputation points