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.

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

    We’ll send you updates on this idea

    10 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. 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 →
  3. 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 →
  4. 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 →
  5. 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.

    29 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 →
  6. PowerShell Module

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

    24 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 →

    Hi all,

    The Azure PowerShell product team is looking for customers who are willing to try some of the newest Azure PowerShell features for Azure Database for MySQL and provide feedback.

    If you are interested in talking with Azure PowerShell product team on this topic, fill out this short survey (https://microsoft.qualtrics.com/jfe/form/SV_0PATZ9XFWS8S82V?Q_CHL=twitter) and include your email at the end. We will contact you to set up a Teams call if you are a good fit for this study.

    Thank you!
    Andrea Lam on behalf of the Azure DB for MySQL team

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

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

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

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

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

Azure Database for MySQL

Categories

Feedback and Knowledge Base