読者です 読者をやめる 読者になる 読者になる

CentOS-x86_64 MySQL+Spider インストールスクリプト

#!/bin/sh
yum install -y wget
wget http://launchpad.net/spiderformysql/spider-2.x/2.23-for-5.1.44/+download/mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23.tgz
tar zxf mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23.tgz
mv mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23 /usr/local/
rm -f mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23.tgz
cd /usr/local/mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23
cp ./share/mysql/my-medium.cnf /etc/my.cnf
cp ./share/mysql/mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
mkdir ./data
groupadd mysql
adduser -g mysql mysql
chown -R mysql:mysql /usr/local/mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23/
./bin/mysql_install_db
chown -R mysql:mysql /usr/local/mysql-5.1.44-spider-2.23-vp-0.12-linux-x86_64-glibc23/
/etc/init.d/mysql start
./bin/mysql < ./share/mysql/install_spider.sql
./bin/mysql -e "install plugin vp soname 'ha_vp.so'"
./bin/mysql -e "create function vp_copy_tables returns int soname 'ha_vp.so'"
./bin/mysql -e "show engines"