1.elasticsearch版本:7.1.1
2.logstash版本:7.1.1
步骤
- 在logstash目录下建立目录mysql_plugin
- 目录下建立一个xxxx.conf文件 名字随意
- 建立sql文件
xxx.conf
input {
stdin {
}
jdbc {
jdbc_connection_string => "jdbc:mysql://localhost:3306/yourdatabase?characterEncoding=UTF-8&useSSL=false"
jdbc_user => "yourname"
jdbc_password => "password"
jdbc_driver_library => "D:/tools/gradle-4.10.3/repository/caches/modules-2/files-2.1/mysql/mysql-connector-java/5.1.10/b83574124f1a00d6f70d56ba64aa52b8e1588e6d/mysql-connector-java-5.1.10.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_paging_enabled => "true"
jdbc_page_size => "1000"
statement_filepath => "D:/tools/es/logstash-7.1.1/mys