Detaillierte Erklärung zum Erstellen mehrerer Instanzen von MySQL 5.6 in einer CentOS7-Umgebung

> mkdir -p /mysql-instance/3308/data
> mkdir -p /mysql-instance/3309/data

> cp /data/mysql56/support-files/my-default.cnf /mysql-instance/3308/my.cnf
> cp /data/mysql56/support-files/my-default.cnf /mysql-instance/3309/my.cnf

> vi /mysql-instance/3308/my.cnf
> vi /mysql-instance/3309/my.cnf

[Kunde]
Port = 3308
Socket = /mysql-Instanz/3308/mysql.sock
[mysql]
kein automatisches Wiederaufwärmen
[mysqld]
Benutzer = MySQL
Port = 3308
Socket = /mysql-Instanz/3308/mysql.sock
basedir = /data/mysql56
Datenverzeichnis = /mysql-instance/3308/data
pid-Datei = /mysql-instance/3308/mysql.pid
Relay-Log = /mysql-Instanz/3308/Relay-Bin
Relay-Log-Info-Datei = /mysql-instance/3308/relay-log.info
Server-ID = 12
[mysqld_safe]
log-fehler = /mysql-instance/3308/mysql.err
pid-Datei = /mysql-instance/3308/mysql.pid

>vi /mysql-instance/3308/mysql
>vi /mysql-instance/3309/mysql

#!/bin/sh
Port = 3308
mysql_user="Stamm"
#Bitte geben Sie Ihr eigenes Datenbankkennwort ein mysql_pwd="123456"
cmd_path="/data/mysql56/bin"
mysql_sock="/mysql-instanz/${port}/mysql.sock"
mysql_start() {
  wenn [ ! -e "$mysql_sock" ];dann
    printf "mysql start … \n"
    /bin/sh ${cmd_path}/mysqld_safe --defaults-file=/mysql-instance/${port}/my.cnf 2>&1 > /dev/null &
  anders
    printf "mysql läuft ... \n"
    Ausfahrt
  fi
}
mysql_stop() {
  wenn [ ! -e "$mysql_sock" ];dann
    printf "mysql wurde gestoppt … \n"
    Ausfahrt
  anders
    printf "mysql stop … \n"
    ${cmd_path}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S /mysql-instance/${port}/mysql.sock herunterfahren
  fi
}
mysql_restart() {
  printf "mysql neu starten … \n"
  mysql_stop
  Schlaf 2
  mysql_start
}
Fall $1 in
  start) mysql_start ;;
  stopp)mysql_stop;;
  Neustart)mysql_restart ;;
*)
printf "Verwendung: /data/${port}/mysql {start|stop|restart}\n"
esac

> chown -R mysql.mysql /mysql-Instanz
> chmod 700 /mysql-instance/3308/mysql
> chmod 700 /mysql-instance/3309/mysql

> cd /daa/mysql56/scripts
> ./mysql_install_db --basedir=/data/mysql56 --datadir=/mysql-instance/3308/data --user=mysql
> ./mysql_install_db --basedir=/data/mysql56 --datadir=/mysql-instance/3309/data --user=mysql

> /mysql-instance/3308/mysql starten
> /mysql-instance/3309/mysql starten
> netstat -lntup|grep 330

> mysql -uroot -p -S /mysql-instance/3308/mysql.sock