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
Triage: Needs Triage: D5 (Feature request)

[4 Jul 2012 4:36] Kevin Benton
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.
[4 Jul 2012 9:47] Valeriy Kravchuk
Thank you for the feature request.
[4 Jul 2012 9:59] Georgi Kodinov
I'm afraid I need a more concrete example.
Why is not --defaults-group-suffix sufficient ?
[5 Aug 2012 1:00] Bugs System
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".
[5 Aug 2012 5:40] Kevin Benton
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.