Bug #28303 no choise to save master.info apart of data directory
Submitted: 8 May 2007 12:26 Modified: 8 May 2007 12:55
Reporter: Marcin Przyczyna Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:5.0.37 OS:Any
Assigned to: CPU Architecture:Any

[8 May 2007 12:26] Marcin Przyczyna
Description:
For now (stable is 5.0.37 ) I can't set in my my.cnf the path to save master.info file, which default is stored in the data and not the log directory (where it IMHO belongs).

It is possible, that I'm wrong, but then please build in a switch to select the destination for saving master.info file, similarly to the other log files destinations of user's choice.

Yet other suggestion:
instead of setting many of files per hand I would appreciate a few switches:
- data dir = directory containing data (already present !)
- log dir = directory containing all the log files (missing)

Greetings,
Marcin Przyczyna,
mpr@swm.de

How to repeat:
Try to set the location of master.info besides of data directory set in my.cnf

Suggested fix:
1.
new switch for storing "master.info" file (apart of datadir) in my.cnf, based on syntax of "log-error", "relay-log", "relay-log-index", "log-slow-queries" switches.

or 
2. new switch to save all the log related files in a directory of DBA's choice,
called "logdir", as compartment to already existing switch "datadir".

or
3. both proposals concurrently :-)
[8 May 2007 12:33] Valeriy Kravchuk
Thank you for a reasonable feature request.
[8 May 2007 12:34] Johan Idrén
This feature already exists.

from mysqld --help --verbose:

  --master-info-file=name 
                      The location and name of the file that remembers the
                      master and where the I/O replication thread is in the
                      master's binlogs.
[8 May 2007 12:40] Valeriy Kravchuk
Indeed. Read http://dev.mysql.com/doc/refman/5.0/en/replication-options.html also.
[8 May 2007 12:40] Johan Idrén
The option is also documented on http://dev.mysql.com/doc/refman/5.0/en/replication-options.html
[8 May 2007 12:55] Marcin Przyczyna
Indeed. My fault.

Please upgrade the online documentation (MySQL Reference Manual, ver 5.0 and 5.1),
section 5.11 "MySQL Server Logs" or chapter 6, "Replication"

The log files relevant to replication and their configuration aren't described in chapter 5.11 as well as in chapter 6 at all.

By the way:
thanks for quick response !