[ale] Any MySQL Experts around?

[Jonathan Glass]

Yes.  It is called 'NTSyslog'.
http://ntsyslog.sourceforge.net/
NT Syslog moves all eventlog items to a syslog server.

Modular Syslog (http://sourceforge.net/projects/msyslog/) 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

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


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