<p dir="ltr">Hi,</p>
<p dir="ltr">It is possible but note that there are performance limitations with using MySQL especially if you want to keep data for long term storage.</p>
<p dir="ltr">You may want to check one of the nosql solutions (mongo for instance).</p>
<p dir="ltr">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.</p>
<p dir="ltr">Bazsi</p>
<div class="gmail_quote">On Sep 15, 2015 7:47 AM, "Arash Shams" <<a href="mailto:ara4sh@hotmail.com">ara4sh@hotmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">Hello <br>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. <br>is there possible to send all servers log to one syslog-ng server and that collect them to database ? <br>anyone can give me a good configuration file or some examples in this case ? <br>thank you <br> </div></div>
<br>______________________________________________________________________________<br>
Member info: <a href="https://lists.balabit.hu/mailman/listinfo/syslog-ng" rel="noreferrer" target="_blank">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a><br>
Documentation: <a href="http://www.balabit.com/support/documentation/?product=syslog-ng" rel="noreferrer" target="_blank">http://www.balabit.com/support/documentation/?product=syslog-ng</a><br>
FAQ: <a href="http://www.balabit.com/wiki/syslog-ng-faq" rel="noreferrer" target="_blank">http://www.balabit.com/wiki/syslog-ng-faq</a><br>
<br>
<br></blockquote></div>