mysqlマルチインスタンス導入

Centos7.6 Mariadbインスタンスを3つ配備

[root@localhost ~]# yum install mariadb-server -y

#          
[root@localhost ~]# mkdir /mysql/{3306,3307,3308}/{data,etc,socket,log,bin,pid} -p

chown -R mysql.mysql /mysql

#         
[root@localhost ~]# mysql_install_db --datadir=/mysql/3306/data/ --user=mysql [root@localhost ~]# mysql_install_db --datadir=/mysql/3307/data/ --user=mysql [root@localhost ~]# mysql_install_db --datadir=/mysql/3308/data/ --user=mysql #          [root@localhost ~]# cp /etc/my.cnf /mysql/3306/etc #           [mysqld] port=3306 datadir=/mysql/3306/data socket=/mysql/3306/socket/mysql.sock symbolic-links=0 [mysqld_safe] log-error=/mysql/3306/log/mariadb.log pid-file=/mysql/3306/pid/mariadb.pid #    2             #                       [root@localhost ~]# vim /mysql/3306/bin/mysqld #!/bin/bash #chkconfig: 345 80 2 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...
" ${cmd_path}/mysqld_safe --defaults-file=${mysql_basedir}/${port}/etc/my.cnf &> /dev/null & else printf "MySQL is running...
" exit fi } function_stop_mysql() { if [ ! -e "$mysql_sock" ];then printf "MySQL is stopped...
" exit else printf "Stoping MySQL...
" ${cmd_path}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown fi } function_restart_mysql() { printf "Restarting MySQL...
" 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}
" esac #      [root@localhost ~]# /mysql/3306/bin/mysqld start Starting MySQL... [root@localhost ~]# /mysql/3307/bin/mysqld start Starting MySQL... [root@localhost ~]# /mysql/3308/bin/mysqld start Starting MySQL... #      mysql -S /mysql/3308/socket/mysql.sock -e 'select version()' +----------------+ | version() | +----------------+ | 5.5.60-MariaDB | +----------------+ #       [root@localhost ~]# /mysql/3306/bin/mysqld stop Stoping MySQL... Enter password: