编译Mariadb10.10版数据库

前言：

    mysql被Oracle收购，签下5年契约，为了防止mysql被默默的淹没掉大众的视野中，mysql的原开发团队又开发了一款Mariadb，Mariadb和mysql类似，并且红帽新的版本已经默认带入Mariadb。本文讲解Mariadb的安装。

Mariadb官网：https://mariadb.org/

Mariadb基于cmake编译安装

一）安装需要的开发包和cmake：

yum groupinstall ”Server Platform Development“
yum groupinstall  “Development tools”
yum -y install readline-devel
yum -y install cmake
[root@localhost ~]# groupadd -r mysql
[root@localhost ~]# mkdir -p /mydata/data
[root@localhost ~]# useradd -g mysql -r -s /sbin/nologin mysql
[root@localhost ~]# clock -s
[root@localhost ~]# tar xf mariadb-10.0.10.tar.gz

编译：

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mydata/data/ -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STPRAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWIYH_READLINE=1 -DWIYH_SSL=system -DVITH_ZLIB=system -DWITH_LOBWRAP=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

make && make install

cd /usr/local/mysql/
chown mysql.mysql * -R
./scripts/mysql_install_db --user=mysql --datadir=/mydata/data/
cp support-files/my-large.cnf /etc/my.cnf
vim /etc/my.cnf
datadir = /mydata/data
chown :root * -R
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
/etc/init.d/mysqld start
mysql-test/
vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
source /etc/profile.d/mysql.sh
mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.0.10-MariaDB-log Source distribution
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.
MariaDB [(none)]>

PS：

    安装完成

本文出自 “落叶飘远方” 博客，请务必保留此出处http://shunzi.blog.51cto.com/8289655/1395620

编译Mariadb10.10版数据库,布布扣,bubuko.com

编译Mariadb10.10版数据库

原文：http://shunzi.blog.51cto.com/8289655/1395620