mysql5.7多執行個體安裝

標籤：x86   初始化   初始   tmp   --   x86_64   lib   ini   mysqld   

[[email protected]]# cd /opt/source
[[email protected]]#ls
mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
[[email protected]]# tar -zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
[[email protected]]#ln -s /opt/source/mysql-5.7.21-linux-glibc2.12-x86_64 /usr/local/mysql
[[email protected]]#groupadd -g 500 mysql
[[email protected]]#useradd -r -g mysql -u 500 -s /bin/false mysql

[[email protected]]#cd /usr/local/
[[email protected]]#chown -R mysql.mysql mysql

建立3306連接埠執行個體
[[email protected]]#mkdir -p /data/mysql_3306/{data,logs,run,tmp}
[[email protected]]#cd /data/mysql_3306/logs
[[email protected]]#touch mysql_error.log
[[email protected]]#chown -R mysql.mysql /data/mysql_3306/

[[email protected]]#vi /data/mysql_3306/my.cnf

初始化mysql
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql_3306/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_3306/data
啟動執行個體：
/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql_3306/my.cnf --user=mysql

建立3307連接埠執行個體
[[email protected]]#mkdir -p /data/mysql_3307/{data,logs,run,tmp}
[[email protected]]#cd /data/mysql_3307/logs
[[email protected]]#touch mysql_error.log
[[email protected]]#chown -R mysql.mysql /data/mysql_3307/

[[email protected]]#vi /data/mysql_3307/my.cnf

初始化mysql
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql_3307/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_3307/data
啟動執行個體：
/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysql_3307/my.cnf --user=mysql

 

mysql5.7多執行個體安裝