On 30 Mar 2010, at 07:54, ayman bs wrote:

Alright, could you please give an approximation of the difficulty of the task?

Any prerequisites other than C++?

I didn't find the contact details of the persons who worked on the same plugin for MySQL, do you know any?

A talk with the sphinx developers would surely be helpful,

Start here http://sphinxsearch.com/

Of course looking at the MySQL sphinxse plugin would be helpful as well.

The sphinxse plugin takes the search query as a sort of comment to the request for rows from the "table"

Wether or not the drizzle team is happy with this method is up to them.

So in the MySQL implementation of sphinxse the "table" is really more a less an interface to sphinx index.

It works and it works well... but it felt a little like a stretch to call it a storage engine.

Do not get me wrong I like it.. we indexed mysql tables in sphinx and then get access to that index through a "table" so the feature is very nice.

In addition recent developments in SPhinx I believe have the sphinx server searchd, responding to the MySQL protocol.. so there may be more than one way to go about the drizzle implementation of the sphinxse.


--
Tom




On Tue, Mar 30, 2010 at 1:56 AM, Stewart Smith <[email protected] > wrote: On Mon, 29 Mar 2010 16:29:45 -0700, Eric Day <[email protected]> wrote:
> Hey! I'm CC'ing the main drizzle mailing list so other folks can
> comment. You should probably subscribe to it too.
>
> On Tue, Mar 30, 2010 at 01:22:47AM +0200, ayman bs wrote:
> > I have already a familiarity with both drizzle and Sphinx, but I have
> >    never dived into the code level.
> >
> > I would like to know from your point of view the biggest challenges that
> >    might face me in the porting phase...
>
> I'm not as familiar with all the SE interface changes as the other
> developers, so I'll let them comment on the specifics.

DDL: completely different.
transactions: completely different: we (mostly) have
startTransaction/endTransaction and friends
Glue (the bits for registering a plugin/storage engine etc): completely
different.

the rnd_init,rnd_next,index_init bits.... pretty similar unfortunately.

--
Stewart Smith

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Tom Hanlon
[email protected]
Cloudera Certified Hadoop Developer
Certified MySQL DBA


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to