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

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

    We’ll send you updates on this idea

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

    50 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 →
  3. 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).

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

    24 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 →
  5. PowerShell Module

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

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

    We’ll send you updates on this idea

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

    22 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 →
  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?

    20 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 →
  8. 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 →
  9. 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?

    12 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 →
  10. 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 →
  11. 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…

    8 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 →
  12. 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!!

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

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. Allow editing of Character_set and Collation parameters

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

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Stop/start server

    Gaging interest for being able to stop a server when it is not being used and restart it when needed.

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

    We’ll send you updates on this idea

    planned  ·  1 comment  ·  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. Allow upgrading of the pricing tier

    It would be great if I could switch pricing tiers of Azure Database for MySQL Basic -> General Purpose -> Memory Optimized. I'd much prefer to start on a less expensive tier and as usage increases move to higher pricing tiers like other Azure services.

    4 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 →
  18. 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)

    3 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 →
  19. Manage access using Azure Active Directory

    It would be nice to be able to manage user access to MySQL resources using Azure Active Directory Groups / Users, similarly to the functionality provided for Ms SQL.

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

Azure Database for MySQL

Categories

Feedback and Knowledge Base