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 [email protected]'127.0.0.1' identified by "linuxeye_db_password" with grant option;"
/usr/local/percona/bin/mysql -e "grant all privileges on . to [email protected]'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;"