question

VincentTonney-8056 avatar image
0 Votes"
VincentTonney-8056 asked AnuragSharma-MSFT commented

How to setup Replication from Azure Database for MySQL to Google Cloud SQL

The requirement from business is to setup Replication from Azure Database for MySQL to Google Cloud SQL.
Is there a way to accomplish this if yes can anyout outline the steps?
I tried researching a lot but did not find anything related to external replication from Azure mySQL Database.

strong text

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.

Hi @VincentTonney-8056, just following up on this issue.

0 Votes 0 ·

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @VincentTonney-8056, welcome to Microsoft Q&A forum.

I am afraid there is no direct way to achieve this requirement. However, we can achieve this through below steps:

  1. Take the backup of Azure Database of MySQL to a Blob Storage

  2. Download the backup from Blob Storage to local machine

  3. Restore this backup on to the Google cloud

We might need to find a way to schedule all these steps for continuous replication.

Please let me know if this helps.


If answer helps, please mark it 'Accept Answer'


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.