ElasticSearch 总结
[TOC]
ElasticSearch console:
http://192.168.1.155:9200/_plugin/head
ElasticSearch plugins
soudang@192.168.1.155:/data/elasticsearch-1.4.2/plugins
analysis-ik 分词插件
head 管理Console
jdbc 从DB读取数据的插件
- Project: SearchBridge
- SearchBridge/src/main/java/com/soudang/mobile/search/bridge/PawnHistory/PawnHistoryContinue.java
DB 与 ElasticSearch 的 mapping 定义
soudang@192.168.1.155:/data/elasticsearch-1.4.2/plugins/jdbc/foreverrun.sh
SoudangPawnsFileFeeder.java 配置文件
每间隔3秒从pawndb_head.changeLog, pawndb_head db 中同步业务数据
配置文件: ddt.config
/data/elasticsearch-1.4.2/plugins/jdbc/sync_corps155.sh
调用jdbc插件从mobile_db中同步企业信息数据
/data/elasticsearch-1.4.2/plugins/jdbc/sync_corps155_db.sh
curl -O http://192.168.1.155:8090/llt/rest/admin/syncCorporation
/data/elasticsearch-1.4.2/plugins/jdbc/watcher.sh
watcher dog 的实现例子
#!/bin/sh
script_found=` ps -ef |grep -v grep | grep SoudangPawnsFileFeeder | awk '{print $12}'`
if [ -z "$script_found" ]
then
echo "the script is not running `date`" >> /tmp/watcher.log
cd /data/elasticsearch-1.4.2/plugins/jdbc
nohup ./sync_pawns155File.sh &
echo "start the script ..." >> /tmp/watcher.log
else
echo "the script is running $script_found `date`" >> /tmp/watcher.log
fi
从elasticSearch 中查询:
- Project: llt
- 查询API 例子: llt/src/com/soudang/mobile/rest/resources/StatsResource.java
基础知识
Elasticsearch 与 数据库的对应
Relational DB -> Databases -> Tables -> Rows -> Columns
Elasticsearch -> Indices -> Types -> Documents -> Fields
索引
- 名词:相关文档存储的地方，类似关系型数据库中的数据库
- 动词： 把一个文档存储到索引里，以便能检索或查询到，类似insert
- 倒排索引: 类似数据库中为某个列加索引, 在ElasticSearch中是倒排索引
查询的例子
http://192.168.1.155:9200/soudang/pawnhistory/_search?q=corporationid:626
Index: soudang
type: pawnhistory
_search 查询
q=<> 查询参数
a->b:aaa
