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

sphinx:// support for federated

    XMLWordPrintable

    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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: