Skip to content
share library_books

Query data from MySQL

Input Plugin: MySQL

Input plugin to use MySQL queries as input and stream the output into Logagent.

Features:

  • run queries frequently
  • choose time zone and format for query time
  • use multiple SQL query statements

Applications:

  • index SQL data to elasticsearch
  • create alerts based on data in MySQL database

Configuration

input:
  mysql-json:
    module: mysql-query
    server: 
      host: 'localhost'
      user: 'root'
      password: ''
      database: 'test'
    queries: 
      - sourceName: query1
        sql: SELECT * FROM potluck where signup_date < '$queryTime'
      - sourceName: query2      
        sql: SELECT * FROM potluck where name = 'Tina' and signup_date < '$queryTime'
      - sourceName: query3
        sql: SELECT * FROM potluck where name = 'Sandy' and signup_date < '$queryTime'
    interval: 1
    debug: true

output:
    stdout: yaml

Start Logagent

logagent --config mysql.yaml