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
1090
August 09, 2017 02:20PM
598
August 09, 2017 02:52PM
577
August 10, 2017 08:40AM
584
August 10, 2017 08:48AM
563
August 17, 2017 03:09AM
576
August 10, 2017 08:44AM
648
August 22, 2017 04:00AM
507
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.