762 questions with Azure Database for MySQL tags

Sort by: Updated
1 answer

Database Firewall Settings

I am attempting to configure MySql firewall for container instances. I have successfully parsed the output from the CLI to get the new public ip address of the container instance, however, it does not seem to use that ip address to connect to the…

Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
672 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-09-23T15:48:23.31+00:00
kevin 1 Reputation point
commented 2020-09-28T18:05:47.123+00:00
Mike Ubezzi 2,776 Reputation points
1 answer

Alternate solution for select ... into outfile in Azure database for MySQL?

We have a requirement, capture query output to output file like as below in Azure MySQL. The below query is possible in on-prem MySQL server. But we need the same in cloud PAAS solution or alternative method to achieve it SELECT COUNT(*) FROM…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-09-14T16:54:06.003+00:00
Kishore Chilaparapu 1 Reputation point
commented 2020-09-17T04:55:49.827+00:00
Mike Ubezzi 2,776 Reputation points
0 answers

Data in replication to Azure Mysql is not working

Today I've tried to setup data in replication from dedicated Mysql 5.7 (Percona xtradb 5.7) server in to "Azure Database for MySQL server" Completed all steps in the guide:…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-09-08T10:09:20.897+00:00
Pavel G 1 Reputation point
commented 2020-09-14T17:30:20.367+00:00
Navtej Singh Saini 4,221 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure CLI command to enable Advanced Threat Protection and Data encryption in MySQL servers

I am trying to enable "Advanced Threat Protection" and "Data encryption" features for MySQL databases. I found the tutorials for enabling the features in the Azure portal, but I didn't find any documentations for Azure CLI. According…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-09-04T18:52:04.363+00:00
Haolan Ye 21 Reputation points
accepted 2020-09-08T17:26:44.58+00:00
Haolan Ye 21 Reputation points
0 answers

Can I use log4jdbc?

spring.datasource.driverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy I couldn't use this. I am using azure mysql. I tried to print a log using log4jdbc, but the database connection is not possible. Can I use log4jdbc other than the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-08-26T11:13:27.017+00:00
seunghee cho 1 Reputation point
commented 2020-09-02T01:15:42.02+00:00
Navtej Singh Saini 4,221 Reputation points Microsoft Employee
1 answer

What tools can I use to identify the cause of high CPU utilization on Azure Database for MySQL

I have an instance of Azure Database for MySQL server which the azure portal reports has a fairly constant 35% CPU utilization. I've tried running show processlist; to see if there is a query running that might explain the CPU usage, but it's all…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-08-26T18:06:32.6+00:00
Bjorn Hansen 1 Reputation point
answered 2020-09-01T03:46:28.243+00:00
Mike Ubezzi 2,776 Reputation points
1 answer

unable to connect local db in linked service in data factory

make sure the SQL Database firewall allows the integration runtime to access. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,128 questions
asked 2020-08-26T09:20:51.777+00:00
JasperJoshua 1 Reputation point
commented 2020-08-28T06:02:37.163+00:00
Mike Ubezzi 2,776 Reputation points
2 answers One of the answers was accepted by the question author.

Azure Database for MySQL | Recovery time objective guarantees with GRS backup replication

This question is loosely related with a previous question which was about RPO while this is about RTO. We want to understand if there are any RTO guarantees when we use the GRS backup of Azure Database for MySQL to restore in a secondary region. Let…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-08-21T03:07:08.177+00:00
Sayan Ghosh 316 Reputation points Microsoft Employee
commented 2020-08-27T05:27:45.507+00:00
Sayan Ghosh 316 Reputation points Microsoft Employee
0 answers

What is taking up so much backup storage

My database size is ~100GB, but when I check the backup storage used it shows 1TB. The backup retention policy is on the lowest value possible. Is Azure really storing 10 copies of the database or is something else going on I'm not understanding? Thanks.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-08-14T15:47:20.063+00:00
Adrian Guzman 1 Reputation point
commented 2020-08-18T16:44:20.403+00:00
Navtej Singh Saini 4,221 Reputation points Microsoft Employee
5 answers One of the answers was accepted by the question author.

Azure Container Instance failing to connect to Azure DB for MySQL Instance

I have spun up an ACI based off a custom image hosting a strapi application, that uses the mysql js client to interface with the DB. When accessing the Azure DB for MySQL instance via a local MySQL client or a local docker container, the connection to…

Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
672 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-20T11:36:39.34+00:00
Naomi Beckford 21 Reputation points
accepted 2020-07-21T18:31:14.387+00:00
Naomi Beckford 21 Reputation points
2 answers One of the answers was accepted by the question author.

All my apps on Azure App Service on Linux suddenly began to have error on start up

Beginning June 27(UTC), All my apps on Azure App Service on Linux began to fail to start up due to the following error. /tmp/bundle/gems/bootsnap-1.4.5/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:22:in `require': libmariadbclient.so.18:…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,356 questions
asked 2020-06-29T16:59:19.117+00:00
y.y 96 Reputation points
accepted 2020-07-20T11:27:33.983+00:00
y.y 96 Reputation points
1 answer

Unknown Host when connecting to MySQL Azure from Azure VM in PHP

I have an Azure Windows Server 2016 VM and a database hosted in MySQL Azure. I have the connection information from the Azure portal, and can connect to the database from MySQL workbench on the VM, as well as through powershell. However, I'm struggling…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-07T07:36:41.26+00:00
Alistair Henderson 1 Reputation point
answered 2020-07-16T07:48:00.043+00:00
Alistair Henderson 1 Reputation point
2 answers

Can not perform requested operation on nested resource. Parent resource not found

Hi, When I tried to use az SQL import, I'm getting the following error, what might be the cause and solution for this? I went through this https://learn.microsoft.com/en-us/azure/azure-resource-manager/templates/error-parent-resource but…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
754 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-15T06:14:50.94+00:00
pragadeesh.raju 41 Reputation points
commented 2020-07-16T06:47:04.923+00:00
Anurag Sharma 17,586 Reputation points
1 answer

Saving MS form attachment in sharepoint using power automate

I'd like to save MS form attachment in sharepoint by using power automate. I created the flow as below. Now there is one issues in apply to each in part of add the attachment. I get the error message as below. The error message as below: The…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-13T06:19:25.653+00:00
Piyanan 1 Reputation point
answered 2020-07-13T06:29:12.517+00:00
Leon Laude 85,721 Reputation points
2 answers One of the answers was accepted by the question author.

Azure Database for MySQL | Fail-back to primary region

Let us say we have a general purpose Azure Database for MySQL instance in a primary region (lets say AU East) with geo-replication set up on backups and the region went down went down. This resulted a customer executing their fail over process, which…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-07T06:28:13.053+00:00
Sayan Ghosh 316 Reputation points Microsoft Employee
commented 2020-07-09T02:04:57.447+00:00
Mike Ubezzi 2,776 Reputation points
1 answer

It's possible create a MASTER/Replica from Azure Database for MySQL server to MySQL on-premise?

Hello My main database is in an Azure database for MySQL server and I want it to be my MASTER and I want my on-premise base to be a REPLICA Master : Azure database for MySQL (principal database) Replica: Database On-Premise Centos (replica…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-06-26T02:35:43.443+00:00
Ligarius 21 Reputation points
commented 2020-07-08T22:12:34.71+00:00
Mike Ubezzi 2,776 Reputation points
1 answer

How to increase pricing tier or server performance in MySQL Azure server?

I had created a mysql server with basic pricing tier of 2vCores and 10GB Storage to use it for hosting a wordpress site. But seems that the server is too slow with a loading time of more than 10 secs everytime i open a page in my. Wordpress. I can't…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-07T12:18:48.923+00:00
ROSHAN SHRIVASTAVA 1 Reputation point
answered 2020-07-07T12:36:03.703+00:00
Vaibhav Chaudhari 38,681 Reputation points
1 answer One of the answers was accepted by the question author.

Set up Incremental Refresh in power BI

I am trying to use Incremental refresh in Power BI, bu I have these message "Before you can set up incremental refresh on this table you need to set up parameters". But the parameters was already set up before using incremental refresh

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-07-03T14:26:05.82+00:00
Ricardo Grijalva 21 Reputation points
accepted 2020-07-07T00:14:38.227+00:00
Ricardo Grijalva 21 Reputation points
1 answer

End of suppoet for Azure DB for mysql 5.6

May I know the mysql 5.6 end of support date of Azure DB for mysql ??

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-06-22T02:24:59.65+00:00
Cheung, Kai Fung 1 Reputation point
answered 2020-07-01T01:25:13.563+00:00
Mike Ubezzi 2,776 Reputation points
2 answers

How do we utilize INFILE with Azure Database for MySQL?

Hello, we're using Azure Database for MySQL and would like to utilize LOAD DATA INFILE. Based on the documentation here, a current limitation is that Azure Storage must be mounted and a UNC path should be specified in the query. We have two questions: …

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
762 questions
asked 2020-06-23T21:17:02.217+00:00
Steve Sanda 1 Reputation point
commented 2020-06-27T01:33:10.067+00:00
Mike Ubezzi 2,776 Reputation points