Hi!
On Mar 18, Mariella Petrini wrote:
>
> I would like to ask more questions, please, related to
> mysqld and syslog logging for general log and slow-log
> and using syslog-ng.
>
> Would it make sense, which could be the best way and
> which could be the cons of trying to make mysqld code
> working with syslog-ng ?
> Or is there an easier way of doing that ?
The simplest way is, indeed, speficic to syslog-ng. But looks like it's
what you want anyway :)
syslog-ng can use a file or a unix pipe as a source. Try
source testfile { file("/tmp/logfile" follow_freq(1) flags(no-parse)); };
or
source testpipe { pipe("/tmp/logpipe" flags(no-parse)); };
in your syslog-ng.conf, then use them in log {} directive, and configure
MySQL to log to a specified file or a pipe.
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Developer/Server Architect
/_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Dachauer Str. 37, D-80335 München
<___/ Geschäftsführer: Kaj Arnö - HRB
München 162140