question

YoniYahav-2844 avatar image
0 Votes"
YoniYahav-2844 asked YoniYahav-2844 answered

Hi is it possible to create a none managed mysql replication from an azure managed mysql server

Hi we have an azure managed Mysql database and a none managed mysql database i want to replicate both of them to a one none managed replication.
Is it possible to create a none managed mysql replication from an azure managed mysql server?
The replication is GTID.

azure-database-mysql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @YoniYahav-2844 Welcome to Microsoft Q&A and Thank you for posting your question. We are looking into this and will get back shortly.
Regard,
Oury

0 Votes 0 ·
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

Hello @YoniYahav-2844
If you wish to use GTID-based replication from the source server to the Azure Database for MySQL replica server, you'll need to enable the following server parameters on the Azure Database for MySQL server as shown in the portal image below:
94518-image.png
This document explains this with more details . Please let me know if that helps. Thanks



image.png (57.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @YoniYahav-2844 Please let us know if you have any further query
. --please don't forget to Accept as answer if the reply is helpful--

0 Votes 0 ·
YoniYahav-2844 avatar image
0 Votes"
YoniYahav-2844 answered

Hi @OuryBa-MSFT
Thanks for the answer but that is not exactly what i asked.
Anyway we decided to take a different path.
Thanks.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.