mysql主从搭建

在master 机器 下创建

    sudo  mkdir  -p  /usr/local/mysql/master/conf.d
	sudo  mkdir  -p  /usr/local/mysql/master/datadir
	sudo   vim      /usr/local/mysql/master/conf.d/my.cnf
    [mysqld]
	pid-file        = /var/run/mysqld/mysqld.pid
	socket          = /var/run/mysqld/mysqld.sock
	datadir         = /var/lib/mysql
	secure-file-priv= NULL
	symbolic-links=0

	log-bin=mysql-bin
	server-id=1
	!includedir /etc/mysql/conf.d/

在 slave 机器下创建

sudo  mkdir  -p  /usr/local/mysql/slave/conf.d
	sudo  mkdir  -p  /usr/local/mysql/slave/datadir
	sudo   vim      /usr/local/mysql/slave/conf.d/my.cnf

将server-id 改为2
在portainer 管理工具 下执行

version: "3"

services:
  mysql-master:
    container_name: master
    image: mysql
    restart: always
    ports:
      - 3306:3306
    volumes:
      - /usr/local/mysql/master/datadir:/var/lib/mysql
      - /usr/local/mysql/master/conf.d:/etc/mysql/conf.d
    environment:
      - MYSQL_ROOT_PASSWORD=******
    networks:
      - mysql
  mysql-slave:
    container_name: slave
    image: mysql
    restart: always
    ports:
      - 3306:3306
    volumes:
      - /usr/local/mysql/slave/datadir:/var/lib/mysql
      - /usr/local/mysql/slave/conf.d:/etc/mysql/conf.d
    environment:
      - MYSQL_ROOT_PASSWORD=******
    networks:
      - mysql

networks:
  mysql:
    external: true

进入master 容器

docker exec –it   master  bash 

登录 mysql

Mysql  -u root  -p 

Master 创建 一个slave账户

Create  user 'slave'@'%' INENTIFIED BY
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%'; 

查看master 连接状态

show master  status 

登录slave后 执行下面命令

登录slave后 执行下面命令

slave change master to  master_host ='masterIP', master_user='slaveuser' ,master_log_pos=155 ,master_log_file='mysql-bin.000005' ,master_port=3306,master_password='**********!';

注意：master_log_file，master_log_pos 值需要跟master值对应就刚刚 show master status 查询到的值复制过来

最后查看集群同步状态：

show slave status \G;

这2个参数为YES 代表主从，读写ok
Slave_IO_Running : YES
Slave_SQL_Running : YES