Serilog.Sinks.MySql.Tvans 0.1.4-alpha

Serilog.Sinks.MySql.Tvans

Provides a Serilog Sink for MySql with customizability in columns, data types. Initial goal was to provide customizability, which other MySQL sinks missed.

Note: not yet really production-ready because lack of batching, so not to be used when in need of high logging performance.

Example usage

Default

var logger = new LoggerConfiguration()
  .WriteTo.MySql(
    "yourConnectionString")
  .CreateLogger();

Default with options for specified columns

var logger = new LoggerConfiguration()
  .WriteTo.MySql(
    "yourConnectionString", 
    MySqlSinkOptions.Default,
    MySqlColumnOptions.Default
      .With(new IdColumnOptions { DataType = new DataType(Kind.Guid), Name = "Id" }))
  .CreateLogger();

Options for sink and columns

var logger = new LoggerConfiguration()
  .WriteTo.MySql(
    "yourConnectionString",
    new MySqlSinkOptions 
    {
      tableName = "log_events",
      autoCreateTable = false,
    },
    new MySqlColumnOptions
    {
      IdColumnOptions = new IdColumnOptions { Name = "Guid", DataType = new DataType(Kind.Guid) },
      TimeStampColumnOptions = new TimeStampColumnOptions { Name = "TimeStamp", UseUtc = true }
      MessageTemplateColumnOptions = new MessageTemplateColumnOptions { Name = "Message" },
      LogEventColumnOptions = new LogEventColumnOptions { Name = "Properties", EventSerializer = EventSerializer.Json }
    })
  .CreateLogger();

To-do

• batching support
• unit testing
• benchmarking