centos脚本安装mariadb-server（二进制）

安装包

已经编译好的二进制文件

1.maria-10.2.8

链接：http://pan.baidu.com/s/1nv3LrSX 密码：xyop

安装路径：/usr/locl/mysql
数据库文件路径: /app/mysqldb
日志文件路径：/var/log/mariadb/mariadb.log

2.maria-5.5.73

链接：http://pan.baidu.com/s/1geG88Un 密码：vfdu

    安装路径：/usr/locl/mysql
    数据库文件路径: /var/lib/mysql
    日志文件路径：/var/log/mariadb.log

安装脚本

#!/bin/bash
# ------------------------------------------
# Filename: mysql_install.sh   
# Date:    2017-10-12    
# Revision:   
# Author: 木子甘
# ID:16    
# Description:mysql_install，可以自动区分centos版本 
# ------------------------------------------

#判断版本
Version=`sed -r "s/.* ([^ ])[.].*/\1/" /etc/redhat-release`
lib_6=/var/lib/mysql
lib_7=/app/mysqldb
#1.卸载已经有的maria程序
rpm -e `rpm -qa mysql*` &>/dev/null
rpm -e `rpm -qa maria*` &>/dev/null
#2.创建系统账户mysql
if [ "$Version" -eq 7 ] ; then
        useradd -r -m -d $lib_7 -s /sbin/nologin  mysql
elif [ "$Version" -eq 6 ] ; then
        useradd -r -m -d $lib_6 -s /sbin/nologin  mysql
fi

#3.解压二进制文件到二进制程序的目标路径
if [ "$Version" -eq 7 ] ; then
        tar -xvf mariadb-10.2.8-linux-x86_64.tar.gz -C /usr/local/ &>/dev/null
        mv /usr/local/mariadb-10.2.8-linux-x86_64  /usr/local/mysql &>/dev/null
elif [ "$Version" -eq 6 ] ; then
        tar -xvf mariadb-5.5.57-linux-x86_64.tar.gz -C /usr/local/ &>/dev/null
        mv /usr/local/mariadb-5.5.57-linux-x86_64  /usr/local/mysql &>/dev/null
fi
#4.数据库文件创建
cd  /usr/local/mysql
if [ "$Version" -eq 7 ] ; then
        scripts/mysql_install_db --user=mysql --datadir=$lib_7 &>/dev/null
else
       scripts/mysql_install_db --user=mysql --datadir=$lib_6 &>/dev/null
fi

#5.配置文件创建 配置文件中要指向数据库文件
mkdir /etc/mysql/
cp /usr/local/mysql/support-files/my-huge.cnf /etc/mysql/my.cnf
if [ "$Version" -eq 7 ] ; then
        sed -r -i.bak "/^\[mysqld\]/s#.*#[mysqld] \n datadir = $lib_7 \n innodb_file_per_table = on \n skip_name_resolve = on#" /etc/mysql/my.cnf
elif [ "$Version" -eq 6 ] ; then
        sed -r -i.bak "/^\[mysqld\]/s#.*#[mysqld] \n datadir = $lib_6 \n innodb_file_per_table = on \n skip_name_resolve = on#" /etc/mysql/my.cnf
fi

#6.日志文件创建
if [ "$Version" -eq 7 ] ; then
        mkdir /var/log/mariadb
        touch /var/log/mariadb/mariadb.log
        chown  mysql:mysql  -R /var/log/mariadb
elif [ "$Version" -eq 6 ] ; then
        touch /var/log/mysqld.log
        chown  mysql:mysql   /var/log/mysqld.log
fi
#7.服务脚本创建
cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysqld 
#8.修改PATH路径
echo "PATH=/usr/local/mysql/maria_5/bin/:$PATH" >> /etc/profile.d/newvar.sh 
#9.启动mysql服务
service mysqld restart 
#10.安全脚本运行

unset Version lib_6 lib_7