MySQL Forums
Forum List  »  Replication

Master configured to replicate to mispelled hostname
Posted by: Eric Krejci
Date: August 09, 2017 02:20PM

Well I am new to MySQL and am trying to setup replication, and I somehow got the master to try to replicate to a mispelled hostname. The other two replication pairs I setup work fine. The mispelled hostname doesn't exist or ping or anything but when I run:

mysqlrplshow --master=<repidname>:<pw>@<master> --discover-slaves-login=\<repidname>:<pw>

it connects to the master ok.
it tries to find the slaves and says

WARNING: Cannot connect to some slaves:
- <mistypedhostname>:<properport>: Can't connect to MySQL server on '<mistypedhostname>' (-2 Name or service not known)

I have tried these things:
On slave:
- logged in as rpl user
- STOP SLAVE;
- RESET SLAVE;
restarted services

same error.

Then i tried the same on both master and slave with service restart. I got the same error.

It feels like there is a configuration piece somewhere which tells it to replicate to that nonexistent server.

Are there other things I can try ?

Thank you for any help !

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.