Oct 4, 2013. Sphinx and MariaDB

The MariaDB Knowledgebase already provides a nice overview of how to enable SphinxSE on MariaDB. Here, we don’t want to repeat what has already been said, but we do want to briefly inform our community that, as of MariaDB 5.2.2, the Sphinx storage engine is included in the source, binaries, and packages of MariaDB. 

Why should you care?

The MariaDB Knowledgebase puts forward these three reasons:

  • easier porting of MariaDB/MySQL FTS applications to Sphinx
  • allowing Sphinx use with programming languages for which native APIs are not yet available
  • optimizations when additional Sphinx result set processing on the MariaDB side is required (eg. JOINs with original document tables, additional MariaDB-side filtering, and etc…)

Other Resources: Presentations, Podcasts, and Videos

Colin Charles, with MariaDB, posted slides from a presentation he gave about SphinxSE and MariaDB. The MariaDB Knowledgebase contains more detailed information, but some of you may enjoy looking at these slides. Here are some of his main points:

  • SphinxSE doesn’t actually store any data. SphinxSE is a built-in client which allows MariaDB to talk to Sphinx search daemon (run queries, obtain results). Indexing and searching is performed by Sphinx.
  • Two potential uses are presented:
    • If you have an existing application that makes use of fulltext search in MyISAM, porting should be easy.
    • If you’re using a programming language that Sphinx has no native API for, integration will be easy using MariaDB/SphinxSE.
  • Colin discusses the types of queries that are supported.
  • And he tells us that you should let Sphinx perform the sorting, filtering and slicing of the result set because Sphinx optimizes and performs better on these tasks.

And, in episode 108 of OurSQL (the MySQL community podcast), Sphinx is introduced and some benefits of using SphinxSE with MariaDB are discussed. They also provide a link to a video, “Why MariaDB?”. SkySQL’s Kaj Arnö chairs this discussion with Colin Charles, Rasmus Johansson and Sergei Golubchik; where they talk about MariaDB, and why it makes sense to move from the MySQL database to MariaDB in your production environment. Listen and watch to learn more!

While much of this may not be news to many of you (all of this information exists elsewhere), we hope the resources we’ve listed above will help to give you a general idea of the benefits of using Sphinx with MariaDB. And, as usual, if you have any questions, feel free to ask in the comments below.

« »

Leave a Reply