[Original] centos6.4 compile and install mysql5.5 and install the Sphinx engine for it

Invalid.

# Mysql5.5 changed with cmake installed, so first install cmakmcm/data/software/wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gzwget http://www.coreseek.cn/uploads/csft/4.0/coreseek-4.1-beta.tar.gzcd/data/srctar zxf ../software/coreseek-4.1-beta.tar.

# Use cmake to install mysql5.5. http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gzwget  http://www.coreseek.cn/uploads/csft/4.0/coreseek-4.1-beta.tar.gzcd /Data/srctar zxf .. /software/coreseek-4.1-beta.tar.gztar zxf .. /software/cmake-2.8.4.tar.gzcd cmake-2.8.4. /configuremake & make install # mysql5.5 Basic installation cd/data/srctar zxf .. /software/mysql-5.5.28.tar.gzcd mysql-5.5.28cp-r/data/src/coreseek-4.1-beta/csft-4.1/mysqlse storage/sphinxcmake. -DCMAKE_BUILD_TYPE = Release-DWITH_SPHINX_STORAGE_ENGINE = 1 make & make install # configure cd/usr/local/mysqlmkdir-p/var/log/mysql/usr/local/mysql/etccp support- file/my-medium.cnf/usr/local/mysql/etc/my. cnfrm-rf/etc/my. cnfln-s/usr/local/mysql/etc/my. cnf/etc/my. cnfvi/etc/my. cnf ####################################### ### [mysqld] basedir =/usr/local/mysqldatadir =/usr/local/mysql/data ################# ######################### set the user group groupadd-g 88 mysqladduser-u 88-g mysql- s/sbin/nologin mysql # initialize the database and map the database to a more directory to my familiar Folder/data/database/mysql. /scripts/mysql_install_db -- basedir =/usr/local/mysql -- user = mysqlchown-R root. chown-R mysql datarm-rf/data/databasemkdir-p/data/databaseln-s/usr/local/mysql/data/database/mysql # change the permission to store database files, at this time, some files do not exist in chown-R mysql: mysql/data/database/mysqlchmod 770/data/database/mysqlchmod 770/data/database/mysql/ib * chmod 770/data/database/mysql /*. errchmod 770/data/database/mysql /*. pidchmod 660/data/database/mysql/* chmod 700/data/database/mysql/mysqlchmod 700/data/database/mysql/test # Start mysql/usr/local/mysql /bin/mysqld_safe -- defaults-extra-file =/usr/local/mysql/etc/my. cnf -- user = mysql & sleep 5 # Set the password of the Database root Account, and save the password/usr/local/mysql/bin/mysqladmin-u root password 'xxxxxxxxxxx' # If the password is incorrect, you can first turn off the database and then/usr/local/mysql/bin/mysqld_safe -- skip-grant-tables & then mysql-u root and then update user set password = password ("XXXXXXXXX ") where user = 'root '; then restart the database mkdir-p/data/save/echo 'xxxxxxxxxx'>/data/save/mysql_root # Shut down the database/usr/local/mysql/bin/mysqladmin-u root-pXXXXXXXXX shutdown # Start the database | disable the simplified echo '/usr/local/mysql/bin/mysqld_safe -- defaults-extra-file =/usr/local/mysql/etc/my. cnf -- user = mysql>/root/mysql_startchmod 700/root/mysql_startecho '/usr/local/mysql/bin/mysqladmin-u root-p shutdown'>/root/mysql_stopchmod 700/root/mysql_stop # Set echo for database startup "/root/mysql_start">/etc/rc. d/rc. local # link the mysql binfile to the PATH directory ln-s/usr/local/mysql/bin/mysql/usr/local/bin/mysql

# Install sphinx support!

mysql -uroot -p`cat /data/save/mysql_root`mysql>install plugin sphinx soname "ha_sphinx.so";mysql>show engines;

If everything goes well, you will see the following information:

Now you can create a sphinx engine table:
# Create a sphinx engine table

CREATE TABLE rtindex(id bigint( 11 ) NOT NULL ,weight integer( 11 ) NOT NULL ,title varchar( 255 ) NOT NULL ,content varchar( 5000 ) NOT NULL ,groupid int( 6 ) NOT NULL ,biguid bigint( 11 ) NOT NULL ,score float( 6 ) NOT NULL ,date_added bigint( 11 ) NOT NULL ,author varchar( 255 ) NOT NULL ,INDEX ( title )) ENGINE = SPHINX DEFAULT CHARSET = utf8 CONNECTION = 'sphinx://localhost:9314/rtindex';

Complete.

Original article address: [original] centos6.4 compile and install mysql5.5 and install the Sphinx engine for it. Thanks to the original author for sharing this article.