mysql load data to elasticsearch 脚本

安装 elasticsearch-jdbc-2.3.2.0 必须的

!/bin/bash

set -e
bin=/home/baimu/elasticsearch-jdbc-2.3.2.0/bin
lib=/home/baimu/elasticsearch-jdbc-2.3.2.0/lib
echo ‘{
“type” : “jdbc”,
“jdbc” : {
“url” : “jdbc:mysql://172.16.18.221:3306/bs”,
“user” : “root”,
“useSSL”:”false”,
“password” : “a”,
“sql” : “select * from bs_cdma_460;”,
“index”: “bs”,
“type”: “bs_cdma_460”,
“elasticsearch” : {
“cluster” : “baimu-es”,
“host” : “172.16.18.111”,
“port” : 9300
}
}
}’ | java \
-cp “${lib}/*” \ -Dlog4j.configurationFile=${bin}/log4j2.xml \
org.xbib.tools.Runner \
org.xbib.tools.JDBCImporter