[ERROR] Slave I/O for channel '': error connecting to master

Description

Hi Team,

 

We are facing a strange issue with percona server(5.7.27-30-log). when we are setting up replication using dns it is throwing error:

while we are able to nslookup and ping the dns name from console:

 

Environment

None

Smart Checklist

Activity

Show:

Lalit Choudhary January 20, 2021 at 1:28 PM
Edited

Hi Ankit,

As we can see in my test, I don't see any issue with replication when using the hostname as follows, 

 

 

 

similar issues discussed in the following link, which you may find useful:

https://dba.stackexchange.com/questions/11775/mysql-replication-via-dns-failure

 

 

 

Ankit Kumar January 20, 2021 at 12:25 PM

but Replication doesn't work.

Ankit Kumar January 20, 2021 at 12:18 PM

Hey Lalit,

Thanks for looking into it. I am able to connect MySQL via command line using client.

Lalit Choudhary January 20, 2021 at 12:11 PM
Edited

Hi

check if you are able to connect to master from slave using the same hostname/dns via mysql client?

this might be a connection issue and not a  bug.

Cannot Reproduce

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created January 20, 2021 at 7:04 AM
Updated March 6, 2024 at 10:45 AM
Resolved January 20, 2021 at 1:29 PM