MariaDB和Elasticsearch

Question

我最近一直在MySQL上使用elasticsearch，没有任何问题。我的服务器最近从MySQL迁移到了MariaDB，而现在JDBC这条河似乎已经冻结了，即使是最基本的同步也是如此。有人知道它们是否兼容吗？

下面是一个示例代码：

PUT /_river/my_jdbc_river/_meta
{
    "type" : "jdbc",
    "jdbc" : {
        "url" : "jdbc:mysql://HOST/DATABASE",
        "user": "username",
        "password": "password",
        "sql" : "select * from table"
    }
}

它只挂起以下几点：

[2014-05-19 16:11:49,080][INFO ][cluster.metadata         ] [Wade Wilson] [_river] update_mapping [my_jdbc_river] (dynamic)
[2014-05-19 16:11:49,082][INFO ][org.xbib.elasticsearch.river.jdbc.JDBCRiver] [Wade Wilson] [jdbc][my_jdbc_river] starting JDBC river: URL [jdbc:mysql://HOST/DATABASE], strategy [simple], index/type [jdbc/jdbc]
[2014-05-19 16:11:49,083][INFO ][org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth] waiting for cluster state YELLOW
[2014-05-19 16:11:49,083][INFO ][org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverMouth] ... cluster state ok
[2014-05-19 16:11:49,094][INFO ][cluster.metadata         ] [Wade Wilson] [_river] update_mapping [my_jdbc_river] (dynamic)
[2014-05-19 16:11:49,113][INFO ][cluster.metadata         ] [Wade Wilson] [_river] update_mapping [my_jdbc_river] (dynamic)

Answer 1

下载MariaDB的“连接器”：

https://mariadb.com/kb/en/about-the-mariadb-java-client/

Answer 2

从https://downloads.mariadb.org/client-java/1.1/下载mariadb-java-client-1.1.7.jar

它们将mariadb-java-client-1.1.7.jar移动到/your_path_to_elasticsearch/plugins中，如下所示：

> [root@SpaceConnection elasticsearch-1.3.4]# ll plugins/jdbc/
> -rw-r--r-- 1 root root 280826 Oct 16 22:03 elasticsearch-river-jdbc-1.3.4.0.jar
> -rw-r--r-- 1 root root    380 Oct 16 22:03 log4j2.xml
> -rw-r--r-- 1 root root    234 Oct 16 22:03 log4j.properties
> -rw-r--r-- 1 root root 230704 Mar 29  2014 mariadb-java-client-1.1.7.jar

然后运行bin/elasticsearch

[2014-10-16 23:34:41,712][INFO ][node                     ] [Apache Kid] version[1.3.4], pid[15632], build[a70f3cc/2014-09-30T09:07:17Z]
[2014-10-16 23:34:41,712][INFO ][node                     ] [Apache Kid] initializing ...
[2014-10-16 23:34:41,734][INFO ][plugins                  ] [Apache Kid] loaded [jdbc-1.3.4.0-e13884c], sites []
OpenJDK Server VM warning: You have loaded library /var/www/html/bibi.baonam/elasticsearch-1.3.4/lib/sigar/libsigar-x86-linux.so which might have disabled stack guard. The VM will try to fix the stack guard now.
It's highly recommended that you fix the library with 'execstack -c <libfile>', or link it with '-z noexecstack'.
[2014-10-16 23:34:45,060][INFO ][node                     ] [Apache Kid] initialized
[2014-10-16 23:34:45,060][INFO ][node                     ] [Apache Kid] starting ...
[2014-10-16 23:34:45,195][INFO ][transport                ] [Apache Kid] bound_address {inet[/0:0:0:0:0:0:0:0:9300]}, publish_address {inet[/118.69.197.136:9300]}
[2014-10-16 23:34:45,225][INFO ][discovery                ] [Apache Kid] elasticsearch/rn5hDK2YTCKsC53RKt5MMg
[2014-10-16 23:34:48,244][INFO ][cluster.service          ] [Apache Kid] new_master [Apache Kid][rn5hDK2YTCKsC53RKt5MMg][SpaceConnection][inet[/118.69.197.136:9300]], reason: zen-disco-join (elected_as_master)
[2014-10-16 23:34:48,286][INFO ][http                     ] [Apache Kid] bound_address {inet[/0:0:0:0:0:0:0:0:9200]}, publish_address {inet[/118.69.197.136:9200]}
[2014-10-16 23:34:48,288][INFO ][node                     ] [Apache Kid] started
[2014-10-16 23:34:49,087][INFO ][gateway                  ] [Apache Kid] recovered [2] indices into cluster_state

注:第3行: 2014-10-16 23:34:41,734插件已加载jdbc-1.3.4.0-e13884c，sites []

当然，在安装之前，必须在https://github.com/jprante/elasticsearch-river-jdbc#how-to-start-the-jdbc-river中逐步安装