MySQL Bugs: #65803: RFE: hostname support for [mysqld] section of my.cnf

Bug #65803	RFE: hostname support for [mysqld] section of my.cnf
Submitted:	4 Jul 2012 4:36	Modified:	5 Aug 2012 9:28
Reporter:	Kevin Benton	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S4 (Feature request)
Version:	All	OS:	Linux (RHEL 5.3)
Assigned to:		CPU Architecture:	Any

Description:
Basically, I'm looking for the ability to dynamically configure multiple instances of MySQL from a single my.cnf file so I don't have to edit the file on each host but can re-use the same configuration file across multiple hosts. The example below is for MySQL Cluster but this could easily apply to other similar configurations of non-clustered MySQL.

It would be very helpful in many cases to be able to specify a [mysqld] block by some sort of identifier. In cases like that, the matador (for example) would appear in the instance-specific configuration section rather than in the defaults section.

Example...

[mysqld defaults]
datadir=/opt/mysqlcluster/this_host/data/
...

[mysqld]
hostname=clusterapi1.foo.com
server-id=1
ndb_nodeid=101

[mysqld]
hostname=clusterapi2.foo.com
server-id=2
ndb_nodeid=102

This could also be used for many similarly configured instances given the proper command-line parameters.

If this is already possible in some other way, please let me know.

How to repeat:
See Description.

Suggested fix:
See Description.

Thank you for the feature request.

I'm afraid I need a more concrete example.
Why is not --defaults-group-suffix sufficient ?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

While that "could" work, it doesn't match the configuration style of the rest of a MySQL Cluster where it figures out which section to use for data and management nodes. This would also be a very useful feature on hosts with shared configuration without needing to pass the suffix.