How to fix replication lag on Azure managed mysql db
I am facing Replication lag issue on one of my MySQL replication server while there is not much of CPU , ram or IOPS usage on replication server. Below are the details of the server and my production load. Master db:- 16 core 128 GB ram business…
Azure Mysql Flexi server Slow Logs diagnostic settings captures <10s
Hello, Good day! In Flexi server, I recently change long_query_time parameter from 1 to 10s, but still my diagnostic settings captures queries which is < 10s. Why and how to fix this? Below is the answer from Q&A Assist there could be a few…
Azure App service database problem
I want to transfer a wordpress webiste to Azure App service. I have run an App Service plan containing: Azure Database for MySQL flexible server and the App service. After that, I had moved all files of my website into the Azure FTP and I was able to…
100% CPU Usage in Azure Database for MySQL
I have a sudden increase of CPU Usage in my Azure Database for MySQL Flexible Server with Standard B1ms Compute SKU. The CPU usage spikes in the middle of the night. There was no increase in queries. No connection was possible to the Database Server when…
![](https://techprofile.blob.core.windows.net/images/jqcwpd5eDky7VgzR5lfXfA.png?8D8F92)
How to change Timezone to UTC+8(BJT) in Azure Database for MySQL ?
How to change Timezone to UTC+8(BJT) in Azure Database for MySQL ?
Error during install of Azure Database Migration Service worker
Hello community, I'm trying to use Azure Database Migration Service for MySQL (Hybrid mode), to migrate Onprem MySQL database to Azure Flexible MySQL Server. I carry out the following…
Debezium Connection Issues with MySQL SSL Enabled
The Debezium connector works well with SSL disabled, following the guide here. However, upon enabling SSL with the following configuration: "database.ssl": "true", "database.ssl.mode": "required", …
how to login to Azure Database for MySQL flexible server using aad user
i have created a Azure Database for MySQL flexible server and assigned a umi to it and assign access to mode is mysql and microsoft entra authentication. The microsoft entra admin group is able to login to MySQL flexible server using entra group name as…
Termination of Azure Service
Hello, Were planning to cut cost in our Azure Cloud Infrastructure and we noticed that we have Azure Database for MySQL flexible server that is not being used or the project for it, halted. We want the service be terminated and removed however we also…
reviewing "compute & storage" Azure Database for MySQL flexible server
Hello, Reviewing "compute & storage" section under Azure Database for MySQL flexible server, storage size is now x10 the size of the database and therefore de storage cost is now multiple by 10. I cannot identify the reasing for this…
WordPress Site on Azure: Database Connection Issue After Migration
I need some help with an issue I'm facing after migrating my WordPress site to Azure. Initially, everything worked fine after the migration, and the site was functioning using my migrated database credentials. However, after a few hours, I started…
decrease storage
Hello, I have checked the "storage" now is about 10x the size of the databases (we are not aware of the reason for this size, I have also checked that there is not a peak in the last month for storage), anyway, we have to reduce storage to the…
Issue with Low Memory Usage on Azure MySQL Database
I have been using Azure for hosting 5 systems/websites of my company for the past 4 years. Specifically, we have 5 Web App Services and 5 Azure Databases for MySQL. Currently, I am experiencing an issue with the memory usage of one of the MySQL…
Backup and Terminate Azure Database for MySQL
Hello. I would like to ask for help regarding our Azure Database for MySQL service. We are conducting a cost-saving process and found that one of our database is currently not in use by our system. Could you please provide the procedure for backing up…
Encrypt in Mysql Flexible server
I’m currently working on setting up Azure Flexible Server for MySQL for a production environment and need to ensure that both data-at-rest and data-in-transit are properly encrypted, in line with industry compliance requirements. I need help in the…
Back up an Azure Database for MySQL flexible server by using Azure Backup (preview)
We have not been able to create new backup vaults for MySQL flexible server for a while. The documentation has been updated with a note: The preview solution for protection of Azure Database for MySQL flexible servers by using Azure Backup is currently…
Azure MySQL Flexible version 8
I am investigating Azure DB MySQL Migration from on-prem to Azure and I am currently preparing some test scripts that can be run before and after. I have been following the Migration documentation, …
chmod isn’t working or unsure about permissions
I have an DigiCertGlobalRootCA.crt.pem (SSL Certificate) that's preventing my dynamic website from working because of the file permissions. I tried chmod 644 in bash to change the file permissions to no avail. Any idea how to go about doing this?
Automatic Backup in Mysql flrxible server
I am working with an Azure MySQL Flexible Server and would like to understand how to configure automatic backups and restore points effectively. I have read through the documentation but still have some questions. How can I configure automatic backups…
Why can't I connect to mysql database on azure from home computer?
I have a MYSQL database setup on azure. I have set the networking up for public access and opened it up for any IP to access (for testing). I can access it by logging into Azure without issue. I have a LAMP server running on my home computer. I…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)