Mysql的cmake編譯與安裝

標籤：

Mysql的cmake編譯與安裝

實驗準備環境：

我的作業系統是centos6.6

編譯安裝MariaDB之前，我們需要準備一些需要的環境

1.開發包組套件

[[email protected] ~]# yum -y groupinstall "Development Tools" "Server Platform Development"

?

2. 安裝上這個跨平台的構建工具------cmake

[[email protected] ~]# yum -y install cmake

?

ftp://172.16.0.1/pub/Sources/sources/mariadb

lftp 172.16.0.1:/pub/Sources/sources/mariadb> mget mariadb-10.0.13.tar.gz

?

?

[[email protected] ~]# tar xf mariadb-10.0.13.tar.gz

?

建立所有者:所屬組為 mysql

[[email protected] ~]# groupadd -r -g 306 mysql

[[email protected] ~]# useradd -r -g 306 -u 306 mysql

?

[[email protected] ~]# mkdir -pv /mydata/data

mkdir: created directory `/mydata‘

mkdir: created directory `/mydata/data‘

[[email protected] ~]# chown -R mysql.mysql /mydata/data

?

[[email protected] mariadb-10.0.13]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mydata/data -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

?

[[email protected] mariadb-10.0.13]# make

[[email protected] mariadb-10.0.13]# make install

[[email protected] mysql]# pwd

/usr/local/mysql

修改目前的目錄的所屬組

?

[[email protected] mysql]# chown -R root.mysql ./*

修改後的：

?

建立邏輯卷，過程自己總結（用作備份）

#掛載一個邏輯捲來實現一致性備份

物理層損壞恢複困難

??

#fdisk /dev/sda

p n p 3 +30G t 3 8e w

#partx -a /dev/sda

#pvcreate /dev/sda3

#vgcreate myvg /dev/sda3

#lvcreate -L 10G -n mylv myvg

??

#yum install xfsprogs

#mkfs -t xfs /dev/myvg/mylv

#vim /etc/fstab

/dev/myvg/mylv /mydata xfs defaults 0 0

#mount -a

#mount

?

?

?

?

?

執行初始化：

[[email protected] mysql]# scripts/mysql_install_db --user=mysql --datadir=/mydata/data/

[[email protected] mysql]# ls /mydata/data/

aria_log.00000001 aria_log_control ibdata1 ib_logfile0 ib_logfile1 mysql performance_schema test

[[email protected] ~]# mkdir /etc/mysql

[[email protected] mysql]# cp support-files/my-large.cnf /etc/mysql/my.cnf

[[email protected] mysql]# vim /etc/mysql/my.cnf

#找到 thread_concurrency = 8 ,在其後面添加三行如下：

innodb_file_per_table = on

datadir = /mydata/data

skip_name_resolve = on

?

添加開機啟動項：

[[email protected] mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld

[[email protected] mysql]# chmod +x /etc/rc.d/init.d/mysqld

[[email protected] mysql]# chkconfig --add /etc/init.d/mysqld

[[email protected] mysql]# service mysqld start

Starting MySQL. [ OK ]

?

[[email protected] mysql]# ss –tnl

?

給mariadb 添加環境變數，可以使用tab路徑補全

增加著色的兩行：

[[email protected] mysql]# vim /etc/profile.d/mysql.sh

export MYSQL_HOME=/usr/local/mysql

export PATH=$MYSQL_HOME/bin:$PATH

?

[[email protected] mysql]# . /etc/profile.d/mysql.sh

?

?

以上mariadb的編譯安裝已經可以告一段落啦

?

?

?

?

?

?

Mysql的cmake編譯與安裝