Per Microsoft's post here: https://docs.microsoft.com/en-us/azure/virtual-machines/linux/classic/optimize-mysql, please consider adding some of the server parameters suggested in the post as configurable options. In particular, innodb_flush_log_at_trx_commit, to improve performance and varying workloads.1 vote
Using straight out of the box Drupal installation and the Azure Database for MySQL, Query times are regualrly 1 second or more.
Check out the last column in the screenshot.1 vote
Server Parameters: wait_timeout, max_connections, table_open_cache, tmp_table_size, max_heap_table_size
Is it possible to expose the following parameters or are they restricted by the SKU chosen?
Access database recovery / backup configuration in Azure Portal similar to configuring a recovery services vault and retention policy for Azure SQL databases.
Currently I cannot find any UI in the portal that would allow me to configure automatic backups.3 votes
Tried deploying GLPI (http://glpi-project.org/) using Azure Database for MySQL but failed during Database creation for 'lack of permissions'. Using a ClearDB database it worked inmediately. Checking the servers configuration, ClearDB user had all mysql roles, but Azure Database user didn't have some roles.1 vote
Is there a way to create a replication ***** server with an on promise Mysql server ?10 votes
I would like to change the parameter of 'table_open_cache' of MySQL.
Although I changed the SKU, this parameter would not be changed.
Do you have any plan to change the parameter conforming with SKU?2 votes
Can you explain more the scenario you have that requires you to have access to and change beyond our default of 2000?
When can we expect this service to move from Preview to Production ready?5 votes
I'm looking for documentation on creating an ARM template for the Azure Database for MySQL service. It would be nice to be able to create the templates so we can version control the service along with the rest of our system.3 votes
The server security settings are missing the allow azure services option, as im having to manually enter in ip addresses that my web apps and the cloud shell uses.13 votes
Possible to include these in server parameters?
There is a default rol for ClearDB and SQL but not yet for the two new database services.
Please add them. Thanks!!2 votes
For enterprise companies, business continuity and disaster recovery are one of the most important features. We cannot stop our services even when the region failure happens.23 votes
We are working on this now and will have it in the next few months. Follow us @AzureDBMySQL on Twitter for announcements of new features.
It would be great if we can deploy database(mysql or postgresql) in our own virtual network.29 votes
We are currently looking into how we can improve support to avoid having to expose a public facing IP endpoint. We’ll post information as we get closer to plans here @AzureDBMySQL on Twitter.
Currently I use a crontab job on my Azure Linux server to run overnight batch sql processes but obviously not having access to the O/S this is impossible when used as a PaaS, so could you implement a scheduler system to allow running of sql jobs/stored procedures? (Something like SQL Agent in SQL Server would be even more flexible).2 votes
- Don't see your idea?