多实例安装mysql 5.7的示例解析

这篇文章主要介绍多实例安装mysql 5.7的示例分析，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！
 
datadir:
 
mkdir -p /home/data/3306
 
mkdir -p /home/data/3307
 
mkdir -p /home/data/3308
 
chown -R mysql /home/data/
 
cd /opt/mysql
 
初始化mysql
 
./bin/mysqld --initialize --datadir=/home/data/3306 --user=mysql
 
./bin/mysqld --initialize --datadir=/home/data/3307 --user=mysql
 
./bin/mysqld --initialize --datadir=/home/data/3308 --user=mysql
 
启动mysql
 
bin/mysqld_safe --defaults-file=/opt/mysql/3306.cnf --user=mysql &
 
bin/mysqld_safe --defaults-file=/opt/mysql/3307.cnf --user=mysql &
 
bin/mysqld_safe --defaults-file=/opt/mysql/3308.cnf --user=mysql &
 
修改密码
 
注意:执行bin/mysqld --initialize的时候,日志会输出初始化的密码
 
关键字 A temporary password is generated for root@localhost:
 
mysql> set password = password('rootroot');
 
mysql> flush privileges;
 
配置环境变量
 
vim  /etc/profile 添加
 
export PATH=$PATH:/opt/mysql/bin
 
刷新环境变量
 
source /etc/profile
 
配置别名
 
vim /root/.bashrc
 
```
 
alias mysql3306='mysql -uroot -prootroot -P3306 --socket=/home/data/3306/mysql.sock'
 
alias start_mysql_3306='/opt/mysql/bin/mysqld_safe --defaults-file=/opt/mysql/3306.cnf --user=mysql &'
 
alias stop_mysql_3306='mysqladmin shutdown -uroot -p"rootroot" --socket=/home/data/3306/mysql.sock'
 
alias mysql3307='mysql -uroot -prootroot -P3307 --socket=/home/data/3307/mysql.sock'
 
alias start_mysql_3307='/opt/mysql/bin/mysqld_safe --defaults-file=/opt/mysql/3307.cnf --user=mysql &'
 
alias stop_mysql_3307='mysqladmin shutdown -uroot -p"rootroot" --socket=/home/data/3307/mysql.sock'
 
alias mysql3308='mysql -uroot -prootroot -P3308 --socket=/home/data/3308/mysql.sock'
 
alias start_mysql_3308='/opt/mysql/bin/mysqld_safe --defaults-file=/opt/mysql/3308.cnf --user=mysql &'
 
alias stop_mysql_3308='mysqladmin shutdown -uroot -p"rootroot" --socket=/home/data/3308/mysql.sock'
 
```
 
建立主从
 
change master to
 
MASTER_HOST="192.168.64.52",
 
MASTER_USER="root",
 
MASTER_PASSWORD="rootroot",
 
MASTER_PORT=3306,
 
MASTER_CONNECT_RETRY=10,
 
MASTER_AUTO_POSITION = 1;
 
编辑 /opt/mysql/3306.cnf
 
```
 
[mysql]
 
prompt = "\u@master \R:\m:\s [\d]> "
 
[client]
 
port  = 3306
 
socket = /data/mysql/data/mysql.sock
 
[mysqld]
 
datadir=/home/data/3306
 
socket=/home/data/3306/mysql.sock
 
skip-name-resolve
 
symbolic-links=0
 
log_bin = binlog
 
binlog_format= ROW
 
slow_query_log = 1
 
slow_query_log_file = slow.log
 
log-error = error.log
 
innodb_buffer_pool_size =512MB
 
innodb_buffer_pool_instances = 1
 
[mysqld_safe]
 
log-error=/home/data/3306/mysqld-err.log
 
```
 
编辑 /opt/mysql/3307.cnf
 
```
 
[mysql]
 
prompt = "\u@3307\R:\m:\s [\d]> "
 
[client]
 
port  =3307
 
socket = /data/mysql/data/mysql.sock
 
[mysqld]
 
datadir=/home/data/3307
 
socket=/home/data/3307/mysql.sock
 
skip-name-resolve
 
symbolic-links=0
 
log_bin = binlog
 
binlog_format= ROW
 
slow_query_log = 1
 
slow_query_log_file = slow.log
 
log-error = error.log
 
innodb_buffer_pool_size =512MB
 
innodb_buffer_pool_instances = 1
 
```
 
编辑 /opt/mysql/3308.cnf
 
```
 
[mysql]
 
prompt = "\u@3308\R:\m:\s [\d]> "
 
[client]
 
port  =3308
 
socket = /data/mysql/data/mysql.sock
 
[mysqld]
 
datadir=/home/data/3308
 
socket=/home/data/3308/mysql.sock
 
skip-name-resolve
 
symbolic-links=0
 
log_bin = binlog
 
binlog_format= ROW
 
slow_query_log = 1
 
slow_query_log_file = slow.log
 
log-error = error.log
 
innodb_buffer_pool_size =512MB
 
innodb_buffer_pool_instances = 1
 
```