Index MySQL datadase table in Solr


Prerequisites

Download the following jars.

1. MySQL jar

2. Solr Data Import Handler jar

Data Configuration File

Create a data-config.xml file in conf folder & add following content to it.

<dataConfig>

    <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://<host>:<port>/<database name>" user="<user>" password="<password>" batchSize="1" />

    <document name="userdoc">

        <entity name="userentity" query="select ID, FIRST_NAME, LAST_NAME from users">

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

            <field column="first_name" name="FIRST_NAME" />

            <field column="last_name" name="LAST_NAME" />

        </entity>

    </document>

</dataConfig>

Solr Configuration File

Add following content to solr-config.xml

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

    <lst name="defaults">

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

    </lst>

</requestHandler>

Schema File

Add following fields to schema.xml

<field name="first_name" type="string" indexed="true" />

<field name="last_name" type="string" indexed="true" />

Final Steps

Following steps are to be performed for starting the import.

1. Create lib folder in instance folder & copy downloaded jars in it.

2. Restart solr server.

3. Select target core.

4. Goto Data Import option.

5. Select Full Import.

6. Check Commit.

7. Click Execute.

Cheers!!

Comments

Post a Comment

Popular posts from this blog

Hibernate Sharding Example

It is a simple implementation of Hibernate Sharding in java. In this we are using two databases i.e. shard1 and shard2. All data related to "India" goes to shard1 where as others go to shard2. Project Contents: File Name Use DatabaseCreator.java Used to create tables in databases named shard1 and shard2. User.java POJO class. User.hbm.xml Mapping file. Used to map POJO to database tables. hibernate0.cfg.xml Hibernate configuration file for database named shard1 hibernate1.cfg.xml Hibernate configuration file for database named shard2 IdGenerator.java Class for Id generation HibernateShardUtil.java Class for loading hiberante session factory. UserShardResolutionStrategy.java Class for implementing shard resolution strategy. UserShardSelectionStrategy.java Class for implementing shard selection strategy. Main.java Clie...
Read more

Shallow Copy

In Shallow copy all the fields are just copied from source object to destination object. If the source object is containing any field that holds a reference to another object then only the reference will be copied i.e. source and destination objects field(that particular field) will point to same memory location. Java code for Shallow Copy package shallow; class JobDescription {     private String designation;     public JobDescription(String designation) {         this.designation = designation;     }     public String getDesignation() {         return designation;     }     public void setDesignation(String designation) {         this.designation = designation;     }     @Override     public String toString() {...
Read more