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 ?

39 votes
Sign in
(thinking…)
Sign in with: Microsoft
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…)
Sign in with: Microsoft
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