Percolate Queries: docs_id option
In this article we discuss the docs_id option which provides an easier manipulation of CALL PQ result set.
Let’s consider the following PQ batch call:
mysql> CALL PQ ('pq', ('{"title":"butter is good as", …
Using ProxySQL to route INSERTs in a distributed RealTime index
In this article we’ll discuss a how-to use ProxySQL to route inserts to a distributed RT index while using Sphinx/Manticore Search.
The distributed index in Manticore allow UPDATE over multiple RealTime indexes as the UPDATE is sent to all …
Manticore Search 2.7.0 GA release
We are pleased to announce the release of Manticore Search 2.7.0 GA.
Prebuilt packages available for Debian,Ubuntu, Red Hat/CentOS, Windows and OSX can be downloaded from here. For Docker image check official repository.
Internal …
Scripting in config
Did you know that Sphinx and Manticore Search configs allow you to do scripting by using shebang syntax? Here is an example of how useful it can be in some cases:
Imagine you have 3 tables with identical structure that you would like to …
Dictionary types: CRC vs keywords
In this article we’ll discuss differences between the two dictionary types available in Manticore Search.
dictionary is an index component that stores indexed words. The first indexes used the ‘crc’ dictionary type, in which words are …
From SphinxSE to FEDERATED
In this article we discuss the differences between using SphinxSE and FEDERATED engine with Manticore Search
The SphinxSE MySQL plugin was made available since the first public release of Sphinx Search. The idea was to allow users to …