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. Ability to post-pone or choose when we can apply critical vs non-critical updates

    I believe the for production systems the application of maintenance that will IMPACT the users infrastructure should be an optional maintenance and not a requirement unless it is an extreme risk to not apply. That way we can choose when to apply some updates

    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 →
  2. Add server variable binlog_checksum to list of configurable server parameters

    Unable to change server variable binlog_checksum. Either allow SUPER privileges to admin login or make this parameter editable.

    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 →
  3. Make innodb_online_alter_log_max_size editable

    We make online DDL operation on large table:

    alter table tablewith900krecords drop column accountid_old, algorithm=INPLACE, LOCK=NONE

    This DDL working ~ 70min. Server is heavy used and another sessions change same table. If size of changes will above then default value of innodbonlinealterlogmaxsize = 134.217.728 (134Mb), operation will fail with error:
    Creating index 'PRIMARY' required more than 'innodb
    onlinealterlogmaxsize' bytes of modification log. Please try again.
    or
    ERROR 1799 (HY000): Creating index 'FTSDOCIDINDEX' required more than 'innodbonlinealterlogmaxsize' bytes of modification log. Please try again.

    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 →
  4. Ability to specify maintenance windows

    It would be nice if I could specify a half hour maintenance window per week where if Azure had maintenance to do on the database it would schedule it within that window. This feature is available on AWS.

    I am subscribed to the service health alerts for my mysql servers and didn't receive an alert for the January 9th maintenance. and when I look at the health events it only showed that the service was unavailible for that time, not that a maintenance occurred. If it had happened within my maintenance window, then I wouldn't be questioning if there was…

    4 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 →
  5. Identify the Azure Database for MySQL Proxy in the Initial Handshake

    When a client establishes a connection to Azure Database for MySQL, the connection is handled by a proxy server that sends the MySQL Initial Handshake packet. This packet just identifies the proxy's version as "5.6.42.0".

    Please add an Azure-specific identifier to this version string, e.g., "5.6.42.0-Azure", so that clients can accurately detect the existence of an Azure Database for MySQL proxy, then execute "SELECT VERSION();" to determine the real server version.

    Background: I author an ADO.NET MySQL connector library: https://github.com/mysql-net/MySqlConnector

    For diagnostic and feature detection reasons, I want to know if I've connected through an Azure Database for MySQL proxy…

    13 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 →
  6. 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

    51 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 →
  7. 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 →
  8. Ability to shrink storage when restoring

    We would like to shrink the allocated (max) storage when we restore a PaaS to create another environment. This would be especially interesting to create Test environments from Production environments with large unused storage (due to the provisioning of a big IOPS bandwith for performance).

    2 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 →
  9. Rename server

    Gaging interest for being able to rename a server/instance.

    For instance some customers shared that the naming convention they use for servers changes as a server moves from one stage of its lifecycle to another (test -> staging -> prod for instance)

    4 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 →
  10. Add services endpoints in Basic

    I have a cluster in AKS and I cannot connect it to a MySQL database unless I pay aprox 100€/month just for a single database for a very small app

    https://docs.microsoft.com/en-us/azure/mysql/concepts-data-access-and-security-vnet

    2 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 →
  11. We want to have functionality for Creating a replica of a replica from Azure side. And it should be fully manage by Azure.

    For replica of replica we want below support from Azure:


    1. Replication should be managed by Azure in this scenario, without losing managed capabilities. Thus, MySQL data-in replication doesn't suffice our requirements as in data-in replication Azure will not manage replication.

    2.We would have create new tables in our releases and we wouldn't like the replication to be broken due to the same.

    3 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 →
  12. Provide metric for utilized disk space

    Please provide a platform-level metric for disk space utilized by a DB instance. The Storage metrics provided by the MySQL service only show allocated file size from the perspective of the OS. But when I delete data in MySQL, the allocated file size never goes down. That means the Storage metrics only ever go up, not down. These metrics do not give me information about how much additional data a MySQL instance con store.

    Thanks!
    James

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

    2 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 →
  14. Allow option for MySQL semi synchronous replication

    For off load reads to a read replica it would useful to have semi synchronous replication enabled. This way the data being read from the read replica would be guaranteed to be the same as the master. With asynchronous the transactions could fall behind and off loaded reads may read stale data from the read replica.

    2 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 →
  15. 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?

    13 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 →
  16. Granularity of data replication

    Data Replication in Azure Database for MySQL service should offer the user to select which table(s) of which database(s) to replicate instead of replicating all tables of all databases all together.

    (Idea submitted by Jean-Yves Devant from the engineering group of Azure Database for MySQL service on behalf of one of our customers and in order to elicit feedback from other customers and users).

    4 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 →
  17. 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…

    11 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 →
  18. 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.

    57 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 →
  19. lower_case_table_name 0 support (Allow Case Sensitivity)

    Azure does not support MyISAM which is primarily the reason to now allow lowercasetable_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).

    30 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 →
  20. 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

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

Azure Database for MySQL

Categories

Feedback and Knowledge Base