Replication stopped working

Question

Replication stopped working

Adam Hamer 0

I have had replication working for a long time. Something broke recently.

Servers:

ecco-db1 - master on vnet: production-vnet [UK South]
ecco-dbw1b - slave on vnet: production-vnetw [UK West]

ISSUE:

show slave status\G;

          Slave_IO_Running: Connecting

          Slave_SQL_Running: Yes

          Last_IO_Errno: 2026

          Last_IO_Error: error connecting to master '6104c@b6f99:3306' - retry-time: 60  retries: 14

I have verified that:

the az_replication_change_master has a valid username/password
the az_replication_change_master has a valid master_ssl_ca (using 'Download SSL Certificate' from the master)
the master has 'Enforced TLS/SSL connection'
az_replication_stop, az_replication_change_master, az_replication_start
same error each time

Thanks,

Adam

Adam Hamer 0 Reputation points

2026-02-10T10:35:15.1766667+00:00
I should have added:

Servers:

The vnets have a peering called 'production-vnetw-vnets'
Adam Hamer 0 Reputation points

2026-02-12T22:42:03.49+00:00

Can someone please sort out setting up a teams. I have all the info in the private messaging.
Pilladi Padma Sai Manisha 8,405 Reputation points Microsoft External Staff Moderator

2026-02-13T11:25:11.15+00:00

Hi Adam Hamer,
We are reaching you in teams to trouble shoot further.

1 answer

Your answer

Adam Hamer 0 Reputation points

2026-02-10T10:35:15.1766667+00:00

I should have added:

Servers:

The vnets have a peering called 'production-vnetw-vnets'
Adam Hamer 0 Reputation points

2026-02-12T22:42:03.49+00:00

Can someone please sort out setting up a teams. I have all the info in the private messaging.
Pilladi Padma Sai Manisha 8,405 Reputation points Microsoft External Staff Moderator

2026-02-13T11:25:11.15+00:00

Hi Adam Hamer,
We are reaching you in teams to trouble shoot further.

Answer 1

Pilladi Padma Sai Manisha 8,405 Microsoft External Staff Moderator

Hi Adam Hamer,
This is issue due to certificate not updated.

Shared below document and helped cx in MS Teams call

Certificate Rotation for Azure Database for MySQL - Azure Database for MySQL | Microsoft Learn

Adam Hamer 0 Reputation points

2026-03-04T19:29:07.2433333+00:00

We concatenated the three certificates within the link and used that in the @cert variable. Note that for the last .cer file, we had to convert/extract the original pem file from it. Note that the SSL certification that can be downloaded from the source database (in Networking) is not required - it's already in one of these 3 files. Note also that the replication server needed restarting! Then it all started working again.

I need to check where those emails notifications are going about things like root certificate changes. Apparently they go to the subscription contact.

Hope that all helps other people.

Thanks.

Share via

Replication stopped working

1 answer

Your answer