MySQL Logs

# ============================== Filebeat modules ==============================
filebeat.config.modules:
  path: ${path.config}/modules.d/*.yml
  reload.enabled: false
  #reload.period: 10s
 
# ================================== Outputs ===================================
# ------------------------------ Logstash Output -------------------------------
output.logstash:
  hosts: ["@logstash.host:@logstash.sslPort"]
  loadbalance: true
  ssl.enabled: true
 
# ================================= Processors =================================
processors:
  - add_host_metadata:
      when.not.contains.tags: forwarded
  - add_cloud_metadata: ~
  - add_docker_metadata: ~
  - add_kubernetes_metadata: ~

# ... For Filebeat 7 only ...
filebeat.registry.path: /var/lib/filebeat

# ... For Filebeat 6 only ...
registry_file: /var/lib/filebeat/registry

# Read metrics from one or many mysql servers
[[inputs.mysql]]
  ## specify servers via a url matching:
  ##  [username[:password]@][protocol[(address)]]/[?tls=[true|false|skip-verify|custom]]
  ##  see https://github.com/go-sql-driver/mysql#dsn-data-source-name
  ##  e.g.
  ##    servers = ["user:passwd@tcp(127.0.0.1:3306)/?tls=false"]
  ##    servers = ["user@tcp(127.0.0.1:3306)/?tls=false"]
  #
  ## If no servers are specified, then localhost is used as the host.
  servers = ["tcp(127.0.0.1:3306)/"]
 
  ## Selects the metric output format.
  ##
  ## This option exists to maintain backwards compatibility, if you have
  ## existing metrics do not set or change this value until you are ready to
  ## migrate to the new format.
  ##
  ## If you do not have existing metrics from this plugin set to the latest
  ## version.
  ##
  ## Telegraf >=1.6: metric_version = 2
  ##           <1.6: metric_version = 1 (or unset)
  metric_version = 2
 
  ## if the list is empty, then metrics are gathered from all database tables
  # table_schema_databases = []
 
  ## gather metrics from INFORMATION_SCHEMA.TABLES for databases provided
  ## in the list above
    gather_table_schema = true
 
  ## gather thread state counts from INFORMATION_SCHEMA.PROCESSLIST
    gather_process_list = true
 
  ## gather user statistics from INFORMATION_SCHEMA.USER_STATISTICS
    gather_user_statistics = true
 
  ## gather auto_increment columns and max values from information schema
    gather_info_schema_auto_inc = true
 
  ## gather metrics from INFORMATION_SCHEMA.INNODB_METRICS
    gather_innodb_metrics = true
 
  ## gather metrics from all channels from SHOW SLAVE STATUS command output
  # gather_all_slave_channels = false
 
  ## gather metrics from SHOW SLAVE STATUS command output
    gather_slave_status = true
 
  ## use SHOW ALL SLAVES STATUS command output for MariaDB
  # mariadb_dialect = false
 
  ## gather metrics from SHOW BINARY LOGS command output
    gather_binary_logs = true
 
  ## gather metrics from SHOW GLOBAL VARIABLES command output
    gather_global_variables = true
 
  ## gather metrics from PERFORMANCE_SCHEMA.TABLE_IO_WAITS_SUMMARY_BY_TABLE
    gather_table_io_waits = true
 
  ## gather metrics from PERFORMANCE_SCHEMA.TABLE_LOCK_WAITS
    gather_table_lock_waits = true
 
  ## gather metrics from PERFORMANCE_SCHEMA.TABLE_IO_WAITS_SUMMARY_BY_INDEX_USAGE
    gather_index_io_waits = true
 
  ## gather metrics from PERFORMANCE_SCHEMA.EVENT_WAITS
    gather_event_waits = true
 
  ## gather metrics from PERFORMANCE_SCHEMA.FILE_SUMMARY_BY_EVENT_NAME
    gather_file_events_stats = true
 
  ## gather metrics from PERFORMANCE_SCHEMA.EVENTS_STATEMENTS_SUMMARY_BY_DIGEST
  # gather_perf_events_statements = false
  #
  ## gather metrics from PERFORMANCE_SCHEMA.EVENTS_STATEMENTS_SUMMARY_BY_ACCOUNT_BY_EVENT_NAME
    gather_perf_sum_per_acc_per_event = true
  #
  ## list of events to be gathered for gather_perf_sum_per_acc_per_event
  ## in case of empty list all events will be gathered
  # perf_summary_events = []
 
  ## the limits for metrics form perf_events_statements
  # perf_events_statements_digest_text_limit = 120
  # perf_events_statements_limit = 250
  # perf_events_statements_time_limit = 86400
 
  ## Some queries we may want to run less often (such as SHOW GLOBAL VARIABLES)
  ##   example: interval_slow = "30m"
  # interval_slow = ""
 
  ## Optional TLS Config (used if tls=custom parameter specified in server uri)
  # tls_ca = "/etc/telegraf/ca.pem"
  # tls_cert = "/etc/telegraf/cert.pem"
  # tls_key = "/etc/telegraf/key.pem"
  ## Use TLS but skip chain & host verification
  # insecure_skip_verify = false

[[outputs.http]]
  url = "https://@metricsUsername:@metricsPassword@@metrics_id-vm.logit.io:@vmAgentPort/api/v1/write"
  data_format = "prometheusremotewrite"
 
  [outputs.http.headers]
    Content-Type = "application/x-protobuf"
    Content-Encoding = "snappy"