您好,登錄后才能下訂單哦!
這篇文章給大家分享的是有關(guān)CentOS7怎么安裝Percona Server+Mysql的內(nèi)容。小編覺得挺實(shí)用的,因此分享給大家做個(gè)參考,一起跟隨小編過來看看吧。
一、環(huán)境說明
(1)CentOS-7-x86_64,內(nèi)核版本
uname -r 3.10.0-693.el7.x86_64
(2)Mysql版本
percona-server-5.6.29
(3)文件存放路徑
/home/soft
二、安裝前準(zhǔn)備
(1)配置權(quán)限
groupadd mysql useradd -r -g mysql mysql
(2)創(chuàng)建安裝目錄
mkdir /usr/local/mysql #mysql安裝目錄 chown -R mysql:mysql /usr/local/mysql mkdir /usr/local/mysql/dataconf #數(shù)據(jù)庫配置存放目錄 chown -R mysql:mysql /usr/local/mysql/dataconf mkdir /usr/local/mysql/sock #運(yùn)行mysql時(shí)mysql.sock存放目錄 chown -R mysql:mysql /usr/local/mysql/sock mkdir /var/log/mysql #創(chuàng)建日志存放目錄 touch /var/log/mysql/mysql.log chown -R mysql:mysql /var/log/mysql/mysql.log touch /usr/local/mysql/my.cnf #創(chuàng)建mysql配置文件
三、安裝編譯環(huán)境
yum install readline-devel git gcc gcc-c++ make cmake bison bison-devel ncurses-devel libaio-devel perl zlib1g-dev autoconf
四、編譯安裝percona
cd /home/soft/ tar zxvf percona-server-5.6.29-76.2.tar.gz cd percona-server-5.6.29-76.2 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql #需要使用cmake進(jìn)行安裝,這里表示的是文件安裝目錄 -DSYSCONFDIR=/usr/local/mysql #存放配置文件的目錄 -DMYSQL_DATADIR=/usr/local/mysql/dataconf #存放數(shù)據(jù)庫的目錄 -DMYSQL_UNIX_ADDR=/usr/local/mysql/sock/mysqld.sock #存放mysql.sock文件的目錄 -DMYSQL_TCP_PORT=3306 -DWITH_MYISAM_STORAGE_ENGINE=1 #配置端口 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 #配置默認(rèn)的字符編碼格式 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DWITH_EDITLINE=bundled -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF
之后,繼續(xù)編譯安裝。
make -j 8 #大概需要30-40分鐘左右。如果報(bào)錯(cuò),請使用make clean , rm -rf CMakeCache.txt make install
五、配置Percona參數(shù)
cat /usr/local/mysql/my.cnf [mysqld] # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 explicit_defaults_for_timestamp=true federated # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd basedir=/usr/local/mysql datadir=/usr/local/mysql/dataconf port=3306 socket=/usr/local/mysql/sock/mysql.sock symbolic-links=0 character_set_server=utf8 pid-file=/usr/local/mysql/mysql.pid skip-grant-tables [mysqld_safe] log-error=/var/log/mysql/mysql.log pid-file=/usr/local/mysql/mysql.pid socket=/usr/local/mysql/sock/mysql.sock [client] socket=/usr/local/mysql/mysql.sock [mysql.server] user=mysql basedir=/usr/local/mysql socket=/usr/local/mysql/sock/mysql.sock [mysql] socket=/usr/local/mysql/sock/mysql.sock
六、配置Mysql訪問權(quán)限
chown -R mysql:mysql /usr/local/mysql/bin chown -R mysql:mysql /usr/local/mysql/mysql.pid
七、初始化Mysql服務(wù)器
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/usr/local/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dataconf --user=mysql
八、配置環(huán)境變量
為了能直接調(diào)用mysql命令,需要配置環(huán)境變量 vi /etc/profile 在/etc/profile文件末尾添加 export PATH=/usr/local/mysql/bin:$PATH 使環(huán)境變量立即生效 source /etc/profile
九、配置啟動腳本
cp /home/soft/percona-server-5.6.29-76.2/support-files/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql chkconfig mysql on service mysql start/stop
十、后言
此方法我也不知道為什么在CentOS7里面安裝之后可以用,在Debian服務(wù)器里面無法進(jìn)行編譯安裝使用。另外在使用的過程中,有時(shí)候可能也需要Percona-Server-client的支持。針對這個(gè)問題,可以使用以下方法解決:將文件上傳到/home/soft/目錄下,然后進(jìn)行安裝。安裝方法如下:
rpm -ivh Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64.rpm rpm -ivh Percona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm rpm -ivh Percona-Server-devel-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm rpm -ivh Percona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm
或者使用rpm -ivh * 即可安裝
感謝各位的閱讀!關(guān)于“CentOS7怎么安裝Percona Server+Mysql”這篇文章就分享到這里了,希望以上內(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)容。