Install the Sphinx engine for MySQL-5.5.9 Compilation

Source code download

 
 

  
  
wget http://admin.ooopic.com/soft/linux/cmake-2.8.3.tar.gz 
  
  
wget http://www.wapm.cn/uploads/csft/4.0/coreseek-4.0.1-beta.tar.gz 
  
  
wget http://ftp.jaist.ac.jp/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.9.tar.gz 
 
 

Tip: the installation method of mysql 5.5.9 is different from that of the previous version, and the cmake tool is also required. By default, it is installed in the/usr/local/mysql path and can be changed after installation.

Install CMake

 
 

  
  
Tar zxvf cmake-2.8.3.tar.gz
  
  
Cd cmake-2.8.3
  
  
./Bootstrap
  
  
Make
  
  
Make install
 
 
Install MYSQL
  
  

   
   
Tar xzvf coreseek-4.0.1.tar.gz
   
   
Tar xzvf mysql-VERSION.tar.gz
   
   
 
   
   
# Copy the sphinx engine source code to the storage directory of the mysql source package
   
   
Cp-R coreseek-4.0.1/csft-4.0.1/mysqlse mysql-5.5.9/storage/sphse
   
   
Cd mysql-5.5.9
   
   
Cmake.-DCMAKE_BUILD_TYPE = Release-DWITH_SPHINX_STORAGE_ENGINE = 1
   
   
Make
   
   
# Make will show the information halfway through
   
   
Scanning dependenciesOfTarget sphinx
   
   
[30%] Building CXX object storage/sphpackages/CMakeFiles/sphfiles. dir/ha_sphinx.cc.o
   
   
Linking CXX shared module ha_sphinx.so
   
   
[30%] Built target sphinx
   
   
 
   
   
Make install
   
   
Cd/usr/Local/Mysql
   
   
Mkdir-p/var/log/mysql/usr/Local/Mysql/etc
   
   
Cp support-files/my-medium.cnf/usr/Local/Mysql/etc/my. cnf
  
  

Compile/etc/my. cnf: Add the following configuration: basedir =/usr/local/mysql # mysql location datadir =/usr/local/mysql/data # mysql database file storage path.
  
  

   
   
Chown-R mysql: mysql/usr/Local/Mysql
   
   
/Usr/Local/Mysql/scripts/mysql_install_db-- Basedir =/usr/local/mysql -- user = mysql 
   
   
./Bin/mysqld_safe-- Defaults-extra-file =/usr/local/mysql/etc/my. cnf -- user = mysql & 
   
   
Mysql-uroot-p
   
   
Mysql> install plugin sphsf-soname"Ha_sphinx.so";
   
   
Mysql> show engines;
   
   
# If the ENGINE list shows sphenders, the installation is successful, including innodb and MyISAM.