Remote MySQL Server v. 2.0
This article is based on the Sphinx talk from MySQL UC 2008. It is not a verbatim transcription but pretty close to it.
What’s Sphinx?
- FOSS full-text search engine
- Specially designed for indexing databases
- Integrates well with MySQL
- Provides greatly improved full-text search
- Sometimes, can improve non-full-text queries
- By more efficient processing (in some cases)
- By distributed processing on a cluster (in all)
- Details later in this talk
Sphinx is a free, open-source full-text search engine that was designed from ground up for indexing the content stored in local databases. Sphinx can pull the data from many different databases, but it ties especially well with MySQL. It offers a number of improvements compared to MySQL’s built- in full-text indexes; but what’s interesting, in some special cases it can also improve general purpose, non-full-text SELECT queries. It manages to do so either by processing the queries more efficiently than MySQL, or by distributing the load across the cluster of Sphinx nodes, or by combining both. We’ll return to that in the second part of the talk.
