April 19, 2009

Talking MySQL to Sphinx

Posted by peter |

In the recently released Sphinx version 0.9.9-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently in its early preview stage but it is still fun to play with.

A thing to mention – unlike MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL – it is implementation of the wire protocol from scratch.

For this test I was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries, not using Full Text Search.
[read more...]

October 13, 2008

Percona’s patches spread to a wider audience

Posted by Baron Schwartz |

Percona’s patches are now available to a wider audience via OurDelta, a community effort to provide  builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is really the brainchild behind this. Kudos Arjen!

What does this mean for the Percona patches? Well, now you can get them in more places.  But it doesn’t change our own commitment to keep innovating in ways our customers (and we ourselves) find useful.  We’re still building our own builds and hosting the downloads from our own website; it’s important that you can get a build that you know authoritatively came from us and was built by us.  The Percona patches and builds represent our best judgment about what’s the state of the art in the MySQL server for real-world usage, and we have no plans to change that.

[read more...]