使用 Solr 索引 MySQL 数据

环境搭建

1、到apache下载solr，地址：http://mirrors.hust.edu.cn/apache/lucene/solr/

2、解压到某个目录

3、cd into D:\Solr\solr-4.10.3\example

4、Execute the server by “java -jar startup.jar”Solr会自动运行在自带的Jetty上

5、访问http://localhost:8983/solr/#/

PS：solr-5.0 以上默认对schema的管理是使用managed-schema，不能手动修改，需要使用Schema Restful的API操作。如果要想手动修改配置，把managed-schema拷贝一份修改为schema.xml，在solrconfig.xml中修改如下：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

<!-- <schemaFactory class = "ManagedIndexSchemaFactory" >      <bool name= "mutable" > true </bool>      <str name= "managedSchemaResourceName" >managed-schema</str>    </schemaFactory> -->     <!-- <processor class = "solr.AddSchemaFieldsUpdateProcessorFactory" >        <str name= "defaultFieldType" >strings</str>        <lst name= "typeMapping" >          <str name= "valueClass" >java.lang.Boolean</str>          <str name= "fieldType" >booleans</str>        </lst>        <lst name= "typeMapping" >          <str name= "valueClass" >java.util.Date</str>          <str name= "fieldType" >tdates</str>        </lst>        <lst name= "typeMapping" >          <str name= "valueClass" >java.lang.Long</str>          <str name= "valueClass" >java.lang.Integer</str>          <str name= "fieldType" >tlongs</str>        </lst>        <lst name= "typeMapping" >          <str name= "valueClass" >java.lang.Number</str>          <str name= "fieldType" >tdoubles</str>        </lst>      </processor> -->          <schemaFactory class = "ClassicIndexSchemaFactory" />

创建MySQL数据

DataBase Name: mybatis

Table Name: user

Db.sql

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

SET FOREIGN_KEY_CHECKS= 0 ; -- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `user`;   CREATE TABLE `user` (    `id` int ( 11 ) NOT NULL AUTO_INCREMENT,    `userName` varchar( 50 ) DEFAULT NULL,    `userAge` int ( 11 ) DEFAULT NULL,    `userAddress` varchar( 200 ) DEFAULT NULL,    PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT= 6 DEFAULT CHARSET=utf8;   -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ( '1' , 'summer' , '30' , 'shanghai' ); INSERT INTO `user` VALUES ( '2' , 'test1' , '22' , 'suzhou' ); INSERT INTO `user` VALUES ( '3' , 'test1' , '29' , 'some place' ); INSERT INTO `user` VALUES ( '4' , 'lu' , '28' , 'some place' ); INSERT INTO `user` VALUES ( '5' , 'xiaoxun' , '27' , 'nanjing' );

使用DataImportHandler导入并索引数据

1） 配置D:\Solr\solr-4.10.3\example\solr\collection1\conf\solrconfig.xml

在<requestHandler name=”/select” class=”solr.SearchHandler”>前面上加上一个dataimport的处理的Handler

1 2 3 4 5

<requestHandler name= "/dataimport" class = "org.apache.solr.handler.dataimport.DataImportHandler" > 　　     <lst name= "defaults" > 　　        <str name=