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…
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…
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 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…
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…
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…
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 | 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…
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 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…
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:…
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…
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…
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 | 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…
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…
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…
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
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 ??
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: …