Azure Database for MySQL

We would love to hear it! Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Database for MySQL customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Database for MySQL engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.
Remember that this site is only for feature suggestions and ideas! If you have technical questions please try our documentation, MSDN forum or StackOverflow.

Do you have an idea or suggestion based on your experience with Azure Database for MySQL?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Active Geo-Replication (like SQL Database)

    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.

    92 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Cross-region read replicas are now available in public preview. You can create up to five read-only replicas in any region supported by the MySQL service.

    To get started, please use the Azure portal to select the location for your read replica: https://docs.microsoft.com/en-us/azure/mysql/howto-read-replicas-portal#create-a-read-replica

    Thanks,
    Andrea Lam on behalf of the Azure DB for MySQL team

  2. Mysql replication

    Is there a way to create a replication ***** server with an on promise Mysql server ?

    37 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Support for up to five read-only replicas within the same region is now in public preview. This feature is aimed to scale out read-heavy workloads.

    Check out the documentation to learn more about replicas:
    - Overview: docs.microsoft.com/en-us/azure/mysql/concep..
    - How to create replicas from the portal: docs.microsoft.com/en-us/azure/mysql/howto-..

    Azure CLI support will be following shortly.

    Thanks,
    Andrea Lam on behalf of the Azure Database for MySQL product team

  3. MySQL release version 8.x

    Version 8.x is the next stable release of MySQL and we would like to stay on Azure but we do need a better performing database with more JSON support.
    MariaDB latest stable would also be good enough.

    26 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. lower_case_table_name 0 support (Allow Case Sensitivity)

    Azure does not support MyISAM which is primarily the reason to now allow lower_case_table_name=0 on windows platforms. There is no reason to not allow this as an option for users. It hurts possible migrations to force table design to lower case. Please allow this to be set to something other than 1 and 2 (2 has no effect for innodb).

    24 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. allow access to mysql binary log

    allow access to mysql binary log in order to:
    - enable CDC tools (like elastic - https://medium.com/@siddontang/how-to-sync-your-mysql-data-to-elasticsearch-ddae009243c1) to use it and having advanced caching capabilities based on DB data changes
    - send binary data to kafka to further analysis logic

    20 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. PowerShell Module

    Would be great to have a PowerShell module to manage MySQL servers and DB.

    19 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Audit MySQL Database

    Do we have any option like server-level or database level Auditing in MySQL in Azure?
    Also is Azure following any security baseline for MySQL databases?

    16 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Access database recovery / backup configuration in Azure Portal

    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.

    15 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Server Parameters: innodb_buffer_pool_size, query_cache_limit, etc

    Possible to include these in server parameters?

    innodb_buffer_pool_size
    query_cache_limit
    query_cache_type
    query_cache_size
    join_buffer_size

    Thank you.
    Ian

    13 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow database restore individually

    It would be great if you could add an option to restore each database in the MySQL server individually and provide a way to shedule database backups (created with mysqldump for example) and save them inside a storage account container.

    12 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback.

    The Azure DB for MySQL service is managed at the server level, so restoring at the database level is not something we are planning to support.

    Backups are taken automatically by the service. If you want to store them in a storage account, you set up a script to do a MySQL dump and store them in Azure Storage.

  11. Extend backup retention periode to more than 35 days

    Currently you can maximum select 35 days for backup retention period, which means Azure will only store backups for 35 days. This is a very short time, and it would be nice to have a way longer period, say 1, 2 or even 5 years.

    11 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. High availability

    Azure Database for MySQL should be highly available, it is not currently.

    assume that most databases are required to be online 100% of the time - currently Azure Database for MySQL is restarted at Microsoft's will to perform updates.

    There is no failover feature so these updates cause the DB to go offline.

    This should not happen.

    11 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. More flexible pricing

    The current pricing tiers have a big jump between the Basic tier and the start of the General Purpose tiers. The current pricing does not compare at all favourably to simply just spinning up a linux virtual machine and running MySQL.

    Could we have a General Purpose tier priced a bit lower with only one vCore?

    10 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Upload ssl certificates

    I would like to upload my own self signed ca certificate, server certificate and server key to configure SSL encryption for MySQL connections

    9 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Single alias for all db server login names that can work for all master and replica servers

    Currently db server login user name format is dbuser@servername, and thus we end up having different server login names for different master and replica servers (ie, myuser@master, myuser@replica1, myuser@replica2,....).
    This format can be big trouble in using popular read replica load balancing solutions like HA Proxy / SQL Proxy that uses single login user across all MySQL servers, or MySQL router (another load balancing solution) that doesn't support '***@***' format for its login user.

    we can leverage these popular MySQL load balancing solutions above If Azure Database for MySQL can support single alias for all db server login names that…

    7 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Server Parameters: Expose parameter innodb_ft_min_token_size

    Is it possible to expose the parameter innodb_ft_min_token_size in server parameters

    6 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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?

    wait_timeout
    max_connections
    table_open_cache
    tmp_table_size
    max_heap_table_size

    6 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    wait_timeout and table_open_cache are now available to be changed in the service.

    To learn how to change the parameter values, view the docs:
    - Using the Azure portal: https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters
    - Using the Azure CLI: https://docs.microsoft.com/en-us/azure/mysql/howto-configure-server-parameters-using-cli

    Thanks,
    Andrea Lam on behalf of the Azure Database for MySQL product team

  18. Azure MySQL Server encryption with Key Vault

    Are you planning to encrypt the Azure MySQL database with Key Vault?
    ..similar to the Azure SQL database.

    5 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow setting change of innodb_flush_log_at_trx_commit

    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.

    5 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Please make MySQL backups available for restore after deletion of the ressource

    I have an idea of ​​improvement for the MySQL service (as a service managed by Azure).

    Several services can make backups managed by the portal, but it seems to me that many of them, like MySQL as a service (managed by Azure), do not allow restore the backup after the removal of the resource.

    Example:


    Source: https://docs.microsoft.com/en-us/azure/mysql/concepts-backup

    In an ideal world (where unicorns exist), I could restore a resource that was deleted by mistake.
    Fortunately, such a suppression has not arrived in our team, but the law of murphy wants it will happen someday.

    We are currently implementing secondary backups…

    4 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Azure Database for MySQL

Feedback and Knowledge Base