question

ShubhiJain-5090 avatar image
0 Votes"
ShubhiJain-5090 asked OuryBa-MSFT commented

Data-in replication from local MySQL Server to Azure Database for MySQL

I am following the below link for setting up data-in replication from my on-premises MySQL Server to Azure Database for MySQL.
https://docs.microsoft.com/en-us/azure/mysql/howto-data-in-replication#create-an-azure-database-for-mysql-single-server-instance-to-use-as-a-replica

But in the last under Slave_IO_State I am getting connecting to master not 'yes'
all the previous steps has been accordingly.
Need help to debug it and how i can verify that replication has been set up

I have attached a picture showing the status of the slave .
98678-a1.jpg


azure-database-mysql
a1.jpg (58.2 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 @ShubhiJain-5090, Thank you for posting your question. We are looking into this and will get back shortly.
Regards,
Oury

0 Votes 0 ·

1 Answer

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

Hello @ShubhiJain-5090 This means that the replica cannot connect to the primary for some reasons. Could you check the column Last IO error for any messages?
The most common reason is the firewall settings of on-prem environment blocks the connecting request. Could you please help confirm if the primary can be accessed via public internet? The primary should allow the replica address to ensure connectivity. The document you provided above shows how to find the replica address.
Regards,
Oury

· 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 @ShubhiJain-5090 I just wanted to follow up with regards to the above answer I posted above. Do you have any further questions.?
Regards,
Oury

0 Votes 0 ·