[syslog-ng] Syslog ng and Mysql

[Balazs Scheidler]

Hi,

It is possible but note that there are performance limitations with using
MySQL especially if you want to keep data for long term storage.

You may want to check one of the nosql solutions (mongo for instance).

If you want to stick to single box solutions, you might want to look into
syslog-ng Store Box (note it is commercial) that indexes data at pretty
high speeds but as of now is not scalable horizontally, but works out of
the box for your usecase.

Bazsi
On Sep 15, 2015 7:47 AM, "Arash Shams" <ara4sh at hotmail.com> wrote:

> Hello
> ELK solution is not suitable for us to collect all logs in one server . i
> prefer to use syslog-ng to collect all logs in Mysql database.
> is there possible to send all servers log to one syslog-ng server and that
> collect them to database ?
> anyone can give me a good configuration file or some examples in this case
> ?
> thank you
>
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation:
> http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.balabit.com/wiki/syslog-ng-faq
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20150918/691d8d14/attachment.htm