percona mysql 编译参数_MySQL分支Percona, cmake编译安装

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;"