卸载原有自带的Mysql
yum remove mysql-libs
安装依赖包
yum install centos-release-scl devtoolset-4-gcc-c++ devtoolset-4-gcc cmake git ncurses-devel openssl-devel bison -y
创建账号
groupadd mysql
useradd -r -g mysql mysql
安装步骤
wget -c https://github.com/alibaba/AliSQL/archive/AliSQL-5.6.32-4.tar.gz
tar zxvf AliSQL-5.6.32-4.tar.gz
cd AliSQL-AliSQL-5.6.32-4/
scl enable devtoolset-4 bash
cmake . -DCMAKE_BUILD_TYPE="Release" -DCMAKE_INSTALL_PREFIX="/opt/alisql" -DWITH_EMBEDDED_SERVER=0 -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_TOKUDB_STORAGE_ENGINE=1
make
make install
授权
cd /opt/alisql
chown -R mysql. .
初始化
cd /opt/alisql
echo never > /sys/kernel/mm/transparent_hugepage/enabled ##开启TokuDB,不执行会提示:[ERROR] TokuDB: Huge pages are enabled, disable them before continuing
scripts/mysql_install_db --user=mysql --datadir=/opt/alisql/data --basedir=/opt/alisql
cp support-files/my-default.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
环境变量配置
echo "PATH=/opt/alisql/bin:/opt/alisql/lib:$PATH" >> /etc/profile
source /etc/profile
启动并加入开机自启
service mysqld start
chkconfig --level 35 mysqld on
转载请注明出处:http://www.cnblogs.com/lovegive/p/6510850.html
作者:Apple