[ale] Any MySQL Experts around?

Jonathan Glass jonathan.glass at ibb.gatech.edu
Sat Feb 14 21:53:46 EST 2004

Yes.  It is called 'NTSyslog'.
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

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
Office: 404-385-0127
Cell: 404-444-4086

More information about the Ale mailing list