centos7 下Mariadb10.3 多实例安装

一，yum安装mariadb

yum -y install mariadb-server

### yum源配置
[root@test72 /etc/yum.repos.d] # cat  mariadb.repo  CentOS-Base.repo 
[mariadb]
name = MariaDB
baseurl =  https://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.3.14/yum/centos7-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck= 0
enabled=1

[base]
name=CentOS-$releasever - Base
baseurl=https://mirrors.aliyun.com/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

二，多实例安装

1，准备实例路径并修改权限

mkdir /data/mysql/3306/{data,etc,socket,log,bin,pid} -pv
chown -R mysql.mysql /data/mysql 

2，初始化实例的数据库文件

mysql_install_db   --datadir=/data/mysql/3306/data/ --user=mysql

Installing MariaDB/MySQL system tables in '/data/mysql/3306/data' ...
    OK

    To start mysqld at boot time you have to copy
    support-files/mysql.server to the right place for your system


    PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
    To do so, start the server, then issue the following commands:

    '/usr/bin/mysqladmin' -u root password 'new-password'
    '/usr/bin/mysqladmin' -u root -h test72.example.com password 'new-password'

    Alternatively you can run:
    '/usr/bin/mysql_secure_installation'

    which will also give you the option of removing the test
    databases and anonymous user created by default.  This is
    strongly recommended for production servers.

    See the MariaDB Knowledgebase at http://mariadb.com/kb or the
    MySQL manual for more instructions.

    You can start the MariaDB daemon with:
    cd '/usr' ; /usr/bin/mysqld_safe --datadir='/data/mysql/3306/data'

    You can test the MariaDB daemon with mysql-test-run.pl
    cd '/usr/mysql-test' ; perl mysql-test-run.pl

    Please report any problems at http://mariadb.org/jira

    The latest information about MariaDB is available at http://mariadb.org/.
    You can find additional information about the MySQL part at:
    http://dev.mysql.com
    Consider joining MariaDB's strong and vibrant community:
    https://mariadb.org/get-involved/

 

3,创建并修改实例的配置文件

cp  -a  /etc/my.cnf   mysql/3306/etc/

#修改配置文件，添加如下信息
[mysqld]
port=3306
datadir=/data/mysql/3306/data
socket=/data/mysql/3306/socket/mysql.sock

[mysqld_safe]
log-error=/data/mysql/3306/log/mariadb.log
pid-file=/data/mysql/3306/pid/mariadb.pid

 

4,准备实例的启动脚本，并为脚本增加执行权限

  

vi /data/mysql/3306/bin/mysqld 

chmod  +x  /data/mysql/3306/bin/mysqld 

 

启动脚本如下：

 

 1 #!/bin/bash
port=3306
mysql_user="root"
mysql_pwd=""
cmd_path="/usr/bin"
mysql_basedir="/data/mysql"
mysql_sock="${mysql_basedir}/${port}/socket/mysql.sock"

function_start_mysql()
{
    if [ ! -e "$mysql_sock" ];then
      printf "Starting MySQL...\n"
      ${cmd_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"
       ${cmd_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

5，启动并连接数据库

/data/mysql/3306/bin/mysqld  start

mysql  -S  /data/mysql/3306/socket/mysql.sock

6，安全加固

进入后修改密码并在/data/mysql/3306/bin/mysqld  中添加相应密码

7，关闭程序后发现PID和SOCKET文件都会消失，日志文件也会重写改变（？）。

├── log
│   └── mariadb.log
├── pid
└── socket

8，同一版本多实例依据以上流程操做。