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
1268
August 09, 2017 02:20PM
669
August 09, 2017 02:52PM
680
August 10, 2017 08:40AM
656
August 10, 2017 08:48AM
660
August 17, 2017 03:09AM
661
August 10, 2017 08:44AM
752
August 22, 2017 04:00AM
585
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.