SOLR simple integration with MySQL

The integration of SOLR and MySQL databases enables the creation of full-scale indexes and incremental indexes.
The rationale is simple: Register SOLR's Dataimporthandler in the SOLR project and configure the MySQL data source and the data query SQL statement. When we use the SOLR background control page or directly access an address (given later), SOLR invokes Dataimporthandler, connects to the database, queries the data based on the SQL statement, and creates the index.

Example SOLR version: solr4.3.1
Contract the installation directory of SOLR, such as E:\environment\solr-4.3.1 for Solr-home.

1. Copy the jar package
Copy the jar containing the Dataimporthandler and the MySQL database driver package to the Solr-home/dist directory. By default, the two jar packages required for Dataimporthandler already exist in this directory. The name of the jar package for the SOLR version is: Solr-dataimporthandler-4.3.1.jar, Solr-dataimporthandler-extras-4.3.1.jar

2. Modify the Solr-home\example\solr\collection1\conf\solrconfig.xml file
A. Add the required jar-Package reference configuration:

HTML code

1. <Lib dir=". /.. /.. /dist/" regex="solr-dataimporthandler-.*\.jar " />
2. <Lib dir=". /.. /.. /dist/" regex="mysql-connector-java-.*\.jar " />

B. Add Resulthandler Configuration

HTML code

2. <requesthandler name="/dataimport"
4. class="Org.apache.solr.handler.dataimport.DataImportHandler">
6. <lst name="Defaults">
8. <str name="config">data-config.xml</str>
10. </lst>
12. </requesthandler>

3. Create the Data-config.xml file in the Solrconfig.xml's sibling directory, configure the database connection and SOLR's correspondence with MySQL data and query statements.

HTML code

2. <dataconfig>
4. <dataSource type="Jdbcdatasource" driver="Com.mysql.jdbc.Driver "
6. url="Jdbc:mysql://127.0.0.1/dbname" user="root" password="root"/>
8. <document name="Search_object">
10. <entity name="talent"
12. query= "SELECT ID, Gender, QQ, MSN, Anualsalary, UpdateTime, Adduserid
14. From talent ">
16. <field column= "anualsalary" name="Salary"/>
18. <field column="Adduserid" name= "userId"/>
22. <!--Talent names-->
24. <entity name="Talent_name" query="Select value from Talentname where talentid= ' ${ Talent.id} ' ">
26. <field column="value" name="name"/>
28. </Entity>
30. </Entity>
32. </Document>
34. </dataconfig>

4. Restart SOLR.
Bulk Import (Full-import):
Http://
Incremental import (Delta-import):
Http://
Import State Query (status):
Http://
Reload configuration file (Reload-config):
Http://
Terminate import (Abort):
Http://

SOLR simple integration with MySQL