参考以下链接:
Linux(centos7)如何部署ElasticSearch7.6.2单节点跟集群(es部署指南)
参考下文更加详细:windows ElasticSearch 7.6.0集群搭建
可去官网:
也可去社区:elastic中文社区下载地址
改elasticsearch7.6.2的配置文件elasticsearch.yml,该文件路径为es1/conf/elasticsearch.yml
#集群名称,保证唯一
cluster.name: my-elasticsearch
#节点名称,必须不一样
node.name: node-1
#必须为本机的IP地址
network.host: 127.0.0.1
#服务端口号,在同一机器下必须不一样
http.port: 9201
#集群间通信端口号,在同一机器下必须不一样
transport.tcp.port: 9301
#设置集群自动发现机器IP集合
discovery.zen.ping.unicast.hosts: ["127.0.0.1:9301","127.0.0.1:9302","127.0.0.1:9303"]
#是否支持跨域,默认为false
http.cors.enabled: true
#当设置允许跨域,默认为*,表示支持所有域名
http.cors.allow-origin: "*"
#指定master
cluster.initial_master_nodes: node-1
#集群名称,保证唯一
cluster.name: my-elasticsearch
#节点名称,必须不一样
node.name: node-2
#必须为本机的IP地址
network.host: 127.0.0.1
#服务端口号,在同一机器下必须不一样
http.port: 9202
#集群间通信端口号,在同一机器下必须不一样
transport.tcp.port: 9302
#设置集群自动发现机器IP集合
discovery.zen.ping.unicast.hosts: ["127.0.0.1:9301","127.0.0.1:9302","127.0.0.1:9303"]
#是否支持跨域,默认为false
http.cors.enabled: true
#当设置允许跨域,默认为*,表示支持所有域名
http.cors.allow-origin: "*"
#指定master
cluster.initial_master_nodes: node-1
#集群名称,保证唯一
cluster.name: my-elasticsearch
#节点名称,必须不一样
node.name: node-3
#必须为本机的IP地址
network.host: 127.0.0.1
#服务端口号,在同一机器下必须不一样
http.port: 9203
#集群间通信端口号,在同一机器下必须不一样
transport.tcp.port: 9303
#设置集群自动发现机器IP集合
discovery.zen.ping.unicast.hosts: ["127.0.0.1:9301","127.0.0.1:9302","127.0.0.1:9303"]
#是否支持跨域,默认为false
http.cors.enabled: true
#当设置允许跨域,默认为*,表示支持所有域名
http.cors.allow-origin: "*"
#指定master
cluster.initial_master_nodes: node-1
进入各自bin目录,执行:
./eslasticsearch
如上方法依次启动三个节点的,启动完成之后可以看到三个节点成功。
成功后使用浏览器进入:127.0.0.1:9200,查看是否成功。
analyzer [ik_smart] not found for field [name]
本人在window测试环境搭建,es访问和cerebro访问都未设置密码,如果要设置账号密码,可参考此文:Elastic监控工具 - cerebro
下载地址:cerebro下载地址
因为我是window版本,下载.zip文件,linux可选择.tgz。
略。
打开命令行窗口,在cerebro/bin目录,执行
./cerebro
启动完成之后在浏览器输入: http://localhost:9000/
在上图Node Address中输入节点地址,任一节点地址都行:
点击Connect,即可看到当前集群中三个节点状态:
关于cerebro的一些基本功能,后续再详述。
参考文章:
logstash同步数据到es
增加logstash-test-log-sync.conf配置:
input {stdin {}jdbc {type => "jdbc"jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/test_db?useUnicode=true&allowMultiQuerie=true&characterEncoding=utf-8&serverTimezone=UTC"# 数据库连接账号密码;jdbc_user => "root"jdbc_password => "root"# MySQL依赖包路径;jdbc_driver_library => "E:\Java\Document\m2\repository\mysql\mysql-connector-java\5.1.21\mysql-connector-java-5.1.21.jar"# the name of the driver class for mysqljdbc_driver_class => "com.mysql.jdbc.Driver"#是否开启分页jdbc_paging_enabled => "true"#分页条数jdbc_page_size => "50000"# 执行的sql 文件路径+名称#statement_filepath => "/data/my_sql2.sql"#SQL语句,也可以使用statement_filepath来指定想要执行的SQL#statement => "SELECT * FROM `user` where id > :sql_last_value"statement => "SELECT * FROM `user`"#每一分钟做一次同步schedule => "* * * * *"#是否将字段名转换为小写,默认true(如果有数据序列化、反序列化需求,建议改为false)lowercase_column_names => false# 是否记录上次执行结果,true表示会将上次执行结果的tracking_column字段的值保存到last_run_metadata_path指定的文件中;record_last_run => true# 需要记录查询结果某字段的值时,此字段为true,否则默认tracking_column为timestamp的值;use_column_value => true# 需要记录的字段,用于增量同步,需是数据库字段tracking_column => "id"# record_last_run上次数据存放位置;last_run_metadata_path => "E:\\JavaSoftWare\\ES\\logstash-7.6.2\\sql_last_value"#是否将字段名转换为小写,默认true(如果有数据序列化、反序列化需求,建议改为false)clean_run => false}
}filter {json {source => "message"remove_field => ["message"]}mutate {remove_field => ["@timestamp","@version"]}
}output {elasticsearch {# 配置ES集群地址hosts => ["127.0.0.1:9201","127.0.0.1:9202","127.0.0.1:9203"]# 索引名字,必须小写index => "logstash-test"#数据唯一索引(建议使用数据库KeyID)document_id => "%{id}"}stdout {}
}
执行命令:
./logstash -f ../conf/logstash-test-log-sync.conf
下面是我执行过程中遇到的报错日志,以及解决方法,逐一列出,希望对诸君有用。

public class ESGlobalSearch implements Serializable {/*** ID,唯一字段*/@Id@Field(type= FieldType.Keyword,store = true)private String id;/*** 主题(搜索关键字)*/@Field(type = FieldType.Text,store = true,analyzer = "ik_max_word",searchAnalyzer = "ik_max_word")private String title;/*** 主题副本(提高搜索精度)*/@Field(type = FieldType.Text,store = true,analyzer = "standard")private String roughTitle;/*** 标签(预留字段,搜索扩展)*/@Field(type = FieldType.Text,store = true,analyzer = "ik_max_word",searchAnalyzer = "ik_max_word")private String label;/*** 内容(预留字段)*/@Field(type = FieldType.Text,store = true,analyzer = "ik_max_word",searchAnalyzer = "ik_max_word")private String content;/*** 应用类型(1.医生;2.医院;3.应用)*/@Field(type = FieldType.Integer,store = true)private Integer applicationType;/*** 应用类型信息*/@Field(type = FieldType.Text,store = true)private String applicationInfo;
}
public interface ESGlobalSearchMapper extends ElasticsearchRepository {/*** 根据标题检索* @param title* @param roughTitle* @return*/List findByTitleOrRoughTitle(String title, String roughTitle);
}
@SpringBootTest(classes = EsApplication.class)
@RunWith(SpringRunner.class)
public class EsGlobalSearchTest {@AutowiredESGlobalSearchMapper esGlobalSearchMapper;@Testpublic void saveTest(){ESGlobalSearch esGlobalSearch = new ESGlobalSearch();esGlobalSearch.setApplicationInfo("1");esGlobalSearch.setApplicationType(1);esGlobalSearch.setContent("测试Content");esGlobalSearch.setId("1");esGlobalSearch.setLabel("测试Label");esGlobalSearch.setRoughTitle("测试");esGlobalSearch.setTitle("测试title");ESGlobalSearch save = esGlobalSearchMapper.save(new ESGlobalSearch());}@Testpublic void findAllTest(){Iterable iter = esGlobalSearchMapper.findAll();for (ESGlobalSearch esGlobalSearch : iter) {System.out.println(esGlobalSearch);}}/*** 它可以根据名称,自动实现功能*/@Testpublic void findByTitleOrRoughTitle(){List list = esGlobalSearchMapper.findByTitleOrRoughTitle("张", "张");for (ESGlobalSearch esGlobalSearch : list) {System.out.println(esGlobalSearch);}}/*** 基本查询*/@Testpublic void testQuery(){// 词条查询MatchQueryBuilder queryBuilder = QueryBuilders.matchQuery("title", "周国岭");//执行查询Iterable items = this.esGlobalSearchMapper.search(queryBuilder);items.forEach(item -> System.out.println(item));}@Testpublic void testFuzzyQuery(){NativeSearchQueryBuilder queryBuilder = new NativeSearchQueryBuilder();queryBuilder.withQuery(QueryBuilders.fuzzyQuery("title","杭州"));Page page = this.esGlobalSearchMapper.search(queryBuilder.build());List list = page.getContent();list.forEach(esGlobalSearch -> System.out.println(esGlobalSearch));}/*** es分页处理*/@Testpublic void testNativeQuery2(){// 构建查询条件NativeSearchQueryBuilder queryBuilder = new NativeSearchQueryBuilder();// 添加基本的分词查询queryBuilder.withQuery(QueryBuilders.termQuery("title", "杭州"));queryBuilder.withQuery(QueryBuilders.matchAllQuery());// 初始化分页参数int page = 0;int size = 3;// 设置分页参数queryBuilder.withPageable(PageRequest.of(page, size));// 执行搜索,获取结果Page pages = this.esGlobalSearchMapper.search(queryBuilder.build());// 打印总条数System.out.println(pages.getTotalElements());// 打印总页数System.out.println(pages.getTotalPages());// 每页大小System.out.println(pages.getSize());// 当前页System.out.println(pages.getNumber());List list = pages.getContent();list.forEach( esGlobalSearch -> System.out.println(esGlobalSearch));}/*** 排序*/@Testpublic void testSort(){NativeSearchQueryBuilder queryBuilder = new NativeSearchQueryBuilder();//查询全部queryBuilder.withQuery(QueryBuilders.matchAllQuery());// 初始化分页参数int page = 0;int size = 3;// 设置分页参数queryBuilder.withPageable(PageRequest.of(page, size));queryBuilder.withSort(SortBuilders.fieldSort("id").order(SortOrder.DESC));// 执行搜索,获取结果Page pages = this.esGlobalSearchMapper.search(queryBuilder.build());List list = pages.getContent();list.forEach( esGlobalSearch -> System.out.println(esGlobalSearch));}@Testpublic void testBooleanQuery() {NativeSearchQueryBuilder builder = new NativeSearchQueryBuilder();builder.withQuery(QueryBuilders.boolQuery().must(QueryBuilders.termQuery("title", "周国岭")).must(QueryBuilders.termQuery("roughTitle", "周国岭")));Page list = this.esGlobalSearchMapper.search(builder.build());for (ESGlobalSearch item : list) {System.out.println(item);}}
}
简介
spring data elsaticsearch提供了三种构建查询模块的方式:
基本的增删改查:继承spring data提供的接口就默认提供
接口中声明方法:**无需实现类。**spring data根据方法名,自动生成实现类,方法名必须符合一定的规则
接口只要继承 ElasticsearchRepository 类即可。默认会提供很多实现,比如 CRUD 和搜索相关的实现。类似于 JPA 读取数据。
支持的默认方法有:
count(), findAll(), findOne(ID), delete(ID), deleteAll(), exists(ID), save(DomainObject), save(Iterable)。
接口的命名是遵循规范的。常用命名规则如下:
表格内容摘自官网(官方文档:传送门)
关键字 | 方法命名 | Elasticsearch查询DSL语法示例 |
---|---|---|
And | findByNameAndPrice | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “?”, “fields” : [ “name” ] } }, { “query_string” : { “query” : “?”, “fields” : [ “price” ] } } ] } }} |
Or | findByNameOrPrice | { “query” : { “bool” : { “should” : [ { “query_string” : { “query” : “?”, “fields” : [ “name” ] } }, { “query_string” : { “query” : “?”, “fields” : [ “price” ] } } ] } }} |
Is | findByName | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “?”, “fields” : [ “name” ] } } ] } }} |
Not | findByNameNot | { “query” : { “bool” : { “must_not” : [ { “query_string” : { “query” : “?”, “fields” : [ “name” ] } } ] } }} |
Between | findByPriceBetween | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : ?, “to” : ?, “include_lower” : true, “include_upper” : true } } } ] } }} |
LessThan | findByPriceLessThan | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : null, “to” : ?, “include_lower” : true, “include_upper” : false } } } ] } }} |
LessThanEqual | findByPriceLessThanEqual | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : null, “to” : ?, “include_lower” : true, “include_upper” : true } } } ] } }} |
GreaterThan | findByPriceGreaterThan | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : ?, “to” : null, “include_lower” : false, “include_upper” : true } } } ] } }} |
GreaterThanEqual | findByPriceGreaterThan | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : ?, “to” : null, “include_lower” : true, “include_upper” : true } } } ] } }} |
Before | findByPriceBefore | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : null, “to” : ?, “include_lower” : true, “include_upper” : true } } } ] } }} |
After | findByPriceAfter | { “query” : { “bool” : { “must” : [ {“range” : {“price” : {“from” : ?, “to” : null, “include_lower” : true, “include_upper” : true } } } ] } }} |
Like | findByNameLike | |
StartingWith | findByNameStartingWith | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “?*”, “fields” : [ “name” ] }, “analyze_wildcard”: true } ] } }} |
EndingWith | findByNameEndingWith | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “*?”, “fields” : [ “name” ] }, “analyze_wildcard”: true } ] } }} |
Contains/Containing | findByNameContaining | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “?”, “fields” : [ “name” ] }, “analyze_wildcard”: true } ] } }} |
In (when annotated as FieldType.Keyword) | findByNameIn(Collectionnames) | { “query” : { “bool” : { “must” : [ {“bool” : {“must” : [ {“terms” : {“name” : [“?”,“?”]}} ] } } ] } }} |
In | findByNameIn(Collectionnames) | { “query”: {“bool”: {“must”: [{“query_string”:{“query”: “”?" “?”", “fields”: [“name”]}}]}}} |
NotIn | (when annotated as FieldType.Keyword) | findByNameNotIn(Collectionnames) { “query” : { “bool” : { “must” : [ {“bool” : {“must_not” : [ {“terms” : {“name” : [“?”,“?”]}} ] } } ] } }} |
NotIn | findByNameNotIn(Collectionnames) | {“query”: {“bool”: {“must”: [{“query_string”: {“query”: “NOT(”?" “?”)", “fields”: [“name”]}}]}}} |
Near | findByStoreNear | Not Supported Yet ! |
True | findByAvailableTrue | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “true”, “fields” : [ “available” ] } } ] } }} |
False | findByAvailableFalse | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “false”, “fields” : [ “available” ] } } ] } }} |
OrderBy | findByAvailableTrueOrderByNameDesc | { “query” : { “bool” : { “must” : [ { “query_string” : { “query” : “true”, “fields” : [ “available” ] } } ] } }, “sort”:[{“name”:{“order”:“desc”}}] } |
按接口的命名方法示例:
如 5.1.4
@SpringBootTest(classes = EsApplication.class)
@RunWith(SpringRunner.class)
public class EsXcCourseTest {@AutowiredElasticsearchTemplate elasticsearchTemplate;@Testpublic void createIndex(){// 创建索引,会根据Item类的@Document注解信息来创建boolean createFlag = elasticsearchTemplate.createIndex(EsXcCourse.class);System.out.println("####:"+createFlag);// 配置映射,会根据Item类中的id、Field等字段来自动完成映射elasticsearchTemplate.putMapping(EsXcCourse.class);}}
Data ElasticSearch 支持了一些常见的查询
但是一些高级查询呢?可以使用类组装DSL语法支持
/*** 聚合查询-groupBy* 聚合所有的年龄*/@Testpublic void groupByAge() {//1.构建查询对象NativeSearchQueryBuilder nativeSearchQueryBuilder = new NativeSearchQueryBuilder();nativeSearchQueryBuilder.addAggregation(AggregationBuilders.terms("groupByAge").field("age").size(30));SearchHits search = elasticsearchRestTemplate.search(nativeSearchQueryBuilder.build(), EmployeeInfo.class);Aggregations aggregations = search.getAggregations();//解析聚合分组后结果数据ParsedLongTerms parsedLongTerms = aggregations.get("groupByAge");//groupBy后的年龄集List ageList = parsedLongTerms.getBuckets().stream().map(Terms.Bucket::getKeyAsString).collect(Collectors.toList());System.out.println(ageList);}
/*** 分页查询* 带参数*/
@Test
public void listPageMatch() {int pageNo = 1;int pageSize = 5;NativeSearchQueryBuilder nativeSearchQueryBuilder = new NativeSearchQueryBuilder();nativeSearchQueryBuilder.withQuery(QueryBuilders.matchQuery("name", "小"));//注:Pageable类中 pageNum需要减1,如果是第一页 数值为0Pageable pageable = PageRequest.of(pageNo - 1, pageSize);nativeSearchQueryBuilder.withPageable(pageable);SearchHits searchHitsResult = elasticsearchRestTemplate.search(nativeSearchQueryBuilder.build(), EmployeeInfo.class);//7.获取分页数据SearchPage searchPageResult = SearchHitSupport.searchPageFor(searchHitsResult, pageable);System.out.println("分页查询");System.out.println(String.format("totalPages:%d, pageNo:%d, size:%d", searchPageResult.getTotalPages(), pageNo, pageSize));System.out.println(JSON.toJSONString(searchPageResult.getSearchHits(), SerializerFeature.PrettyFormat));
}
传送门
SpringBoot-starter-data整合Elasticsearch
org.elasticsearch elasticsearch 7.6.2 org.elasticsearch.client elasticsearch-rest-client 7.6.2 org.elasticsearch.client elasticsearch-rest-high-level-client 7.6.2
yml配置:
elasticsearch:hostlist: ${eshostlist:127.0.0.1:9201,127.0.0.1:9202,127.0.0.1:9203,} #多个结点中间用逗号分隔
配置类:
@Slf4j
@Configuration
public class ElasticsearchConfig {@Value("${elasticsearch.hostlist}")private String hostlist;@Beanpublic RestHighLevelClient restHighLevelClient(){//解析hostlist配置信息String[] split = hostlist.split(",");//创建HttpHost数组,其中存放es主机和端口的配置信息HttpHost[] httpHostArray = new HttpHost[split.length];for(int i=0;iString item = split[i];httpHostArray[i] = new HttpHost(item.split(":")[0], Integer.parseInt(item.split(":")[1]), "http");}//创建RestHighLevelClient客户端return new RestHighLevelClient(RestClient.builder(httpHostArray));}//项目主要使用RestHighLevelClient,对于低级的客户端暂时不用@Beanpublic RestClient restClient(){//解析hostlist配置信息String[] split = hostlist.split(",");//创建HttpHost数组,其中存放es主机和端口的配置信息HttpHost[] httpHostArray = new HttpHost[split.length];for(int i=0;iString item = split[i];httpHostArray[i] = new HttpHost(item.split(":")[0], Integer.parseInt(item.split(":")[1]), "http");}return RestClient.builder(httpHostArray).build();}
}
@RestController
@RequestMapping("/demo")
@Slf4j
public class DemoController {@AutowiredRestHighLevelClient restHighLevelClient;@RequestMapping("/test")public String test() throws IOException {// 1 创建检索请求SearchRequest searchRequest = new SearchRequest("xc_course");// 指定索引//searchRequest.indices("global_search_index");// 构造检索条件 DSLSearchSourceBuilder sourceBuilder = new SearchSourceBuilder();/*sourceBuilder.query(); 匹配查询sourceBuilder.from(); 分页查询 from 起始,size 尺寸sourceBuilder.size();sourceBuilder.aggregation(); 聚合*///全文检索//MatchQueryBuilder queryBuilder = QueryBuilders.matchQuery("name", "java");//精准搜索//TermQueryBuilder queryBuilder = QueryBuilders.termQuery("name", "java");TermQueryBuilder queryBuilder=QueryBuilders.termQuery("studymodel","201002");sourceBuilder.query(queryBuilder);System.out.println(sourceBuilder.toString());searchRequest.source(sourceBuilder);// 2 执行检索SearchResponse response = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);// 3 分析响应结果System.out.println("========:"+response.toString());return response.toString();}@RequestMapping("/test2")public String test2() throws IOException {// 1 创建检索请求SearchRequest searchRequest = new SearchRequest("xc_course");// 指定索引//searchRequest.indices("global_search_index");// 构造检索条件 DSLSearchSourceBuilder sourceBuilder = new SearchSourceBuilder();//TermQueryBuilder queryBuilder=QueryBuilders.termQuery("studymodel","201002");MatchAllQueryBuilder queryBuilder = QueryBuilders.matchAllQuery();sourceBuilder.query(queryBuilder);System.out.println(sourceBuilder.toString());searchRequest.source(sourceBuilder);// 2 执行检索SearchResponse response = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);// 3 分析响应结果System.out.println("========:"+response.toString());return response.toString();}@RequestMapping("/test3")public String test3() throws IOException {// 1 创建检索请求SearchRequest searchRequest = new SearchRequest("logstash-test");// 指定索引//searchRequest.indices("global_search_index");// 构造检索条件 DSLSearchSourceBuilder sourceBuilder = new SearchSourceBuilder();//TermQueryBuilder queryBuilder=QueryBuilders.termQuery("studymodel","201002");MatchAllQueryBuilder queryBuilder = QueryBuilders.matchAllQuery();sourceBuilder.query(queryBuilder);System.out.println(sourceBuilder.toString());searchRequest.source(sourceBuilder);// 2 执行检索SearchResponse response = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);// 3 分析响应结果System.out.println("========:"+response.toString());return response.toString();}
}
传送门
参考文章
elasticsearch-rest-high-level-client操作