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.
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…
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…
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.
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)