基礎軟件
yum install
bison bison-devel zlib-devel libcurl-devel
libarchive-devel boost-devel gcc gcc-c++
cmake ncurses-devel gnutls-devel libxml2-devel
openssl-devel libevent-devel libaio-devel
rm -f CMakeCache.txt???? /* 如果出錯 */
解壓
tar xvf mariadb-10.2.15.tar.gz
編譯
編譯選項
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
cd mariadb-10.2.15/
cmake . \
-DCMAKE_INSTALL_PREFIX=/app/mysql \
-DMYSQL_DATADIR=/data/mysqldb/ \
-DSYSCONFDIR=/etc \
-DMYSQL_USER=mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITHOUT_MROONGA_STORAGE_ENGINE=1 \
-DWITH_DEBUG=0 \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_LIBWRAP=0 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_UNIX_ADDR=/app/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
make -j 4 && make install
路徑變量
echo PATH=/app/mysql/bin:$PATH > /etc/profild.d/mysql.sh
. /etc/profild.d/mysql.sh
建立數據庫
創建用戶
useradd -r -s /sbin/nologin mysql
創建路徑
mkdir -pv /data/mysqldb
chown mysql.mysql /data/mysqldb/
生成數據庫
cd /app/mysql/
scripts/mysql_install_db –datadir=/data/mysqldb/ –user=mysql –basedir=/app/mysql /* show variables like “basedir”(‘%basedir%’) */
/* 二進制安裝 編譯安裝 需要指明 */
配置文件
cp support-files/my-huge.cnf /etc/my.cnf
啟動腳本
cp support-files/mysql.server /etc/init.d/mysqld
setfacl -R -m u:mysql:rwx /app/mysql/
service mysqld restart
chkconfig –add mysqld
service mysqld start
本文來自投稿，不代表Linux運維部落立場，如若轉載，請注明出處：http://www.www58058.com/101615
