Sphinx Configuration | Sphinx Search Beginner's Guide

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Sphinx Search Beginner's Guide

By : Abbas Ali

3.3 (4)

Sphinx Search Beginner's Guide

3.3 (4)

By: Abbas Ali

Overview of this book

Sphinx Search

Sphinx Search

Credits

Credits

About the Author

About the Author

Acknowledgement

Acknowledgement

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Setting Up Sphinx

Setting Up Sphinx

What you need to know

Different ways of performing a search

Sphinx—a full-text search engine

Installation

Time for action - installation on Linux

Time for action - installation on Windows

Time for action - installation on a Mac

Summary

Getting Started

Getting Started

Checking the installation

Full-text search

Time for action - normal search in MySQL

Overview of Sphinx

Time for action - Sphinx in action

Why use Sphinx for full-text searching?

Summary

Indexing

Indexing

What are indexes?

Index attributes

Data sources

Time for action - creating database tables for a blog

Time for action - populate the database tables

Time for action - creating the Sphinx configuration file

Time for action - adding attributes to the index

Time for action - Adding an MVA to the index

Time for action - creating index (without attributes)

Time for action - add attributes to schema

Time for action - create index with schema defined in configuration file

Summary

Searching

Searching

Client API implementations for Sphinx

Search using client API

Time for action - creating a basic search script

Time for action - searching with different matching modes

Time for action - searching using Boolean query syntax

Time for action - searching with extended query syntax

Filtering full-text search results

Time for action - filtering the result set

Weighting search results

Time for action - weighting search results

Sorting modes

Grouping search results

Summary

Feed Search

Feed Search

The application

Time for action - creating the MySQL database and tables

Time for action - setting up the feeds application

Time for action - creating a form to add feeds

Time for action - adding code to save feed

Time for action - create the index

Time for action - adding code to avoid duplicate items

Time for action - adding the delta index

Time for action - creating the search form

Time for action - adding code to perform a search query

Time for action - adding code to filter the results

Time for action - showing search form prefilled with last submitted data

Summary

Property Search

Property Search

The application

Time for action - creating the MySQL database and structure

Time for action - populating the database

Time for action - setting up the application

Time for action - creating the form to add property

Time for action - creating the index

Time for action - creating the simple search form

Time for action - adding code to perform full-text search

Time for action - creating the Advanced search form

Time for action - adding ranged filters

Time for action - creating the search form

Time for action - adding code to perform geo distance search

Summary

Sphinx Configuration

Sphinx Configuration

Sphinx configuration file

Data source configuration

Time for action - creating a configuration with advanced source options

Index configuration

Time for action - creating indexes for distributed searching

Time for action - adding distributed index configuration

Time for action - using morphology for stemming

Search daemon configuration

Indexer configuration

Summary

What Next?

What Next?

SphinxQL

Time for action - querying Sphinx using MySQL CLI

Use case scenarios

Popular websites using Sphinx

Summary

Data source configuration

The source section is used to define the data source in the configuration file. We learned about data sources in Chapter 3, Indexing. Now let's see different configuration options that can be specified in the source section of the configuration file.

Note

In this chapter, we will only see those options that are used more often than others and were not already covered in earlier chapters. For complete reference please visit http://sphinxsearch.com/docs/manual-0.9.9.html#conf-reference.

SQL related options

We have already seen how to use the basic options; such as sql_host, sql_user, sql_pass, and sql_db. There are a few more options that you may need sooner or later.

Connection options

The following options can be used to establish the database connection.

sql_port

If you are using a non-standard port for your database server, then this option is used to specify that port. The default values are; 3306 for mysql source type and 5432 for pgsql type.

sql_sock

For local database...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Sphinx Search Beginner's Guide

Search

Your notes and bookmarks