Data in replication to Azure Mysql is not working

Pavel G 1 Reputation point
2020-09-08T10:09:20.897+00:00

Today I've tried to setup data in replication from dedicated Mysql 5.7 (Percona xtradb 5.7) server in to "Azure Database for MySQL server"

Completed all steps in the guide: https://learn.microsoft.com/en-us/azure/mysql/howto-data-in-replication
Verified requirements & limitations are Ok: https://learn.microsoft.com/en-us/azure/mysql/concepts-data-in-replication#limitations-and-considerations

Finally "show slave status" query executed in Azure MySQL server returns:
Slave_IO_State: Waiting for master to send event
Slave_IO_Running: Yes
Slave_SQL_Running: yes
Seconds_Behind_Master: 0
Slave_SQL_Running_State: 'Slave has read all relay log; waiting for more updates'
Last_Error: ''

From this query perspective replication works well, however data changes made on master in "testdatabase" are not synced to Azure Mysql replica.

Please advice, where might be a problem.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
842 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.