在MySQL上使用Solr

本文介绍了在MySQL上使用Solr的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我在这里浏览有关MySQL和多面搜索的一些问题，并且看到一个建议使用Solr的响应.

I was browsing some questions here concerning MySQL and faceted searches and I saw one response that suggested the use of Solr.

在我的MySQL数据库中，我有许多用于产品，供应商，消息，用户等的表-都是相互关联的.我将如何使用Solr进行产品的多面搜索?据我了解，我将不得不继续从MySQL获取Solr产品数据-但是如何处理数据索引呢?添加新产品后是否立即建立索引?我可以批量索引吗?如何处理Solr准确表示在MySQL数据库中找到的数据? (插入，删除等)

In my MySQL database, I have many tables for products, suppliers, messages, users, etc - all interconnected. How would I use Solr to do faceted searches for products? From what I understand, I'd have to keep feeding Solr product data from MySQL - but how do I deal with indexing the data? Do index right after adding a new product? Do I batch index? How do I deal with Solr accurately representing data that is found in my MySQL database? (inserts, deletes, etc)

谢谢.

推荐答案

看看数据导入处理程序.除了批量更新，您还可以通过调用更新请求处理程序来触发更新.您必须从应用程序中调用它，但是您也可以创建自己的自定义更新请求处理程序，以满足您的需求.

Take a look at data import handler. Apart from batch update you can also trigger update by calling update request handler. You would have to call it from your application but you can also create your own custom update request handler that would fit your needs.