In-place upgrade of MySQL Single Server to a Flexible Server
Hello, I have some questions related to in-place upgrade of MySQL server to a MySQL Flexible server. Server Name Retention: During the in-place upgrade of our MySQL Single Server to a Flexible Server, will the Flexible Server retain the same name as the…
Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB
Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López
Azure Database Migration Service deployment failure issue
Good morning, I am trying to deploy the Azure Database Migration Service resource from the portal, so that I can migrate a SQL database in IaaS to PaaS, but the deployment is still failing for the central France region, and I am fine. Resource…
Azure MySQL Flexible crashing with Max Active Connections
Hello, I'm using WordPress on the App Service and whenever I reach ~54 active connections, the CPU starts to increase reaching 100% usage and the application becomes unavailable. The App Service plan does not have high consumption. WebApp = PremiumV3…
MySQL flexible server CPU credits suddenly consumed?
Hello, My Azure MySQL flexible server is configured with burstable tier. It was configured as B1ms, and a few days ago I switched to B1s. After the change, almost all CPU credits suddenly dissapeared and a few days later the server became…
Scheduled Migration Maintenance from Single to Flexible MySQL Server (5.7 to 8.0)
Hello, as many Microsoft customer I received the mail about the scheduled migration from Single to Flexible MySQL Server. Does the migration from a Single 5.7 do also the upgrade to MySQL 8.0 ? Best regards Roberto
Active connections when database not open to public access
I have an Azure MySQL database which is currently running a high daily cost just in IO operations, even on days when I'm not using the database. I'm trying to cut costs and I noticed that I have an average of 100 select queries being run every 5 minutes…
I have a single server databases for MySQL Flexible Server located in the North Central US region only.
I have a single server databases for MySQL Flexible Server located in the North Central US region only and today I had this error indicates that the operation was canceled before it could be completed. The error stack trace points to a JavaScript file…
How to fix "An error has occurred. The target schema is in an unknown state" on Windows PC (VS Professional 2022)?
Hello there, i tried to compare and update schema few months ago. But i performed the wrong action. I set the source and target in the opposite way and updated. after that i also incorrectly performed a Post Deployment script which is not required.…
How to stop sql_generate_invisible_primary_key generation when migrating Access database to Azure MySQL
After import of Access table to Azure MySQL instance database, an invisible primary key is automatically generated. 'SHOW VARIABLES LIKE "sql_generate_invisible_primary_key";' shows 'ON'. Trying to 'SET GLOBAL sql_generate_invisible_primary_key…
What are different ways I can host my Oracle database in Azure managed by Azure?
What are different ways I can host my Oracle database in Azure managed by Azure?
Azure MySQL Database for Flexible Server System Tables Corrupted
I have maintained a Azure mySQL database for Flexible server for over a year. It works fine until yesterday. When I try to connect using mySQL Workbench, it can connect to the server but it cannot fetch any tables / views / SP / Functions information. I…
Wordpress on Azure App Service : Database Error - Error Establishing a database connection [Azure Marketplace deployment]
Hi! I have deployed a Wordpress site onto the Azure App Service using the Azure Marketplace plugin called Wordpress on App Service by Microsoft. It deployed the following resources onto my resource group: The problem is, although the web app is up and…
Can't access a database after trying to delete it.
I created a database in Azure database for MySQL, flexible server. The database was used and a couple of tables in it have thousands of records. I want to drop the database, but I keep having a timeout. I then went to Azure portal to delete the database…
How do I fix "InternalServerError" while deploying Azure Database for MySQL Flexible Server?
There seems to be a bug with deploying Azure Database for MySQL Flexible Server. If there are no available Skus in the region I want to deploy to, I get a deployment error with status "Conflict", error code "InternalServerError" and…
How to specify a local timezone on an Azure SQL server?
I have a SQL server on Azure, and I would like to adjust the timezone setting to reflect my local time, which is UTC+8. The current getdate() function shows results in UTC. Is there a way to change the timezone setting to my local time? I am aware of the…
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…
Getting Internal error while migrating single server to flex mysql server
Getting InternalServerError while running a flex server migration in poc env az mysql flexible-server import create --data-source-type 'mysql_single' --data-source 'server' --resource-group 'poc-infra-rg' --name 'flexserv-01' --key…
Can't connect to Azure MySQL flexible server
I'm getting the following error in MySQL workbench when trying to connect to my server I cant connect from my program either. When I logged into the Azure portal, a message popped up saying I have used up all my SKU credits despite not having done…
SQL Server Migration Assistant for MySQL download page 404s
Hi, I was trying to download the SQL Server Migration Assistant for MySQL tool, but the link to download the latest version of the tool leads to a 404 page. See https://aka.ms/ssmaformysql, and this page was last updated in mid-late 2023 and has no…