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. 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).

    29 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 →
  2. 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.

    19 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 →
  3. 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: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow editing of Character_set and Collation parameters

    As of right now only character_set_server is editable. This means it is not possible to support full UTF8 (UTF8mb4 in MySQL).

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Please add an Azure Database for MySQL Contributor Rol

    There is a default rol for ClearDB and SQL but not yet for the two new database services.

    Please add them. Thanks!!

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

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Batch scheduler implementation

    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).

    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 →
  11. How to shrink ibdata1 file?

    Since Azure does not allow file-per-table enabling, and data will store in innodb table space(ibdata1). The fragmented pages of ibdata1 file cannot be released and will cause more storage utilization.
    We would like to have a feature where we can shrink ibdata1 file to release fragmented pages.

    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 →
  12. Allow master/master replication with on prem server with for channel

    Azure database for MySQL does not support master/master replication with on prem or other cloud database providers.

    This means we cannot use it in conjunction with an existing MYSQL.

    This should be available and you should be able to set the "for channel" option on the change master to statement in MYSQL.

    The fact that these are not available is a big oversight.

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Smaller tier for microsite implementation

    Provide a way to create smaller databases to act as backend of low-traffic sites or blogs.
    For example:
    1Gb max storage and 5 or 10 compute units for 1-2 $/month

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. Server Parameters: table_open_cache

    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?

    1 vote
    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 →
  • Don't see your idea?

Azure Database for MySQL

Categories

Feedback and Knowledge Base