AdminAzure Database for MySQL Product Team
(Product Owner, Microsoft Azure)
My feedback
-
2 votesneed-feedback ·
AdminAzure Database for MySQL Product Team (Product Owner, Microsoft Azure) responded
Hi Juan Carlos,
This server parameter is exposed, but if you have a read replica, we block updating this parameter as it may cause data corruption. If you need to update it, please delete your replica, update the parameter, and recreate your replica server. (ref: https://docs.microsoft.com/en-us/azure/mysql/concepts-read-replicas#server-parameters).
Thanks,
Andrea Lam
(on behalf of the Azure DB for MySQL team) -
33 votesunder review ·
AdminAzure Database for MySQL Product Team (Product Owner, Microsoft Azure) responded
The lower_case_table_name parameter requires a server restart to apply. Recommended workaround until we can enable server restart is to scale up/down the vCores on a server. Apologies for this workaround. We’re looking for ways to improve this experience.
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL teamAn error occurred while saving the comment -
9 votes
An error occurred while saving the comment Can you please clarify what you mean by contributor role? Are you specifically looking for role-based access control? (ref: https://docs.microsoft.com/en-us/azure/role-based-access-control/overview)
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team -
6 votesneed-feedback ·
AdminAzure Database for MySQL Product Team (Product Owner, Microsoft Azure) responded
The “collation_server” parameter is currently exposed in the Azure portal. Can you please specify which collate parameters you’re interested in seeing in the portal?
Thanks,
Andrea Lam on behalf Azure DB for MySQL teamAn error occurred while saving the comment Thanks for the feedback. We are currently looking at what types of parameters and collations our service can support.
-
25 votes
Hi all,
PowerShell support is now in preview with the Az.MySql module. You can get started by installing the module using the following command: Install-Module -Name Az.MySql -AllowPrerelease
Check out some more docs about PowerShell support here:
- Quickstart create server: https://docs.microsoft.com/en-us/azure/mysql/quickstart-create-mysql-server-database-using-azure-powershell
- Restore: https://docs.microsoft.com/en-us/azure/mysql/howto-restore-server-powershell
- Update parameters: https://docs.microsoft.com/en-us/azure/mysql/howto-configure-server-parameters-using-powershell
- Create replicas: https://docs.microsoft.com/en-us/azure/mysql/howto-read-replicas-powershell
- Restart server: https://docs.microsoft.com/en-us/azure/mysql/howto-restart-server-powershellThanks,
Andrea Lam on behalf of the Azure DB for MySQL teamAn error occurred while saving the comment @Ben Fisher, would using ARM via PowerShell to update firewall rules fulfill this requirement?
An error occurred while saving the comment Thanks for the feedback. We currently have management APIs available through Azure CLI. Is there something particular you'd want in PowerShell? Otherwise, you can use ARM via PowerShell to help manage your servers.
-
3 votes
An error occurred while saving the comment Just wanted to confirm that the ask is similar to the phpmyadmin extension that you can enable for Azure App Service.
Ex: https://sunithamk.wordpress.com/2016/01/04/how-to-use-phpmyadmin-for-your-azure-web-app/
-
5 votes
An error occurred while saving the comment You may want to try Azure Database for MySQL managed service. Please see more details, including pricing, here: https://aka.ms/AzureMySQL
Azure Database for MySQL team
-
6 votes
An error occurred while saving the comment You may want to try Azure Database for MySQL managed service. Please see more details, including pricing, here: https://aka.ms/AzureMySQL
Azure Database for MySQL team
-
7 votes
An error occurred while saving the comment We suggest you try Azure Database for MySQL managed service. Please see more details, including pricing, here: https://aka.ms/AzureMySQL
Note that currently service is in Public Preview and pricing is 50% of full pricing at GA (general availability of the service) that is expected in Q1 2018.
Azure Database for MySQL team
-
60 votes
An error occurred while saving the comment We suggest you try Azure Database for MySQL managed service. Please see more details, including pricing, here: https://aka.ms/AzureMySQL
Note that currently service is in Public Preview and pricing is 50% of full pricing at GA (general availability of the service) that is expected in Q1 2018.
Azure Database for MySQL team
Can you expand why this would be a blocker for migrations? The service does support the value 2, which stores the table and DB names in the lettercase specified during create.
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team