Logstash使用jdbc同步MySQL中的数据

[2018-02-26T20:50:05,305][WARN ][logstash.inputs.jdbc     ] Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaLang::OutOfMemoryError: Java heap space>}
[2018-02-26T20:50:05,333][WARN ][logstash.inputs.jdbc     ] Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaLang::OutOfMemoryError: Java heap space>}
Error: Your application used more memory than the safety cap of 1G.
Specify -J-Xmx####M to increase it (#### = cap size in MB).
Specify -w for full java.lang.OutOfMemoryError: Java heap space stack trace

修改logstash/config/jvm.options

-Xms1g
-Xmx2g

搞定！

参考自：https://github.com/elastic/logstash/issues/4766