> -----Original Message----- > From: Patrick H. [mailto:[email protected]] > 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 <[email protected]> > <mailto:[email protected]> > To: rsyslog-users <[email protected]> > <mailto:[email protected]> > 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: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Patrick Hemmer > Sent: Thursday, April 05, 2012 3:29 PM > To: [email protected] > 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/
