Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6332

sphinx:// support for federated

        Details

          Description

          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

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link original email thread

                  Activity

                  Hide
                  Permalink
                  shadowconnect Markus Lidel added a comment -

                  The patch is released under the MCA.

                  Show
                  shadowconnect Markus Lidel added a comment - The patch is released under the MCA.

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      serg Sergei Golubchik
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated: