1.安装mariadb

yum install mariadb

2.创建多实例对应的目录结构

@H_510_6@mkdir /MysqL/{3306,3307,3308}/{data,socket,log,bin,piD} -pv

chown -R Mysql.MysqL /MysqL

3.创建多实例的@R_450_9345@

@H_510_6@mysqL_install_db --datadir=/MysqL/3306/data/ --user=MysqL

@H_419_32@

@H_159_11@mysqL_install_db --datadir=/MysqL/3307/data/ --user=MysqL @H_159_11@mysqL_install_db --datadir=/MysqL/3308/data/ --user=MysqL

4.创建对应配置文件

cp /etc/my.cnf /MysqL/3306/etc
vim /MysqL/3306/etc/my.cnf
[MysqLd]
port=3306 加一行
datadir=/MysqL/3306/data
socket=/MysqL/3306/socket/Mysql.sock
[MysqLd_safe]
log-error=/MysqL/3306/log/mariadb.log
pid-file=/MysqL/3306/pid/mariadb.pid

cp /MysqL/3306/etc/my.cnf /MysqL/3307/etc/my.cnf
/MysqL/3307/etc/my.cnf

@H_674_63@

cp /MysqL/3306/etc/my.cnf /MysqL/3308/etc/my.cnf
/MysqL/3308/etc/my.cnf

5.准备各实例的启动脚本

vim /MysqL/{3306,3308}/bin/MysqLd
cat /mysq/3306/bin/MysqLd

#!/bin/bash  
port=3306  
MysqL_user="root"  
MysqL_pwd=" "  
cmd_path="/usr/bin"  
MysqL_basedir="/MysqL"  
MysqL_sock="${MysqL_basedir}/${port}/socket/Mysql.sock"  

function_start_MysqL()
{
    if [ ! -e "$MysqL_sock" ];then
      printf "StarTing Mysql...\n"
      ${CR_351_11845@d_path}/MysqLd_safe --defaults-file=${MysqL_basedir}/${port}/etc/my.cnf  &> /dev/null  &
    else
      printf "MysqL is running...\n"
      exit
    fi
}

function_stop_MysqL()
{
    if [ ! -e "$MysqL_sock" ];then
       printf "MysqL is stopped...\n"
       exit
    else
       printf "Stoping Mysql...\n"
       ${CR_351_11845@d_path}/MysqLadmin -u ${MysqL_user} -p${MysqL_pwD} -S ${MysqL_sock} shutdown
   fi
}

function_restart_MysqL()
{
    printf "RestarTing Mysql...\n"
    function_stop_MysqL
    sleep 2
    function_start_MysqL
}

case $1 in
start)
    function_start_MysqL
;;
stop)
    function_stop_MysqL
;;
restart)
    function_restart_MysqL
;;
*)
    printf "Usage: ${MysqL_basedir}/${port}/bin/MysqLd {start|stop|restart}\n"
esac