Is there a way to create a replication ***** server with an on promise Mysql server ?
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.
Andrea Lam on behalf of the Azure Database for MySQL product team
Akash Kava commented
Read Replica isn't replication, it a Lock In, it prevents us from keeping replica outside Azure, not at all useful.
Krzysztof Chrapka commented
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.
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
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.
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.
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?
AWS MySQL can use read replicas, but Azure is still under development. I want you to release the preview as soon as possible.
Is there an update on this feature? We would like to be able to connect to the replication logs so that we can connect services such as https://github.com/nevill/zongji
Abhijeet Srivastava commented
Is it supported now to have master(on premise) to *****(Azure) replication for MySQL databases.
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
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.