Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
801 questions
2 answers
Is it possible to see or specify the mysql single server availability zone?
I have not found anything in the portal or the cli. If you create a read-replica in the same region, you obviously want it in a different zone than the master.
asked 2021-02-19T21:05:11.653+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 38%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
alex
106
Reputation points
commented 2021-03-05T22:58:20.803+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
1 answer
Handling large traffic spikes - Wordpress with Azure Database for MySQL server
In Azure Portal > Under [+ CREATE A RESOURCE], there is a pre-built 'WordPress' resource plan that will create: App Service Plan App Service Azure Database for MySQL server Our typical web traffic is 1,000 visitors/minute. However, we do see…
asked 2021-03-04T22:19:36.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 55.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Michael van Olden
6
Reputation points
commented 2021-03-05T13:37:40.983+00:00
Michael van Olden
6
Reputation points
1 answer
execute mysql script from azure automation powershell runbook
I have a mysql dump file (essentially a mysql sql script file) which i need to run against an azure mysql database How do I do this within a powershell script in an azure automation runbook? I've used azure cloud shell to do it before and the…
asked 2021-02-25T13:33:38.117+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 99%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Brian Melvin
1
Reputation point
commented 2021-03-04T08:28:45.613+00:00
Brian Melvin
1
Reputation point
1 answer
How to teach yourself MySQL database with zero Foundation?
How to teach yourself MySQL database with zero Foundation? There are two common MySQL structures: hash index and B + tree index. We use InnoDB engine, and the default is B + tree.
asked 2021-03-02T08:41:55.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 74%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E7%3C/text%3E%3C/svg%3E)
7fw07bd6crhb
1
Reputation point
answered 2021-03-03T01:34:35.08+00:00
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
1 answer
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
asked 2021-02-23T20:13:49.957+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 83%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Seeasoftware Eric PAPILLIER
1
Reputation point
commented 2021-02-26T10:53:52.797+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,606
Reputation points
1 answer
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…
asked 2021-02-19T21:25:23.227+00:00
alex
106
Reputation points
commented 2021-02-26T04:24:36.433+00:00
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
1 answer
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…
2 answers
One of the answers was accepted by the question author.
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?
1 answer
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
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?
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,451 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
801 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,818 questions
asked 2021-02-17T10:30:33.673+00:00
Marian Constantinescu
21
Reputation points
accepted 2021-02-19T09:59:24.243+00:00
Marian Constantinescu
21
Reputation points
1 answer
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…
asked 2021-02-18T12:17:47.567+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 67%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Shawn Mathew
41
Reputation points
answered 2021-02-18T12:50:55.05+00:00
Vaibhav Chaudhari
38,721
Reputation points
1 answer
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…
asked 2021-02-08T14:09:05.393+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
a8ree1
21
Reputation points
commented 2021-02-10T16:51:38.52+00:00
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
1 answer
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)…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
801 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,818 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,151 questions
asked 2021-01-12T05:17:15.153+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 54%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWZ%3C/text%3E%3C/svg%3E)
wint zarchi htun
6
Reputation points
answered 2021-02-04T10:32:39.293+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 99%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZL%3C/text%3E%3C/svg%3E)
Zlatko Lovcevic
26
Reputation points
1 answer
Moving between memory optimized tiers
Can I move between basic, standard tiers and memory optimized tiers?
asked 2020-05-18T02:39:47.493+00:00
Rohan Jones
291
Reputation points
commented 2021-02-01T23:10:16.737+00:00
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
1 answer
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()…
asked 2021-01-26T10:08:09.353+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 49%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gowda, Rahul (RIS-SYD)
1
Reputation point
commented 2021-02-01T22:54:40.94+00:00
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
4 answers
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…
asked 2020-12-30T06:06:26.507+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 23%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Blades'
1
Reputation point
commented 2021-02-01T11:46:02.577+00:00
prmanhas-MSFT
17,891
Reputation points Microsoft Employee
1 answer
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.
asked 2021-01-22T07:25:17.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 40%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEN%3C/text%3E%3C/svg%3E)
Eshwar Nakkala
106
Reputation points
commented 2021-01-28T09:05:40.073+00:00
Anurag Sharma
17,606
Reputation points
1 answer
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…
asked 2021-01-22T10:15:11.943+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 84%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Ozi
31
Reputation points
answered 2021-01-26T00:59:26.53+00:00
Navtej Singh Saini
4,226
Reputation points Microsoft Employee
1 answer
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…
asked 2021-01-20T17:54:28.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 57.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sarvesh Pandey
141
Reputation points
commented 2021-01-22T07:40:48.27+00:00
Anurag Sharma
17,606
Reputation points
1 answer
Problem installing demo content theme wordpress > MYSQL
Problem during demo content install. ![55755-image.png][2]
asked 2021-01-12T19:07:36.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 13%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MM
21
Reputation points
commented 2021-01-15T16:40:50.307+00:00
Grmacjon-MSFT
17,806
Reputation points