遇到问题
- head UI只展示一条数据,索引过滤不了
- 原因: document_id => “%{user_id}” 中user_id 参考教程未改
- 解决:根据自己的主键改成对象的%{自己表的主键}
- 后续:如果是多个表同步怎么办? - 同步时sql_last_value 一直是0,查看logstash_jdbc_last_run也确实为0
- 原因: use_column_value=> false 是默认值,参照教程却给设置成了true
- 解决: 屏蔽use_column_value=> true - 示例同步文件:
input{
jdbc {
# jdbc_driver_library => "mysql-connector-java-5.1.44-bin.jar"
# 驱动
jdbc_driver_library => "/usr/local/soft/logstash-input-jdbc-master/lib/mysqljdbc-5.1.18.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://172.16.0.178:3308/mtp_dev"
jdbc_user => "mtp_dev"
jdbc_password => "mtp_dev"
jdbc_paging_enabled => "true"
jdbc_page_size => "1000"
jdbc_default_timezone =>"Asia/Shanghai"
schedule => "* * * * *"
statement => "SELECT * FROM user_sys_user where latest_time > :sql_last_value"
# record_last_run => true
# use_column_value=> false
tracking_column => "latest_time"
last_run_metadata_path => "./logstash_jdbc_last_run"
clean_run => "false"
}
}
output{
elasticsearch {
hosts => "172.16.0.94:9200"
user => "elastic"
password => "changme"
index => "sys_user"
document_id => "%{user_id}"
}
stdout {
codec => json_lines
}
}