Do you have an idea or suggestion based on your experience with Azure Database for MySQL?

Mysql replication

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

37 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Daniel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Support for up to five read-only replicas within the same region is now in public preview. This feature is aimed to scale out read-heavy workloads.

Check out the documentation to learn more about replicas:
- Overview: docs.microsoft.com/en-us/azure/mysql/concep..
- How to create replicas from the portal: docs.microsoft.com/en-us/azure/mysql/howto-..

Azure CLI support will be following shortly.

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

11 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Akash Kava commented  ·   ·  Flag as inappropriate

    Read Replica isn't replication, it a Lock In, it prevents us from keeping replica outside Azure, not at all useful.

  • Krzysztof Chrapka commented  ·   ·  Flag as inappropriate

    Create read-only replica inside Azure, and use `mysqldump --dump-*****` to create your own replica outside of Azure! The replica inside Azure can be then discarded. However, every so often (when firewall access rules are changed) replicas get non-standard MySQL statements and stop. Those non-standard statements have to be skipped manually, so monitor your replicas.

    That, ofc, is unsupported, but so far has been working for us.

  • Paulo Diniz commented  ·   ·  Flag as inappropriate

    Are there any updates with regards to being able to connecting a read-only replica that's not an azure database for mysql

  • Andres Barcenas commented  ·   ·  Flag as inappropriate

    Hello,

    Based on the data-in replication documentation, is it possible to replicate from an Azure Hosted instance to another Azure Hosted instance? Looks like bin_log is disabled by default and the document mentions modifying the my.cnf and obviously we don't have access.

    -AB

  • Paulo Diniz commented  ·   ·  Flag as inappropriate

    Andrea is being able to setup data out replication, with the master being the azure vm and a replica being set somewhere else, not in the roadmap? Because I don't see how that works without the external db having access to the binlog.

  • Paulo Diniz commented  ·   ·  Flag as inappropriate

    Will this feature also allow us to connect to the binlog from inside the same network/region? Will we also be able to determine the replication type row/statement?

  • Anonymous commented  ·   ·  Flag as inappropriate

    AWS MySQL can use read replicas, but Azure is still under development. I want you to release the preview as soon as possible.

  • Olivier commented  ·   ·  Flag as inappropriate

    Does that mean we'll be able to do all those 3 scenarios:
    1 - be ***** of an "Azure Database for Mysql" instance
    2 - use "Azure Database for Mysql" as a master
    3 - use an "Azure Database for Mysql" as a Master of another "Azure Database for Mysql"? (1-2 combined)

    If so, this would be huge for us!

  • Hong Wang commented  ·   ·  Flag as inappropriate

    We are working on this now and will have it in the next few months. Follow us @AzureDBMySQL on Twitter for announcements of new features.

Feedback and Knowledge Base