rgerhards at hq
Apr 5, 2012, 7:48 AM
Post #4 of 4
(285 views)
Permalink
|
> -----Original Message-----
> From: Patrick H. [mailto:rsyslog [at] stormcloud9]
> Sent: Thursday, April 05, 2012 3:45 PM
> To: rsyslog-users
> Cc: Rainer Gerhards
> Subject: Re: [rsyslog] does omlibdbi support transactions?
>
> Several different databases, oracle, mysql, and sqlite. Oracle is the
> big one, and I can see from looking at its module documentation that it
> does support transactioning, but it doesnt look like the mysql module
> does,
the current version does
>and then sqlite I would have to use libdbi. However the sqlite
> one I could probably get away without transactioning (though it would
> be nice to have).
It probably is not too hard to add the transaction support - I guess you
could even try if you can hack a little C. I am very tempted to do it, but be
so swamped with lots of work at the moment...
Have a look at ommysql as a template.
Rainer
>
>
>
> Sent: Thu Apr 05 2012 09:35:07 GMT-0400 (EDT)
> From: Rainer Gerhards <rgerhards [at] hq>
> <mailto:rgerhards [at] hq>
> To: rsyslog-users <rsyslog [at] lists>
> <mailto:rsyslog [at] lists>
> Subject: Re: [rsyslog] does omlibdbi support transactions?
>
> Do you have a datastore that is not natively supported? Omlibdbi
> is kind of a
> fallback solution and has not been optimized that much.
>
> Rainer
>
>
> -----Original Message-----
> From: rsyslog-bounces [at] lists [mailto:rsyslog-
> bounces [at] lists] On Behalf Of Patrick Hemmer
> Sent: Thursday, April 05, 2012 3:29 PM
> To: rsyslog [at] lists
> Subject: [rsyslog] does omlibdbi support transactions?
>
> I'm looking at switching to rsyslog from syslog-ng, but one
> of the critical
> features needed is the ability to use transactions when
> writing to an SQL
> database. By this I mean to not have autocommit on, or do a
> commit after
> every insert. Basically can it be configured to do a commit
> after every X
> inserts, or every X seconds?
>
> From looking around, it appears rsyslog does not support
> this, but I just
>
> want
>
> to make sure.
>
> Thanks
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
> http://www.rsyslog.com/professional-services/
>
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
> http://www.rsyslog.com/professional-services/
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
|
