logstash从MySQL导入数据到ElasticSearch的配置

input {
    stdin {
    }
    jdbc {
      # 数据库
      jdbc_connection_string => "jdbc:mysql://172.0.0.1:3306/inssa?characterEncoding=UTF-8&useSSL=false"
      # 用户名密码
      jdbc_user => "root"
      jdbc_password => "root"
      jdbc_default_timezone => "UTC"
      # jar包的位置
      jdbc_driver_library => "/usr/local/logtash-5.1.1/mysql-connector-java-5.5.19.jar"
      # mysql的Driver
      jdbc_driver_class => "com.mysql.jdbc.Driver"
      jdbc_paging_enabled => "true"
      lowercase_column_names => "false"
      jdbc_page_size => "50000"
      # statement_filepath => "config-mysql/jdbc2logstash_history.sql"
      statement => "select * from operationlogs"
      schedule => "* * * * *"
      #索引的类型
      type => "operationlogs"
    }


}