MySQL Azure Basic registration
How can I upgrade an existing MySQL Azure instance. Currently, I am using the basic registration. I'd like to use a powerfull connections number version. Thanks
How do you force a mysql flexible failover for testing purposes?
How an app recovers from a mysql server failure and a fail-over needs to be checked, you can't just assume it will be fine. So there needs to be a way to force it. How? There's a note in the docs In case of the compute scaling operation, we…
mysql flexible server deployment (via portal) either hangs or fails
The first attempt spent 17 hours in the "Accepted" state before being cancelled. The third attempt failed with this: { "code": "DeploymentFailed", "message": "At least one resource deployment operation…
If a whole zone failure takes out a mysql single server, will you still have access to backups?
I am assuming that a single server can't auto recover from a whole zone failure, since that's a feature of flexible? Is that correct? But after such a failure, will backups be available? Are backups zone redundant?
ClearDB MySQL - Is it possible to recover an old database?
Some time ago, I used a ClearDB MySQL Database (wordpress) in my webapp at Azure. It was a important website for me, and I spent a lot of time developing it. Unfortunately, I didn't migrate to Azure (MySQL in app), despite some warnings that the service…
Login & Register app .net and mysql
I have a long homework to build a web app with register & login form using .net and MySQL and I need start guidance. Do you know any sources?
![](https://techprofile.blob.core.windows.net/images/Qj94itYrS0mlcJoJFE4_2g.png?8D8C1E)
![](https://techprofile.blob.core.windows.net/images/Qj94itYrS0mlcJoJFE4_2g.png?8D8C1E)
MS Azure connector in Informatica
The source connection selected for the Synchronization task has no associated object. Select a different source connection. I am getting this error when trying to create a task in informatica and using my Azure data lake storage v2 connection…
![](https://techprofile.blob.core.windows.net/images/83b87d0ad6664b86a2c2018eab8da26a.png)
How can I automate a CSV import to Azure MySQL?
I cannot seem to find a way in which to import a CSV file to Azure MySQL from a command line. I've tried using LOAD DATA LOCAL but even with the csv on a storage account with the drive mapped, it won't work Error 2068 (HY000): Load Data Local Infile…
A connection was successfully established with the server. But then an error occurred during the pre-login handshake.(provider: TCP Provider, error: 0- The semaphore timeout period has expired)
Hello Senior!!, Now I facing this error("A connection was successfully established with the server. But then an error occurred during the pre-login handshake.(provider: TCP Provider, error: 0- The semaphore timeout period has expired)…
Moving between memory optimized tiers
Can I move between basic, standard tiers and memory optimized tiers?
![](https://techprofile.blob.core.windows.net/images/ff1de53188ff498baf36ab3f9757e218.png)
azure mysql database replication with on-prem mysql master is failing with 2003 error
I have setup azure mysql master database and I would like to do data-in replication with an on-prem mysql database but the replication is failing. Can someone tell me the reason ? azure mysql - mysql> SELECT VERSION(); +------------+ | VERSION()…
Created inbound rule on NSG to allow traffic, no traffic is able to go thought
Current I have a Ubuntu Server running a MySQL database (VM is not only hosting a MySQL database) I created a rule in the NSG to allow traffic to port 3306, but traffic seems to still get blocked when traffic is coming from the internet. For…
![](https://techprofile.blob.core.windows.net/images/yp1iz6RkYkCu5wtHlxsMTQ.png?8D82CB)
Copy incremental data from azure cloud to on premises sql database
Hi, I have a requirement in Azure. Actually we have a table (tb1) in azure cloud database and it need to copy that table in my on premises database with incremental data. can anyone help me how to achieve this Regards, Eshwar.
Azure SQL Server and Azure MySQL migration options to AWS :(
Dare I say it in this forum....we are moving a client's managed Azure SQL Server database (3.8TB) and multiple smaller Azure MySQL databases to AWS RDS SQL Server and Aurora MySQL respectively with minimal downtime permitted (max 2 hours). DMS is…
MySQL restore command
The standard MySQL restore command is - sudo mysql -u username -p password database_name < backup_file.sql But I have to use below command to restore mysql backup file - Use Databasename source backup_file_path.sql I don't understand why i have to…
Problem installing demo content theme wordpress > MYSQL
Problem during demo content install. ![55755-image.png][2]
![](https://techprofile.blob.core.windows.net/images/a2dbb28782bd4a3d9013b3ee9f354ec6.png)
Azure mysql flexible server questions
1.about the zone redundancy architecture . , so we can build HA between zones.. May I know the HA within the same zone will still exist together?? or user can only choose either way to perform HA in flexible server ? there is a concept of…
Azure database for MySQL vs Azure SQL database
Hello, I am new to azure. Currently, I am learning azure from Microsoft learn using the link https://video2.skills-academy.com/en-us/learn/modules/azure-database-fundamentals/azure-mysql-database. Does anyone know the main difference between…
Azure mysql backup schedule
https://video2.skills-academy.com/en-us/azure/mysql/concepts-backup is it possible to decide WHEN (WHAT TIME) to take full backup and differential backup during the day ?
Set values for parameters not available under Server Parameters
I need to set the values for below two parameters: innodb_log_buffer_size = 32M innodb_log_file_size = 256M However, I don't see them under Server Parameters. How can I set values for these two parameters?