mariadb编译安装

1. 下载源码包

   • 进网站选 5.5 mariadb
   • 传到要安装的主机

2. 解包
   tar -zxvf mariadb-5.5.66.tar.gz

3. 安装包

   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 libdb-cxx-devel
   

4. cmake 编译安装

   cmake . \
         -DCMAKE_INSTALL_PREFIX=/app/mysql \
         -DMYSQL_DATADIR=/data/mysql/ \
         -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=/data/mysql/mysql.sock \
         -DDEFAULT_CHARSET=utf8 \
         -DDEFAULT_COLLATION=utf8_general_ci
   make && make install
   # 提示:如果出错,执行rm -f CMakeCache.txt
   

5. 准备环境变量

   echo 'PATH=/app/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
   . /etc/profile.d/mysql.sh
   

6. 生成数据库文件

   cd /app/mysql/
   scripts/mysql_install_db --datadir=/data/mysql/ --user=mysql
   

7. 准备配置文件

   cp /app/mysql/support-files/my-huge.cnf /etc/my.cnf
   

8. 准备启动脚本

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

9. 启动服务

   chkconfig --add mysqld ;service mysqld start