USAGE ===== Sphinx Engine configuration --------------------------- - Config is store in config/ sphinx.conf : Sphinx Engine config *.conf : one file per index conf with "tmp" must be use only on master - Create /etc/sphinxsearch/sphinx.conf - Create /etc/sphinxsearch/sphinx.reprise.conf - Data storage /var/lib/sphinxsearch/log : Log /var/lib/sphinxsearch/idx : Data index Environment variables ENV_MYSQLHOST ENV_MYSQLUSER ENV_MYSQLPASS sed -i -e 's/ENV_MYSQLHOST/VALUE/g' sphinx.*.conf sed -i -e 's/ENV_MYSQLUSER/VALUE/g' sphinx.*.conf sed -i -e 's/ENV_MYSQLPASS/VALUE/g' sphinx.*.conf sed -i -e 's/ENV_MYSQLHOST/VALUE/g' indexer/*.sh sed -i -e 's/ENV_MYSQLUSER/VALUE/g' indexer/*.sh sed -i -e 's/ENV_MYSQLPASS/VALUE/g' indexer/*.sh - Crontab - Logrotate Indexing -------- indexer-*.sh : Index on master database with rotation slave-*.sh : Index on slave database only if master table have rotated manual-*.sh : Manually reload index Ubuntu PPA repository ===================== sudo apt-get install software-properties-common sudo add-apt-repository ppa:builds/sphinxsearch-rel22 sudo apt-get install libstemmer0d sudo apt-get update && apt-get install sphinxsearch Manual installation =================== apt-get install mysql-client-5.5 apt-get install gcc g++ make libmysqld-dev wget -nv -O - http://snowball.tartarus.org/dist/libstemmer_c.tgz | tar zx wget -nv -O - https://re2.googlecode.com/files/re2-20140304.tgz | tar zx wget http://sphinxsearch.com/files/sphinx-2.2.7-release.tar.gz tar xzvf sphinx-2.2.7-release.tar.gz cp -R libstemmer_c/* sphinx-2.2.7-release/libstemmer_c/ sed -i -e 's/stem_ISO_8859_1_hungarian/stem_ISO_8859_2_hungarian/g' sphinx-2.2.7-release/libstemmer_c/Makefile.in cp -R re2/* sphinx-2.2.7-release/libre2/ cd sphinx-2.2.7-release ./configure --with-libstemmer --with-re2 --prefix=/usr/local/sphinx make make install