[ale] Any MySQL Experts around?
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.
> 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
>> how good is the SELECT performance for the automated reporting? ANy
>> thoughts, pointers?
> Ale mailing list
> Ale at ale.org
Systems Support Specialist II
More information about the Ale