Connecting MariaDB to Sphinx

Mroonga is a new full-text search engine, and the main goal is to support the CJK languages. Until now, the most-used search engine is probably Sphinx, which has a lot of features, allows you to perform very complex queries, and performs better than the other full-text search engines.

Sphinx is a full-text search engine designed to provide better performance and relevance than the standard full-text search features shipped by default with a variety of DBMSs. Sphinx can be integrated directly with the SQL databases, or be queried directly from a script.

There are three different ways to use Sphinx. The first way is to use SphinxQL, a small SQL subset. The second is the native search API, SphinxAPI. And the last, which we will use in this chapter, is a MySQL pluggable storage engine, SphinxSE.

The key features of Sphinx are:

• High indexing and searching performance

• Advanced indexing and querying tools

• Advanced result set post-processing

• Proven scalability up to billions...