----------------------------------------------------------------------+
?
1) 由于默认CentOS内核就支持xfs文件系统，只需要加载模块即可
root@nginx1 ~ > lsmod |grep xfs
root@nginx1 ~ > modprobe xfs
root@nginx1 ~ > lsmod |grep xfs
xfs ?1124960 ?0?
exportfs4236 ?1 xfs
root@nginx1 ~ >?
?
2) 安装客户端工具包
root@nginx1 ~ > yum -y install xfsprogs
?
3) 进行格式化
root@nginx1 ~ > mkfs.xfs /dev/mysql-vg/mysql-lv?
meta-data=/dev/mysql-vg/mysql-lv isize=256agcount=4, agsize=16384000 blks
?= ? sectsz=512 ? attr=2, projid32bit=0
data = ? bsize=4096 ? blocks=65536000, imaxpct=25
?= ? sunit=0 ?swidth=0 blks
naming ? =version 2 ?bsize=4096 ? ascii-ci=0
log ?=internal log ? bsize=4096 ? blocks=32000, version=2
?= ? sectsz=512 ? sunit=0 blks, lazy-count=1
realtime =none ? extsz=4096 ? blocks=0, rtextents=0
root@nginx1 ~ >?
?
4) 修改磁盘调度策略为 deadline
root@nginx1 ~ > echo 'deadline' > /sys/block/sdb/queue/scheduler?
root@nginx1 ~ > cat /sys/block/sdb/queue/scheduler
noop anticipatory [deadline] cfq?
root@nginx1 ~ >?
?
5) 挂载，挂载时禁止atime
root@nginx1 ~ > mkdir /JY
root@nginx1 ~ > mount -o noatime /dev/mysql-vg/mysql-lv /JY/
root@nginx1 ~ > df -HPT
Filesystem ?Type ? Size ?Used Avail Use% Mounted on
/dev/sda5 ? ext422G ?1.5G ? 19G ? 8% /
tmpfs ? tmpfs ?984M 0 ?984M ? 0% /dev/shm
/dev/sda1 ? ext4 ? 199M ? 36M ?154M ?19% /boot
/dev/sda3 ? ext4 ? 109G ?2.3G ?101G ? 3% /usr
/dev/mapper/mysql--vg-mysql--lv xfs269G ? 34M ?269G ? 1% /JY
?
root@nginx1 ~ > mount
/dev/sda5 on / type ext4 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
tmpfs on /dev/shm type tmpfs (rw)
/dev/sda1 on /boot type ext4 (rw)
/dev/sda3 on /usr type ext4 (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
/dev/mapper/mysql--vg-mysql--lv on /JY type xfs (rw,noatime)
?
6) 写入fstab
root@nginx1 ~ > echo -e '/dev/mapper/mysql--vg-mysql--lv \t /JY \t xfs \t defaults,noatime \t 0 0' >> /etc/fstab?
?
+--------------------------------------------------------------------------+
+--------------------------------------------------------------------------+
1) 创建Mysql用户
root@nginx1 ~ > useradd -r
mysql -s /sbin/nologin?
?
2) 准备数据目录和二进制存放目录
root@nginx1 ~ > mkdir /JY/{data,binlog}?
root@nginx1 ~ > chown -R mysql:mysql /JY/
root@nginx1 ~ > ll /JY/
total 0
drwxr-xr-x 2 mysql mysql 6 Oct 22 10:44 binlog
drwxr-xr-x 2 mysql mysql 6 Oct 22 10:44 data
root@nginx1 ~ >?
?
3) 安装cmkae
root@nginx1 ~ > tar xf cmake-3.0.1.tar.gz?
root@nginx1 ~ > cd cmake-3.0.1
root@nginx1 ~/cmake-3.0.1 > ./configure?
root@nginx1 ~/cmake-3.0.1 > make && make install
?
root@nginx1 ~ > tar xf mariadb-10.0.21.tar.gz?
root@nginx1 ~ > cd mariadb-10.0.21
root@nginx1 ~/mariadb-10.0.21 > cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/JY/data \
-DSYSCONFDIR=/etc \
-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?
?
root@nginx1 ~/mariadb-10.0.21 > make && make install
root@nginx1 ~/