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

Question

I am following the below link for setting up data-in replication from my on-premises MySQL Server to Azure Database for MySQL.
https://learn.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 .

Answer 1

Hello @Shubhi Jain 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