使用弹性搜索索引Mysql数据库 [英] Indexing Mysql Database with elasticsearch

问题描述

我最近开始在ElasticSearch中查找我的
应用程序。我有我的数据库在Mysql有大约。 > 2 mn
记录。我知道在狮身人面像中，我们可以直接在任何
mysql表列上创建一个索引。我想知道它是否可能在Elasticsearch，
如果不直接我们如何实现？

I recently started looking ElasticSearch to implement search in my application. I have my database in Mysql which have approx. >2 mn records. I know in sphinx we could create an index directly on any mysql table column. I wanted to know if its possible in Elasticsearch, if not directly how we could implement that?

感谢
Mohit

Thanks Mohit

推荐答案

https：// github.com/jprante/elasticsearch-river-jdbc 这样做。您可以使用操作表来同步来自mysql源的数据。

https://github.com/jprante/elasticsearch-river-jdbc does that. You can syncronize data from mysql source, using an "operations table".

它第一次安装有点棘手，但它的工作原理。

It,s a little bit tricky first time installing, but it works.

首先您必须安装插件
其次，您必须设置（配置）导入的数据

First you have to install the plugin Second, you have to set up ( configure) the imported data

这篇关于使用弹性搜索索引Mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！