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...
