Sphinx Full-Text Search engine usage guide: sphinx.conf option reference

8.1. Data Source configuration options

8.1.1. Type

The data source type. Must be an option, no default value. Known types include Mysql,pgsql,xmlpipe and xmlpipe2.

All other options related to the data source depend on the source type specified by this option. The options associated with SQL data sources (that is, MySQL and PostgreSQL) start with "Sql_", and the options associated with xmlpipe and xmlpipe2 data sources begin with "Xmlpipe_."

Example：

Type = MySQL

8.1.2 Sql_host

The SQL Server host address to connect to. Must be an option, no default value. Valid only for SQL data sources (MySQL and pgsql).

In the simplest case, Sphinx is installed on the same host as the MySQL or PostgreSQL server, at which point you only have to set it to localhost. Note that the MySQL client library is determined by the hostname to connect to the server through the http://www.aliyun.com/zixun/aggregation/29912.html ">TCP/IP or UNIX socket." Generally speaking, "localhost" makes it mandatory to use UNIX socket connections (which is the default and recommended mode), and "127.0.01" enforces TCP/IP. Please refer to the MySQL documentation for details.

Example：

Sql_host = localhost

8.1.3 Sql_port

The IP port of the SQL Server to which you want to connect. Optional, the default value is MySQL port 3306,pgsql Port 5432. Applies only to SQL data sources (MySQL and pgsql). Note that this option is actually used depending on the sql_host option.

Example:

Sql_port = 3306

8.1.4 Sql_user

The SQL user name to use when connecting to Sql_host. Must be an option, no default value. Applies only to SQL data sources (MySQL and pgsql).

Example:

Sql_user = Test

8.1.5 Sql_pass

The SQL user password to use when connecting to Sql_host. Must be an option, no default value. Applies only to SQL data sources (MySQL and pgsql).

Example：

Sql_pass = Mysecretpassword

8.1.6 sql_db

The SQL database that is used after you connect to the SQL data source, and subsequent queries are made on this database. Must be an option, no default value. Applies only to SQL data sources (MySQL and pgsql).

Example：

sql_db = Test

8.1.7 Sql_sock

The name of the UNIX socket to use when connecting to the local SQL Server. Optional option with null default value (client library

Default settings). Applies only to SQL data sources (MySQL and pgsql). On Linux, it's usually/var/lib/mysql/mysql.sock. And on the FreeBSD is usually/tmp/mysql.sock. Note whether this option is actually used depending on the sql_host settings.

Example：

Sql_sock =/tmp/mysql.sock