logstash的http output配置

最新推荐文章于 2024-04-17 07:08:45 发布

蒜蓉粉丝蒸扇贝

最新推荐文章于 2024-04-17 07:08:45 发布

阅读量4.6k

点赞数

分类专栏：大数据

本文链接：https://blog.csdn.net/smithallenyu/article/details/80571656

版权

本文介绍了如何配置Logstash的HTTP输出插件，连接到MySQL备份数据库的JDBC连接字符串示例为：jdbc:mysql://ip:port/database?zeroDateTimeBehavior=convertToNull。

摘要由CSDN通过智能技术生成

input {
jdbc {

# mysql jdbc connection string to our backup databse

jdbc_connection_string => "jdbc:mysql://ip:port/database?zeroDateTimeBehavior=convertToNull"

# the user we wish to excute our statement as
jdbc_user => "xxxx"
jdbc_password => "xxxx"
# the path to our downloaded jdbc driver
jdbc_driver_library => "/home/admin/data/mysql-connector-java-5.1.36/mysql-connector-java-5.1.36-bin.jar"
# the name of the driver class for mysql
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_paging_enabled => "true"
jdbc_page_size => "50000"
#statement_filepath => "jdbc.sql"
statement => "SELECT * from mytable WHERE field = xx"
type => "jdbc"