Percona Server 5.1.55二进制包安装
2011-03-18Linux撒加11797°c
A+ A-介个Percona-Server是MySQL的衍生版,使用了一些 google-mysql-tools
, Proven Scaling
, Open Query
对 MySQL 进行改造。看着还不错,今下载了i686和x86_64的两个版本来试试。
首先执行uname -m查看系统是32BIT的还是64BIT的
两个版本的下载地址:
https://www.percona.com/redir/downloads/Percona-Server-5.1/Percona-Server-5.1.55-12.6/Linux/binary/Percona-Server-5.1.55-rel12.6-200-Linux-i686.tar.gz
https://www.percona.com/redir/downloads/Percona-Server-5.1/Percona-Server-5.1.55-12.6/Linux/binary/Percona-Server-5.1.55-rel12.6-200-Linux-x86_64.tar.gz
本文以64BIT版本为例安装,操作系统为Debian 6.0 64bit
下载好Percona-Server-5.1.55-rel12.6-200-Linux-x86_64.tar.gz后,解压
tar zxvf Percona-Server-5.1.55-rel12.6-200-Linux-x86_64.tar.gz -C /var/webserver/
mv /var/webserver/Percona-Server-5.1.55-rel12.6-200-Linux-x86_64 /var/webserver/mysql
echo "/var/webserver/mysql/lib" >> /etc/ld.so.conf.d/libc.conf
echo "/var/webserver/mysql/lib/mysql" >> /etc/ld.so.conf.d/libc.conf
/sbin/ldconfig
mkdir /var/webserver/mysql/data //新建数据库数据目录
添加用户和组
groupadd mysql
useradd -g mysql mysql
cp /var/webserver/share/mysql/my-medium.cnf /etc/my.cnf //生成my.cnf文件
sed -i '25 a\basedir = /var/webserver/mysql' /etc/my.cnf //指定基本目录
sed -i '26 a\datadir = /var/webserver/mysql/data' /etc/my.cnf //指定数据存放目录
sed -i '27 a\max_connections = 1000' /etc/my.cnf //最大连接数,这里最大可以为100000
sed -i '28 a\skip-name-resolve' /etc/my.cnf //关闭DNS解析
sed -i '29 a\pid-file=/var/webserver/run/mysql.pid' /etc/my.cnf //指定PID文件
sed -i '30 a\default-storage-engine = innodb' /etc/my.cnf //指定默认引擎,可以通过show engines;来查看
sed -i '31 a\log-error = /var/webserver/logs/mysql.err' /etc/my.cnf //指定错误文件
sed -i "s/skip-locking/skip-external-locking/g" /etc/my.cnf //关闭外部锁
/var/webserver/mysql/bin/mysql_install_db --user=mysql --basedir=/var/webserver/mysql --datadir=/var/webserver/mysql/data //初始化数据库
chown -R mysql:mysql /var/webserver/mysql/ //将basedir的用户和组改为mysql
cp /var/webserver/share/mysql/mysql.server /etc/init.d/rc.mysql //现成的mysql启动脚本拷贝到/etc/init.d下
chmod 755 /etc/init.d/rc.mysql //赋予执行权限
/etc/init.d/rc.mysql start //启动数据库后为数据库用户root添加密码
/var/webserver/mysql/bin/mysqladmin -u root password $mysqlrootpwd //设置ROOT密码
这样Percona-Server二进制版本就安装好了
Percona-Server的主从、读写分离改日再测试