[Solr6.2.1 self learning 1]solr 6.2.1 dataimport configuration for MySQL

Talk is cheap, show me the process

A. modify solrconfig.xml to include data import requestHanlder

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

        <lst name="defaults">

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

        </lst>

    </requestHandler>

B. create data import config file data-config.xml

<dataConfig>

    <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1:3306/dbname" user="root" password="1234"/>

    <document name="sheetDoc">

        <entity name="collasheet" pk="id" query="select * from collaboration_sheet" >

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

            <field column="sheet_data" name="data"/>

        </entity>

    </document>

</dataConfig>

C. copy necessary libs to $SOLR_HOME\server\solr-webapp\webapp\WEB-INF\lib

          1.MySQL  connector driver

               mysql-connector-java-5.1.39.jar     

          2.solr data import hanlder driver

               solr-dataimporthandler-6.2.1.jar          from $SOLR_HOME\dist

               solr-dataimporthandler-extras-6.2.1     from $SOLR_HOME\dist

D. Important  modify $SOLR_HOME\server\solr\mq\conf\managed-schema to add fileds to match fields definition in data-config.xml 

       <field name="id" type="string" indexed="true" stored="true"/>

       <field name="data" type="text_cjk" indexed="true" stored="true"/>

          

E. Restart solr, in solr admin navigate to dataimport

     1.select the configed entity name

     2.click excute & wait for the output

By now, you can import data from MySQL into solr for indexing...

To Improve

     1.Analyzer\tokenizer\Filter configuration for text fields