天天看點

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