[MDEV-6911] Slaves do not auto-register themselves with master Created: 2014-10-22  Updated: 2016-10-08

Status: Open
Project: MariaDB Server
Component/s: Replication
Fix Version/s: None

Type: Task Priority: Critical
Reporter: Guillaume Lefranc Assignee: Unassigned
Resolution: Unresolved Votes: 4
Labels: None


 Description   

If the report-host variable is not manually set on the slaves, the hostname or IP address is not automatically registered with the master and SHOW SLAVE HOSTS reports an empty string:

MariaDB [(none)]> show slave hosts;

Server_id Host Port Master_id
12   3306 11

This causes replication topology auto-discovery to be impractical, and advanced tools (such as failover management or replication hierarchy management tools) to be a pain to develop.

Suggestion is to set report-host with a default value, e.g. syscall to gethostname or gethostbyname.



 Comments   
Comment by Elena Stepanova [ 2014-10-22 ]

Moved to Type=Task since it now works as specified, so it's not exactly a bug.

For a note, now report-host can be left empty if it's unnecessary (or undesirable, on whatever reason) to register the slave with the master. If the default behavior is implemented as suggested, this possibility will be lost, and also old configurations will start working differently.

Comment by Joffrey MICHAIE (Inactive) [ 2015-02-23 ]

Hi, right now, we have to manually set the hostname as report_host on the slaves, for it to be displayed.
What would be the problem if we by default, report_host = @@hostname ? I don't see what it can break, in a different way than when we set manually the parameter.

Generated at Thu Feb 08 07:15:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.