[Jjzhu learn Java] solr4.9 sync mysql data

SOLR is a high performance, JAVA5 developed, Lucene-based full-text Search server. At the same time, it has been extended to provide a richer query language than Lucene, which is configurable, extensible, and optimized for query performance at the same time, and provides a good functional management interface, an excellent full-text search engine.

The ability to import data from a database into SOLR, and for millions data to respond to queries at high speed.

1. Installing the JDK

JDK version number requires more than 1.7

2. Installing SOLR

Download SOLR compression Pack and unzip the installation package. Go to the Solr_home\example folder, execute the command java–jar start.jar start SOLR

SOLR default port is 8983, Access HTTP://LOCALHOST:8983/SOLR, if you have such as the following interface, the start of success

3. Import and update data-related configuration

SOLR provides the ability to import database data into the SOLR Index Library (dataimport)

3.1. Download the database driver package

Download the MySQL driver package. And put it under the {%solr_home%}contrib\dataimporthandler\lib folder

3.2. Configuring solrconfig.xml3.2.1, referencing related libraries

The solrconfig.xml includes most of the parameters used to configure the behavior of itself, which is scoped to the current core. Location in the Files folder the file is located under {%solr_home%} example\solr\collection1\conf.

The data import needs to reference the MySQL driver package and the package required by the DataImport.

Include in the file such as the following:

<libdir= ". /.. /.. /contrib/dataimporthandler/lib "regex=". *\.jar "/>

<lib dir= ". /.. /.. /dist/"regex=" Solr-dataimporthandler-\d.*\.jar "/>

3.2.2, Configuration RequestHandler

Add for example the following configuration in Solrconfig.xml:

<requesthandlername= "/dataimport" class= "Org.apache.solr.handler.dataimport.DataImportHandler" >

<lst name= "Defaults" >

<str name= "config" >data-config.xml</str>

</lst>

</requestHandler>

3.3, Configuration Schema.xml

Schema.xml has the flexibility to configure different types of fields in the same location as the Solrconfig.xml peers.

Importing data requires configuring a type that is consistent with the fields in the database, in the configuration file

3.3. Configure the data source

Under the Solrconfig.xml Sibling folder ({%solr_home%}example\solr\collection1\con), establish a data profile data-config.xml with the same name as the configuration in 3.2.2,

and add for example the following content

<dataConfig>

<!--driver: Database driver name

URL: Database path

User: Database Users

Password: Database password

BatchSize: Prevents memory overflow during import of data

-

<datasource type= "Jdbcdatasource"

Driver= "Com.mysql.jdbc.Driver"

Url= "Jdbc:mysql://localhost/exercise"

User= "Root"

Password= ""

Batchsize= "-1"/>

<document>

<!--the tables to be imported, you can configure multiple

and query the fields to be indexed

-

<entity name= "CustomerInfo" query= "Selectcustomerid,customername,pid,telephone from CustomerInfo" >

<field column= "CustomerID" name= "id"/>

<field column= "CustomerID" name= "CustomerID"/>

<field column= "CustomerName" name= "CustomerName"/>

<field column= "pid" name= "pid"/>

<field column= "Telephone" name= "Telephone"/>

</entity>

</document>

</dataConfig>

4. Import data

Access to the SOLR interface

Command Select Full-import,entity Select the table to import, then click Execute to import the data

After completion, you will be prompted to complete the index.

Then, in the query interface can enter the relevant query criteria for querying

[Jjzhu learn Java] solr4.9 sync mysql data