测试版本:
- elasticsearch 7.10.2
- kibana 7.10.2
- logstash 7.10.2
- jdk java-11.0.10
mysql驱动下载:https://pan.baidu.com/s/1RJ-a6FFVyIXShrEb4JWVvw
提取码:wj89
1、新建索引index:test
2、新建配置文件:mysql.conf
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/malltool?characterEncoding=utf-8&&useSSL=false&&serverTimezone=Asia/Shanghai"
jdbc_user => "root"
jdbc_password => "0825"
jdbc_driver_library => "D:\logstash\mysql-connector-java-8.0.23.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_paging_enabled => "true"
jdbc_page_size => "50"
statement => "SELECT * from system_log"
schedule => "* * * * *"
}
}
output {
elasticsearch {
hosts => "127.0.0.1:9200"
index => "test"
document_id => "%{id}"
}
stdout {
codec => json_lines
}
}
4、执行:
logstash -f ./config/mysql.conf
5、查询数据
GET /test/_search