[no subject]

Modular Syslog (<a  rel="nofollow" href="http://sourceforge.net/projects/msyslog/";>http://sourceforge.net/projects/msyslog/</a>) will move the
syslog files to MySQL (or postgresql).  Throw in a little MySQL
replication, and do all the queries off one of the replication slaves.

Throw in a little stunnel for linux-linux syslog communication, and a
key-based authenticated SSH tunnel between the windows server and the
syslog server, and the syslog collecting should be very secure.

I haven't tried it in production or development yet.  I have downloaded it
to start playing it with it though.  I plan on tinkering with this all day
Thursday.

For my purposes, I'd like to have the reporting happen over https, maybe
using certs or passwords for authentication.

Jonathan Glass

&gt; Do you have a utility that runs on Winbloze that will do the inserts?
&gt;
&gt; I have code that I've written to read the logs.  All i guess it needs is
&gt; the MySQL glue.
&gt;
&gt; On Sat, 2004-02-14 at 20:52, Jonathan Glass wrote:
&gt;&gt; I'm thinking of having all my server logs (including NT/2K/2K+3) record
&gt;&gt; into a MySQL db for better reporting.  Does anyone know if MySQL can
&gt;&gt; handle 100,000+ inserts per day?  Also, if it handling this many
&gt;&gt; inserts,
&gt;&gt; how good is the SELECT performance for the automated reporting?  ANy
&gt;&gt; thoughts, pointers?
&gt;&gt;
&gt;&gt; Thanks!
&gt;
&gt; _______________________________________________
&gt; Ale mailing list
&gt; Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt;


-- 
Jonathan Glass
Systems Support Specialist II
IBB/GTEC
Office: 404-385-0127
Cell: 404-444-4086


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00500" href="msg00500.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> jonathan.glass at ibb.gatech.edu (Jonathan Glass)</li></ul></li>
<li><strong><a name="00507" href="msg00507.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Chris Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00507.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00502.html">[ale] Linux and Sprint PCS</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00507.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00503.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00501"><strong>Date</strong></a></li>
<li><a href="threads.html#00501"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>