Solr search with Mysql Database, any utility for d

问题:

We are looking at ways of improving "search" functionality in our large business application which currently uses SQL Like syntax to do it. So we started evaluating Solr server and were able to index few of our database tables and search. But I am newbie and wanted to know if

1) We have large number of tables in our application. Is there any utility that generates schema xml in solr using the database tables?

2) Our current search lists the database row that meets the search criteria (this was written using SQL 'like' and takes lot of time to generate the search results). We want to simulate the exact functionality using solr. Is that possible?

回答1:

For importing a database into SOLR, you might want to look into DataImportHandler.

There will be a fair amount of configuration required for it, defining what tables and columns to import, what should be stored, and how it should be indexed.