AdminAzure Database for MySQL Product Team
(Admin, Microsoft Azure)
My feedback
-
24 votes
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 team -
2 votes
Hi Muhammad,
Can you confirm if you're using one of the published WordPress templates in the Azure Marketplace?
- WordPress on Windows: https://portal.azure.com/#create/WordPress.WordPress
- WordPress on Linux: https://portal.azure.com/#create/WordPress.WordPressonlinuxWould you also be able to let us know what database size you're using?
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team -
10 votes
We introduced integration with Azure Monitor Diagnostic Logs that allows the MySQL slow query logs to be piped to Log Analytics, Event Hubs, and Azure Storage.
You can view more docs about how to set up Diagnostic Logs here: https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-overview-of-diagnostic-logs#how-to-enable-collection-of-diagnostic-logs
Information about the log schema can be found here: https://docs.microsoft.com/en-us/azure/mysql/concepts-server-logs#diagnostic-logs
-
23 votes
Thanks for the feedback. We are planning to support MySQL 8.0 and will provide an update when it’s available to use.
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL teamWe’re working on the support for MySQL 8. The ETA for this has shifted out early 2019.
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL teamApologies for the delay. We are looking to support MySQL 8.x by the end of this calendar year 2018.
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team -
1 vote
Thanks for the feedback. Can you provide more information about the data that is output by the sensors? Is the data structured? How large could the raw data get?
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team -
1 vote
Would creating users from a GUI like MySQL Workbench be helpful for this? MySQL Workbench provides a "Users & Roles" view in which you can create new users with specific roles.
Thanks,
Andrea Lam on behalf of the Azure DB for MySQL team -
4 votes
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 -
2 votes
Thanks for the feedback. We are currently looking at what types of parameters and collations our service can support.
-
1 vote
Thanks for the feedback! Can you clarify if using MySQL Workbench or another tool to import data into the MySQL service addresses this need?
-
1 vote
We are currently working publishing some updated ARM templates in our sample GitHub repository to show how to change the parameter values from ARM. In the meantime, you can do something like the below:
“resources”: [
{
“type”: “configurations”,
“name”: “div_precision_increment”,
“apiVersion”: “2017-12-01″,
“location”: “centralus”,
“properties”: {
“value”: “6″,
“source”: “user-override”
}
}
]You can set MySQL server parameters through ARM templates using a command like the following. Replace “div_precision_increment” with your parameter of choice and update the value of the “value” parameter.
“resources”: [
{
“type”: “configurations”,
“name”: “div_precision_increment”,
“apiVersion”: “2017-12-01″,
“location”: “centralus”,
“properties”: {
“value”: “6″,
“source”: “user-override”
}
}
] -
19 votes
@Ben Fisher, would using ARM via PowerShell to update firewall rules fulfill this requirement?
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.
-
4 votes
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/
-
15 votes
Sean, are you looking specifically for long-term retention? Otherwise, as mentioned previously, the service itself takes automatic backups.
Backup configuration is automatic through the platform itself so no configuration is necessary. Full backups are daily with up to 5 minute snapshots throughout the day.
-
5 votes
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
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
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
-
25 votes
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
-
1 vote
For microsites like you are suggesting, we recommend that you use the MySQL In-App functionality of Azure App Services, which is free.
-
13 votes
To further iterate on Hong's response below, in order to deliver a consistent experience (performance) for different SKUs, we don't expose these parameters. Doing so may compromise the amount of memory available for other resources at the infrastructure-level.
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