基於CentOS 6.8平台最新原始碼包MariaDB資料庫企業版安裝

標籤：mariadb 資料庫 mysql 源碼 安裝 配置 centos 虛擬機器 搭建 環境

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M02/87/04/wKiom1fROZeT0kGbAABRgfYRGPs093.png" title="MariaDB-Foundation-vertical-small.png" alt="wKiom1fROZeT0kGbAABRgfYRGPs093.png" />

安裝環境

系統：CentOS 6.8 x86_64

MariaDB：enterprise 10.1.16

資源擷取

MariaDB企業版下載，訪問地址 https://mariadb.com/my_portal/download/mariadb-enterprise 這裡需要登入帳號才能下載，可以免費註冊。

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M02/87/06/wKiom1fRdTDxTSK8AACZjQIW2kc283.png-wh_500x0-wm_3-wmp_4-s_55652021.png" title="QQ20160908222645.png" alt="wKiom1fRdTDxTSK8AACZjQIW2kc283.png-wh_50" />

登入成功後進入MariaDB企業版產品下載頁面，這裡提供了二進位與原始碼等多種安裝包。根據實際需求選擇版本10.1.16GA，原始碼包下載。

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M01/87/06/wKiom1fRd1iD-5TEAABc-ZUlzl8769.png-wh_500x0-wm_3-wmp_4-s_989972800.png" title="QQ20160908223554.png" alt="wKiom1fRd1iD-5TEAABc-ZUlzl8769.png-wh_50" />

確定tar.gz包下載

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M01/87/06/wKiom1fRd7uxIPClAAAOeNKp7xE748.png-wh_500x0-wm_3-wmp_4-s_2272125205.png" title="QQ20160908223709.png" alt="wKiom1fRd7uxIPClAAAOeNKp7xE748.png-wh_50" />

得到，複製到CentOS系統裡使用wget/curl等工具來下載到/usr/src目錄下。

https://downloads.mariadb.com/enterprise/y21n-42b1/mariadb-enterprise/10.1.16/source/mariadb-enterprise-10.1.16.tar.gz

下載完成。

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M02/87/04/wKioL1fReH7wgqGzAAAqoDiOlIU159.png" title="QQ20160908224053.png" alt="wKioL1fReH7wgqGzAAAqoDiOlIU159.png" />

安裝過程

安裝epel的yum源

rpm -vih http://mirrors.aliyun.com/epel/epel-release-latest-6.noarch.rpm

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M01/87/04/wKioL1fReXyjugeQAAA_km5vJ3o538.png" title="QQ20160908224446.png" alt="wKioL1fReXyjugeQAAA_km5vJ3o538.png" />

情況yum緩衝，產生新的緩衝。

yum clean all

yum makecache

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M00/87/06/wKiom1fRegbxuf0FAAD2GqTLAc8976.png-wh_500x0-wm_3-wmp_4-s_2459985373.png" title="QQ20160908224722.png" alt="wKiom1fRegbxuf0FAAD2GqTLAc8976.png-wh_50" />

安裝必要的軟體包

yum install -y ncurses-devel make cmake bison zlib zlib-devel openssl openssl-devel jemalloc gcc gcc-c++

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M01/87/04/wKioL1fRep6QoqW8AAB1uxYQzY0871.png-wh_500x0-wm_3-wmp_4-s_681056335.png" title="QQ20160908224956.png" alt="wKioL1fRep6QoqW8AAB1uxYQzY0871.png-wh_50" />

解壓安裝包，使用cmake配置

tar zxf mariadb-enterprise-10.1.16.tar.gz

cd mariadb-10.1.16/

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_SYSCONFDIR=/usr/local/mysql/etc -DMYSQL_DATADIR=/usr/local/mysql/data  -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DMYSQL_USER=mysql -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M02/87/06/wKiom1fRex_QiB4uAADBUoN1Hs8334.png" title="QQ20160908225203.png" alt="wKiom1fRex_QiB4uAADBUoN1Hs8334.png" />

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M02/87/06/wKiom1fRe4mAC5YEAACRi1ObCQM293.png" title="QQ20160908225341.png" alt="wKiom1fRe4mAC5YEAACRi1ObCQM293.png" />

使用make進行編譯，由於普通編譯時間相當漫長。為了加快編譯，這裡啟用多cpu核心同時工作，-j 4 支援4顆核心cpu同時編譯，從而節約時間。

make -j 4

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M02/87/04/wKioL1fRfDKBYZWmAAD0cNPzz-k659.png-wh_500x0-wm_3-wmp_4-s_686581297.png" title="QQ20160908225631.png" alt="wKioL1fRfDKBYZWmAAD0cNPzz-k659.png-wh_50" />

安裝

make install

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M01/87/06/wKiom1fRfbPyDnL5AACZ7CNNmbw393.png-wh_500x0-wm_3-wmp_4-s_4239938319.png" title="QQ20160908230250.png" alt="wKiom1fRfbPyDnL5AACZ7CNNmbw393.png-wh_50" />

建立MariaDB使用者以及相應的目錄

useradd -M -s /sbin/nologin mysql

mkdir -p /usr/local/mysql/etc

mkdir -p /usr/local/mysql/log

mkdir -p /usr/local/mysql/run

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M00/87/05/wKioL1fRflmybREXAAA7mv8TBYc307.png" title="QQ20160908230551.png" alt="wKioL1fRflmybREXAAA7mv8TBYc307.png" />

如果存在/etc/my.cnf檔案，請改名或刪除。並建立新的設定檔

rm -f /etc/my.cnf

cp support-files/my-large.cnf.sh /usr/local/mysql/etc/my.cnf

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M02/87/05/wKioL1fRftKiBkw7AAAoM9fc8Jk679.png" title="QQ20160908230753.png" alt="wKioL1fRftKiBkw7AAAoM9fc8Jk679.png" />

編輯設定檔 vi /usr/local/mysql/etc/my.cnf 修改port與socket參數，並在[mysqld]部分添加

log-error       = /usr/local/mysql/log/mysqld.log

pid-file        = /usr/local/mysql/run/mysqld.pid

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M00/87/05/wKioL1fRf6yyFyL8AADKh8H4jSQ127.png" title="QQ20160908231124.png" alt="wKioL1fRf6yyFyL8AADKh8H4jSQ127.png" />

修改MariaDB安裝目錄所有者

chown -R mysql.mysql /usr/local/mysql/

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M02/87/06/wKiom1fRgDDCUx_4AAAelhpFktw451.png" title="QQ20160908231344.png" alt="wKiom1fRgDDCUx_4AAAelhpFktw451.png" />初始化資料庫

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M00/87/06/wKiom1fRgIiT_bwmAABwVDArwcI334.png-wh_500x0-wm_3-wmp_4-s_1751502212.png" title="QQ20160908231513.png" alt="wKiom1fRgIiT_bwmAABwVDArwcI334.png-wh_50" />

啟動資料庫，查看進程情況。

/usr/local/mysql/bin/mysqld_safe &

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M01/87/06/wKiom1fRgP2BJn_XAACvB28OVTc288.png" title="QQ20160908231705.png" alt="wKiom1fRgP2BJn_XAACvB28OVTc288.png" />

建立啟動指令檔

cp support-files/mysql.server /etc/init.d/mysql

chmod 755 /etc/init.d/mysql

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M02/87/05/wKioL1fRgZeiTB8hAAAlctDlMuY164.png" title="QQ20160908231940.png" alt="wKioL1fRgZeiTB8hAAAlctDlMuY164.png" />

修改/etc/init.d/mysql

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

mysqld_pid_file_path=/usr/local/mysql/run/mysqld.pid

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M02/87/05/wKioL1fRgjfA6YxGAACJ4sDPZo8433.png" title="QQ20160908232158.png" alt="wKioL1fRgjfA6YxGAACJ4sDPZo8433.png" />

添加到chkconfig管理

chkconfig --add mysql

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M00/87/05/wKioL1fRgnuAfYXOAABBIA68v4g178.png" title="QQ20160908232313.png" alt="wKioL1fRgnuAfYXOAABBIA68v4g178.png" />

測試指令碼啟動服務情況

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M01/87/05/wKioL1fRgwLSQsiCAAEkfN8jHgc165.png" title="QQ20160908232542.png" alt="wKioL1fRgwLSQsiCAAEkfN8jHgc165.png" />

為資料庫設定root賬戶登入密碼

/usr/local/mysql/bin/mysqladmin -u root password ‘3D#d0L7‘

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M02/87/06/wKiom1fRhDbxy6cMAAAjyxf3Ujs379.png" title="QQ20160908233054.png" alt="wKiom1fRhDbxy6cMAAAjyxf3Ujs379.png" />

登入資料庫

/usr/local/mysql/bin/mysql -u‘root‘ -p‘3D#d0L7‘

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M02/87/05/wKioL1fRhMajAcT_AABjxr523L4000.png" title="QQ20160908233244.png" alt="wKioL1fRhMajAcT_AABjxr523L4000.png" />

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M01/87/05/wKioL1fRhNXRLN2_AACFTwY2f2U298.png" title="QQ20160908233309.png" alt="wKioL1fRhNXRLN2_AACFTwY2f2U298.png" />

本文出自 “伺服器系統交流” 部落格，請務必保留此出處http://1130739.blog.51cto.com/1120739/1850810

基於CentOS 6.8平台最新原始碼包MariaDB資料庫企業版安裝