Master configured to replicate to mispelled hostname
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 !
Subject
Views
Written By
Posted
Master configured to replicate to mispelled hostname
821
August 09, 2017 02:20PM
502
August 09, 2017 02:52PM
481
August 10, 2017 08:40AM
465
August 10, 2017 08:48AM
414
August 17, 2017 03:09AM
468
August 10, 2017 08:44AM
529
August 22, 2017 04:00AM
395
August 23, 2017 05:37AM
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.