Percona server安装和MySQL安装一模一样,安装如下:
1、安装依赖包 yum -y install gcc gcc-c++ ncurses ncurses-devel
2、下载相应源码包 wget http://www.cmake.org/files/v2.8/cmake-2.8.11.2.tar.gz
wget http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.33-31.1/source/Percona-Server-5.5.33-rel31.1.tar.gz
3、cmake安装
cd lnmp/src
tar xzf cmake-2.8.11.2.tar.gz
cd cmake-2.8.11.2
./configure
make && make install
cd ..
4、Percona 5.5预编译
tar zxf Percona-Server-5.5.33-rel31.1.tar.gz
cd Percona-Server-5.5.33-rel31.1
useradd -M -s /sbin/nologin mysql
mkdir -p /data/percona
chown mysql.mysql -R /data/percona
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/percona -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_DATADIR=/data/percona -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all
编译参数解释:
CMAKE_INSTALL_PREFIX #安装路径
MYSQL_UNIX_ADDR #unix socket路径
MYSQL_DATADIR #数据库存放路径
SYSCONFDIR #配置文件路径
MYSQL_TCP_PORT #数据库端口
WITH_INNOBASE_STORAGE_ENGINE #安装innodb引擎
WITH_PARTITION_STORAGE_ENGINE #安装分区引擎
WITH_BLACKHOLE_STORAGE_ENGINE #安装blackhole引擎
WITH_MYISAM_STORAGE_ENGINE #安装myisam引擎
WITH_READLINE #快捷键功能
ENABLED_LOCAL_INFILE #允许从本地导入数据
DEFAULT_CHARSET #默认编码
DEFAULT_COLLATION #默认字符集
WITH_EXTRA_CHARSETS #是否使用其他编码,all表示所有编译安装
make && make install
5、启动脚本,设置开机自启动
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
6、修改/etc/my.cnf,仅供参考
[mysqld]
basedir = /usr/local/percona
datadir = /data/percona
pid-file = /data/percona/mysql.pid
character-set-server = utf8
collation-server = utf8_general_ci
user = mysql
port = 3306
default_storage_engine = InnoDB
innodb_file_per_table = 1
server_id = 1
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7
bind-address = 0.0.0.0
// name-resolve
skip-name-resolve
skip-host-cache
//lower_case_table_names = 1
ft_min_word_len = 1
query_cache_size = 64M
query_cache_type = 1
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
// LOG
log_error = /data/percona/mysql-error.log
long_query_time = 1
slow_query_log
slow_query_log_file = /data/percona/mysql-slow.log
//Oher
//max_connections = 1000
open_files_limit = 65535
[client]
port = 3306
7、初始化数据库,设置环境变量
/usr/local/percona/scripts/mysql_install_db --user=mysql --basedir=/usr/local/percona --datadir=/data/percona
chown mysql.mysql -R /data/percona
export PATH=$PATH:/usr/local/percona/bin
echo "export PATH=$PATH:/usr/local/percona/bin" >> /etc/profile
. /etc/profile
8、启动Percona数据库
service mysqld start
9、设置数据库root密码,删除空密码、测试数据库
ps:linuxeye_db_password为root密码
/usr/local/percona/bin/mysql -e "grant all privileges on . to root@'127.0.0.1' identified by "linuxeye_db_password" with grant option;"
/usr/local/percona/bin/mysql -e "grant all privileges on . to root@'localhost' identified by "linuxeye_db_password" with grant option;"
/usr/local/percona/bin/mysql -uroot -plinuxeye_db_password -e "delete from mysql.user where Password='';"
/usr/local/percona/bin/mysql -uroot -plinuxeye_db_password -e "delete from mysql.db where User='';"
/usr/local/percona/bin/mysql -uroot -plinuxeye_db_password -e "drop database test;"
/usr/local/percona/bin/mysql -uroot -plinuxeye_db_password -e "reset master;"