编写demo.conf
input {
jdbc {
type => "student"
jdbc_driver_library => "/home/ljj/software/logstash-6.3.1/tools/mysql-connector-java-5.1.46/mysql-connector-java-5.1.46.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/demo?useSSL=false"
jdbc_user => "root"
jdbc_password => "123456"
schedule => "* * * * * *" ### 定时任务
statement => "SELECT * FROM student where id > :sql_last_value"
use_column_value => true
tracking_column => "id"
last_run_metadata_path => "/home/ljj/syncpoint_table" ### 记录上次执行sql后的id值
clean_run => "false" ### 是否清空文件
}
}
output {
elasticsearch {
hosts => "127.0.0.1"
index => "index_demo"
}
}
es启动的情况下
./bin/logstash -f demo.conf & 运行程序