Bug #79075 make report_host a dynamic variable
Submitted: 2 Nov 2015 14:06 Modified: 16 Nov 2015 7:17
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.6.25 OS:Any
Assigned to: CPU Architecture:Any
Tags: report_host

[2 Nov 2015 14:06] Simon Mudd 
Description:
In an attempt to make as many mysql configuration variables as possible dynamic I'm going to report those that I find I need to change but can not without restarting mysqd.

report_host is one such variable. It's not used heavily but when used makes it easier to identify hostnames on the master when the command show slave hosts is used.

How to repeat:
Attempting to change report_host fails:

14:58:24 [myuser@myserver ~]$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10873028
Server version: 5.6.25-log MySQL Community Server (GPL)
...
myuser@myserver [(none)]> set global report_host = 'some-host-name';
ERROR 1238 (HY000): Variable 'report_host' is a read only variable

Suggested fix:
Make the setting dynamic.
[16 Nov 2015 7:17] MySQL Verification Team 
Hello Simon,

Thank you for the feature request!

Thanks,
Umesh