Ubuntu 源码安装 MariaDB 5.5.30

[b]添加mysql组，及mysql用户[/b]

sudo groupadd mysql
sudo useradd -g mysql -s /usr/sbin/nologin mysql

到 mariadb.org 下载 mariadb-5.5.30.tar.gz

[b]编译，安装 MariaDB[/b]
tar -zxvf mariadb-5.5.30.tar.gz
cd mariadb-5.5.30/

[b]安装cmake[/b]
apt-get install cmake

[b]用cmake命令编译MariaDB[/b]
cmake . -DCMAKE_INSTALL_PREFIX=/opt/mariadb -DMYSQL_DATADIR=/data/mariadb -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_SSL=system

[b]根据报错信息，安装所缺lib，软件。[/b]
apt-get install g++
apt-get install openssl
apt-get install libssl-dev
apt-get install libncurses5-dev
apt-get install libboost-dev
apt-get install bison

after cmake error happen, you have to do as follows;

[color=red][b]注：当执行cmake报error，根据提示安装对应的lib，软件后需要手动删除CMakeCache.txt文件，这个文件貌似是cmake时产生的缓存文件。删除步骤如下：[/b][/color]

1) rm -fr CMakeCache.txt, and than
2) cmake . -DCMAKE_INSTALL_PREFIX=/opt/mariadb -DMYSQL_DATADIR=/data/mariadb -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_SSL=system
3) cmake .

make && make install


[b]拷贝配置文件和,启动脚本[/b]

cd /opt/mariadb
cp support-files/my-large.cnf /etc/my.cnf
cp support-files/mysql.server /etc/rc.d/init.d/mariad
chmod +x /etc/rc.d/init.d/mariad
chkconfig --add mariad
chkconfig mariad on

[b]初始化数据库[/b]

mkdir -pv /data/mariadb
chown -R mysql:mysql /data/
chown -R :mysql /opt/mariadb/.
scripts/mysql_install_db --user=mysql --datadir=/data/mariadb

[b]修改mariadb配置文件[/b]

vim /etc/my.cnf

#添加mysql存放数据的路径
datadir = /data/mariadb

#根据电脑的cpu数量，修改线程数
thread_concurrency = 2

[b]然后就可以启动服务了[/b]
sudo /opt/mariadb/support-files/mysql.server start

[b]设置MariaDB的环境变量[/b]
sudo vi /etc/profile
PATH=$PATH:/opt/mariadb/bin/

source /etc/profile

[b]参考文献如下：[/b]
http://www.verydemo.com/demo_c152_i12229.html