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.

  1. VNet integration

    It would be great if we can deploy database(mysql or postgresql) in our own virtual network.

    72 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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.

    59 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    25 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Mysql replication

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

    38 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Firewall missing allow azure services access

    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.

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

    We’ll send you updates on this idea

    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. When can we expect this service to move from Preview to Production ready?

    When can we expect this service to move from Preview to Production ready?

    18 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Ability to set up read-only replicas

    I'm creating this as a separate issue because from other replica requests because the different regions wouldn't be a major concern for us. We would just like to have the ability to create a read only replica, even if it was in the same region.

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Being able to use the time_zone table

    Most fully managed mysql solutions have some sort of workaround giving us access to the system timezones table. As it stands right now, azure does not. This makes it impossible to work with time zone based queries such as "America/LosAngeles". Using +7:00 just isn't feasible for a couple of reasons, the main one being that unfortunately daylight saving time is still a thing. I understand azure doesn't want to give users access to the system's table, but we need some kind of workaround for this.

    14 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →

    You can now populate the time zone tables on your Azure DB for MySQL servers using the “az_load_timezone” stored procedure. Documentation has been updated with how to populate the tables and set the time zone parameter at the global and session levels. Please see the documentation below:

    - Using the Azure portal: https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter
    - Using the Azure CLI: https://docs.microsoft.com/en-us/azure/mysql/howto-configure-server-parameters-using-cli#working-with-the-time-zone-parameter

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

  8. Server Parameters: innodb_buffer_pool_size, query_cache_limit, etc

    Possible to include these in server parameters?

    innodbbufferpoolsize
    query
    cachelimit
    query
    cachetype
    query
    cachesize
    join
    buffer_size

    Thank you.
    Ian

    14 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →

    The following server parameters are now configurable:
    - query_cache_limit
    - query_cache_type
    - query_cache_size
    - join_buffer_size

    Please refer to the following how to articles for how to configure the values from the Azure portal (https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters) or CLI (https://docs.microsoft.com/en-us/azure/mysql/howto-configure-server-parameters-using-cli).

    The innodb_buffer_pool_size parameter is tied to the SKU. Please refer to the following document for the values: https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#non-configurable-server-parameters

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

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

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. ARM Template for MySQL

    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.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. REST API

    Is there REST API for this service yet? I can't find it anywhere. Only portal and CLI.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Is it possible to expose the parameter innodbftmintokensize in server parameters

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

    We’ll send you updates on this idea

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

    waittimeout
    max
    connections
    tableopencache
    tmptablesize
    maxheaptable_size

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    All of the parameters requested are available to be changed in the service.

    Note that the maximum ceiling values of “max_connections”, “table_open_cache”, “tmp_table_size”, and “max_heap_table_size” increase as you scale up vCores.

    The parameters can be modified using the Azure portal (https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters) or 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

  14. Allow users to change the default_week_format server parameter in MySQL Database for Azure

    Currently threre are a few server settings that can be changed through the portal but defaultweekformat is not one of them. Since this is a globalization setting I find is very important to be able to change that to my local settings.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Reserved instances for MySQL

    Ability to purchase Reserved instances for MySQL similar to SQL or SQL MI.

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. Make possible to set "wait_timeout" to higher value

    Make possible to set "waittimeout" to higher value. Currently in Azure it is only possible to set "waittimeout" to 240 seconds where in standalone MySQL maximum value (on Windows machine) is 2147483 seconds. Default value in standalone MySQL is 28800 seconds (8 hours). It will simplified moving applications to Azure if it will be possible to set "wait_timeout" at lease to the MySQL default value.

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  17. move to another resource

    i want to move azure database for mysql to another resource that i managed in same subcription.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Customers can now move existing Azure Database for MySQL servers to either a new subscription or a new resource group in the same subscription. This functionality provides customers with the flexibility to manage their MySQL resources by using different resource groups and subscriptions. Learn more about how to move servers by using the:
    - Azure portal: https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources#use-portal
    - Azure CLI: https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources#use-azure-cli
    - REST API: https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources#use-rest-api

  18. Support Standard Pricing tier in East US and other regions

    Currently, only Basic pricing tier is supported in the portal which only provides 100 compute units. Enable Standard pricing tier in East US region, additional to all regions.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Private Link

    Please implement private link for MySQL connectivity

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Use ProxySQL with Azure database for MySQL

    Use of ProxySQL (https://proxysql.com/) allows for performance gains when working with MySQL database. However, the way MySQL is set-up in Azure, ProxySQL cannot be used. For complete details, please refer https://github.com/MicrosoftDocs/azure-docs/issues/36331

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Azure Database for MySQL

Categories

Feedback and Knowledge Base