下载logstash-6.7.0工具
在config 文件夹新建 mysql.conf
input {
jdbc {
jdbc_driver_library => "D:/logstash-6.7.0/bin/mysqldriver/mysql-connector-java-5.1.47.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://192.168.233.130:3306/sso?autoReconnect=true&useSSL=false"
jdbc_user => "root"
jdbc_password => "Xiongliang2019@"
schedule => "* * * * *"
jdbc_default_timezone => "Asia/Shanghai"
statement => "SELECT * FROM oauth2_user;"
}
}
output {
elasticsearch {
index => "user"
document_type => "user"
document_id => "%{elkid}"
hosts => ["localhost:9200"]
}
}
运行: bin\logstash -f config\mysql.conf