Logstash 同步 MySQL
input {
stdin {
}
jdbc {
# 驱动
jdbc_driver_library => "D:/elk/logstash-7.13.4/lib/mysql-connector-java-5.1.49.jar"
# 驱动类名
jdbc_driver_class => "com.mysql.jdbc.Driver"
# mysql 数据库链接,shop为数据库名
jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/pddadmin"
# 用户名和密码
jdbc_user => "root"
jdbc_password => "root"
jdbc_paging_enabled => "true"
jdbc_page_size => "50000"
# 执行的sql 文件路径+名称
statement_filepath => "D:/elk/logstash-7.13.4/bin/jdbc.sql"
# 设置监听间隔 各字段含义(由左至右)分、时、天、月、年,全部为*默认含义为每分钟都更新
schedule => "* * * * *"
# 索引类型
type => "hudong_type"
}
}
filter {
json {
source => "message"
remove_field => ["message"]
}
}
output {
elasticsearch {
hosts => ["10.10.6.22:9200"]
index => "hudong"
document_id => "%{id}"
}
stdout {
codec => json_lines
}
}