Deleted table restore
Is it possible to recover the deleted table in azure database ? if yes please tell me how ?
Using REPLICATE_REWRITE_DB in Azure MySQL database
Database names in my Master and Replica server are different. Master DB name - uas-tms-20211111 Slave DB name - uas-tms-uat To get the replication working in this scenario, we use REPLICATE_REWRITE_DB option in on-prem MySQL servers. …
Unable to create an Azure MySQL flexible server
I am receiving an error message when trying to create a new Azure MySQL flexible server database in the Southeast Asia region. The error states that "Subscription <name> is not allowed to provision in Southeast Asia." I already have one…
Is there any transactional SQL for creating firewall rule using sp_set_firewall_rule in Azure MI
Hi Team, Can you please let us know, is there any transactional SQL for creating firewall rules using sp_set_firewall_rule in Azure Managed Instance? Thanks, Abhishek Modi
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):…
What's going on with the flexible mysql database ?
Hello, For several days now, I've been experiencing completely unexplained cpu load peaks on my flexible mysql server (B1MS). No metrics, no maintenance, no increase in requests or connections are to blame at this time. As proof, I've disconnected my…
I am using the Student version of Microsoft azure. Can I create Data lake and Data warehouse with this version?
I am student in CIT , Coimbatore.I want to explore the concepts of Data warehouse so I choosed Microsoft azure student version.Can I create warehouse in this version if not please suggest another platforms to create effective warehouses for free.
Increasing usage of MySQL server
Hello, When I go to the Top free services by usage section in Subscriptions>Overview, I notice continuous increasing in the "Azure Database for MySQL, Flexible Server Storage, Data Stored" usage. It is increasing daily although i stopped…
PowerBI Service connection fails to Azure Database for MySQL flexible server
Hello, I created a semantic model connected to my Azure Database for MySQL flexible server. It refreshes successfully from powerbi desktop, but once the dashboard is published, it does not refresh anymore. The error I am getting is: …
Private link / VNet integration between App Service and MySQL Database
Hello, Between an App Service and an Azure Database for MySQL I created a Private Link with VNet integration, so that the Database for MySQL is only reachable through the App Service and not through the public internet. When looking at the App…
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…
Issues deleting Azure MySQL flexible server with “Updating” status
My Azure MySQL flexible server is unresponsive and shows “Updating” status, which started a day ago. It has been running for 10 months without issues. The server stopped responding with the message “Attention: MySQL Flexible Server Burstable SKU…
Azure Database for MySQl Flexible - High CPU - No increase in workload
I have an Azure Web App that is connected to an Azure Database for MySQL Flexible server. This web app is a small data collection form that stores the collected values to a table which are later collected via am API in the web app. A cron job executes…
Azure MySQL Flexible Server Extremely Slow
I have a database server (MySQL Flexible) and it was working fine, but the last few days it has become very slow. There were no changes in the application, the code of application did not change. In the information_schema.processlist there are no active…
Which Database should I use for a moble app?
Which Database should I use for a moble app?. Specifically, I would also like a step-by-step tutorial for setting up this database. Since bing is a Microsoft product I thought I would give your AI co-pilot a try and ask him for advice. That might not…
Connection timeouts connecting to Azure Database for MySql Flexible Server (with apparently no resource exhaustion)
We have an ASP .Net 8 Web API hosted on Azure App Service (Windows). It connects to an Azure Database for MySql Flexible Server v5.7, using Pomelo.EntityFrameworkCore.MySql 8.0.2. We are not using Private Access/VNet. It is a multi-tenant application,…
Api Connection Timeouts intermitted using Azure App Service with a Mysql Flexible Server
We have had intermittent connection timeouts on our App Service when doing an http requests.
100% CPU on Empty MySQL Instance
Hello, I recently setup an Azure mySQL Database. It is type Standard_B1s (small yes). I have not created any databases at all. The only thing in there is the default database mySQL comes with. There are no users, no-one connecting to it. Looking at…
Azure Role Based Access Control (RBAC)-what role to assign to outside engineer to help build App Service Laravel app including MySQL Flexible DB
I need to grant temporary access to an outside developer/engineer to access a new Azure App Service Laravel App including MySQL Flexible Database server so they can help set it up, configure it (environment variables, SSH nginx scripts, etc.). They…