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@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