Bug #33144 CHANGE MASTER does not validate host names within MASTER_HOST variable
Submitted: 11 Dec 2007 17:27 Modified: 17 Dec 2007 12:29
Reporter: Mark Leith Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.0, 5.1 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: CHANGE MASTER
Triage: Triaged: D5 (Feature request)

[11 Dec 2007 17:27] Mark Leith
Description:
Currently the CHANGE MASTER command accepts invalid host names within the MASTER_HOST variable. This is a feature request to add host name validation for anything entered in to the MASTER_HOST variable. 

How to repeat:
CHANGE MASTER TO MASTER_HOST = '<deleted>';
[17 Dec 2007 12:24] Lars Thalmann
I think it should be possible to configure a master even 
though the IP address/name is not in use.
[17 Dec 2007 12:29] Mark Leith
Hi Lars

It's one thing with the name not being in use, it's another to accept something that is not even a valid hostname. 

Could we at least do *some* verification that the hostname is not using characters that are not allowed within hostnames?

http://en.wikipedia.org/wiki/Hostname#Restrictions_on_valid_host_names

Also this is not listed as a bug, it is listed as a feature request.. 

Cheers,

Mark
[4 Jan 2013 17:11] Shane Bester
http://ronaldbradford.com/blog/not-a-cool-new-feature-for-master_host-2013-01-04/comment-p...