您好,登錄后才能下訂單哦!
這篇文章將為大家詳細(xì)講解有關(guān)如何通過源碼包方式安裝Percona server,小編覺得挺實(shí)用的,因此分享給大家做個(gè)參考,希望大家閱讀完這篇文章后可以有所收獲。
https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/source/tarball/percona-server-5.6.29-76.2.tar.gz
下載cmake:https://cmake.org/download/
]# tar -zxvf cmake-2.8.9.tar.gz
]# cd cmake-2.8.9
#查看幫助
]# cat Readme.txt
$ ./bootstrap; make; make install
]# ./bootstrap
]# make
]# make install
#basedir
~]# mkdir -p /app/mysql
#datadir
~]# mkdir -p /data/percona/mysql/data
~]# chown mysql:mysql /app/mysql/ -R
~]# chown mysql:mysql /data/percona/mysql/ -R
]# tar -zxvf percona-server-5.6.29-76.2.tar.gz
]# cd percona-server-5.6.29-76.2
]#cmake . -LH
]#cmake . \
-DCMAKE_INSTALL_PREFIX=/app/mysql \ #設(shè)置程序安裝路徑
-DMYSQL_DATADIR=/data/percona/mysql/data \ #設(shè)置數(shù)據(jù)存放路徑
-DSYSCONFDIR=/app/mysql \ #配置文件路徑,由于當(dāng)前有別的mysql實(shí)例運(yùn)行,沒有指定/etc
-DWITH_MYISAM_STORAGE_ENGINE=1 \ #啟用MYISAM存儲引擎
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/data/percona/mysql/mysqld.sock \ #設(shè)置套接字存放位置
-DMYSQL_TCP_PORT=6603 \ #設(shè)置開放端口
-DENABLED_LOCAL_INFILE=1 \ #設(shè)置讀取本地文件
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 \ #默認(rèn)字符串
-DDEFAULT_COLLATION=utf8_general_ci #默認(rèn)檢驗(yàn)規(guī)則
附,如果cmake錯(cuò)誤,需要重新cmake,需要清除之前的cmake信息:
]# make clean
]# rm –f CMakeCache.txt
#-j后面是邏輯CPU的個(gè)數(shù),可以根據(jù)實(shí)際情況來指定
]#make -j `grep processor /proc/cpuinfo | wc -l`
]#make install
]# cat /app/mysql/my.cnf
[mysqld]
basedir=/app/mysql
datadir=/data/percona/mysql/data
socket=/data/percona/mysql/mysql.sock
log-error=/data/percona/mysql/mysqld.log
innodb_buffer_pool_size = 128M
port=6603
]# ./scripts/mysql_install_db --defaults-file=/app/mysql/my.cnf
#注意,如果使用的root賬戶初始化db,生成的文件都是root擁有,而mysqld是以mysql用戶運(yùn)行的,對默認(rèn)生成的文件沒權(quán)限,可能無法正常start,如報(bào)錯(cuò):
26803 [Note] Plugin 'FEDERATED' is disabled.
/app/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2016-05-04 14:40:21 26803 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2016-05-04 14:40:21 26803 [ERROR] InnoDB: The system tablespace must be writable!
2016-05-04 14:40:21 26803 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-04 14:40:21 26803 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-04 14:40:21 26803 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-04 14:40:21 26803 [ERROR] Aborting
#此時(shí),修改basedir和datadir下的文件的所有者和所屬組為mysql
]# chown mysql:mysql /data/percona/mysql/ -R
]# chown mysql:mysql /app/mysql/ -R
#再啟動mysql
]# /data/percona/mysql/bin/mysqld_safe --defaults-file=/tmp/my.cnf &
160504 10:37:02 mysqld_safe Adding '/data/percona/mysql/lib/mysql/libjemalloc.so.1' to LD_PRELOAD for mysqld
160504 10:37:02 mysqld_safe Logging to '/data/percona/mysql/mysqld.log'.
160504 10:37:02 mysqld_safe Starting mysqld daemon with databases from /data/percona/mysql/data
]# netstat -antpl|grep mysqld
tcp 0 0 :::6603 :::* LISTEN 27166/mysqld #percona mysql
tcp 0 0 :::3306 :::* LISTEN 23233/mysqld #默認(rèn)運(yùn)行的mysql
]# tail -f /data/percona/mysql/mysqld.log
2016-05-04 14:42:02 27166 [Note] InnoDB: Waiting for purge to start
2016-05-04 14:42:02 27166 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 1626426
2016-05-04 14:42:02 27166 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4eeaade7-11c3-11e6-86b0-782bcb6aa29a.
2016-05-04 14:42:02 27166 [Note] Server hostname (bind-address): '*'; port: 6603
2016-05-04 14:42:02 27166 [Note] IPv6 is available.
2016-05-04 14:42:02 27166 [Note] - '::' resolves to '::';
2016-05-04 14:42:02 27166 [Note] Server socket created on IP: '::'.
2016-05-04 14:42:02 27166 [Note] Event Scheduler: Loaded 0 events
2016-05-04 14:42:02 27166 [Note] /app/mysql/bin/mysqld: ready for connections.
Version: '5.6.29-76.2' socket: '/data/percona/mysql/mysql.sock' port: 6603 Source distribution
a.Stop percona mysql server
b.rm –rf basedir && rm –rf datadir
關(guān)于“如何通過源碼包方式安裝Percona server”這篇文章就分享到這里了,希望以上內(nèi)容可以對大家有一定的幫助,使各位可以學(xué)到更多知識,如果覺得文章不錯(cuò),請把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。