[syslog-ng] mysql destinations - more options for table creation

[Fekete, Róbert]

Hi,

syslog-ng can automatically create tables if you use macros in the table
names.
As for additional options, newer syslog-ng versions have a dbd-option()
that can be used to set database options when syslog-ng connects the
database (it might or might not be enough for your needs), see
https://www.balabit.com/documents/syslog-ng-ose-latest-guides/en/syslog-ng-ose-guide-admin/html/reference-destination-sql.html

HTH,

Robert

On Mon, Mar 6, 2017 at 6:44 PM, Nik Ambrosch <nik at ambrosch.com> wrote:

> When creating a table in a mysql destination, I have not found a way to
> specify additional options - I’d like to add row_format in order to enable
> innodb compression.  A regular mysql query would look like this:
>
> create table “my_table_yyyymmdd” (columns here) ROW_FORMAT=COMPRESSED;
>
> Is it possible to tell syslog-ng to make this happen with syslog-ng or
> will i need to cron an external job to create the tables daily?
>
> Thanks.
>
> ____________________________________________________________
> __________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation: http://www.balabit.com/support/documentation/?
> product=syslog-ng
> FAQ: http://www.balabit.com/wiki/syslog-ng-faq
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.balabit.hu/pipermail/syslog-ng/attachments/20170306/1b1b7df7/attachment.html>