0、前提
1)已经安装好源数据库:Mysql;
2)已经安装好目的数据库:Mongodb;
3)已经安装好logstash及相关插件logstash-output-mongodb
安装步骤参考:http://blog.csdn.net/laoyang360/article/details/65448962
1、同步conf配置详解
[root@la bin]# cat ./logstash_jdbc_mongo/jdbc_mongo.conf
input {
stdin {
}
jdbc {
‘# 源Mysql数据库地址
jdbc_connection_string => "jdbc:mysql://20.18.11.4:3306/tech?zeroDateTimeBehavior=convertToNull"
#源Mysql的用户名和密码
jdbc_user => "root"
jdbc_password => "rot123"
‘ #true代表记录最后存储的关联列值
record_last_run => "true"
use_column_value => "true"
tracking_column => "id"
‘ #存储位置
last_run_metadata_path => "/opt/logstash/bin/logstash_jdbc_mongo/mongo_info"
clea