Review the patch for adding SphinxQL support to FederatedX:

From: Markus Lidel
To: maria-developers@lists.launchpad.net
Subject: Extendet FederatedX storage engine to support updating Sphinx RT indexes
Date: Tue, 28 May 2013 23:46:26 +0200

Hello,

the Sphinx Search engine has RT indexes, which could be updated with a subset
of SQL commands, refered to as SphinxQL:

http://sphinxsearch.com/docs/2.1.1/sphinxql-reference.html

Because the FederatedX storage engine uses some commands, which Sphinx does
not know, here is a patch, wich extends the FederatedX storage engine to
support this subset of commands. Now its possible to update Sphinx RT indexes
directly from MariaDB. To create a connection to the RT index in the Sphinx
default RT-index:

index rt

{

type = rt

path = @CONFDIR@/data/rt

rt_field = title

rt_field = content

rt_attr_string = title

rt_attr_string = content

rt_attr_uint = gid

}

you just have to call:

CREATE TABLE `rt` (

`id` BIGINT UNSIGNED NOT NULL,

`title` TEXT,

`content` TEXT,

`gid` INT UNSIGNED

) ENGINE=FEDERATED CONNECTION='sphinxql://root@localhost:9306/rt';

It would be great, if the attached patch could be integrated into MariaDB. If
you have any suggestions, please feel free to contact me.

Best regards,

Markus Lidel