docker-mysql8-主从

向右看齐 2023-02-12 02:24 34阅读 0赞

**目录**

一、准备官方镜像

二、准备配置文件

三、测试mysql的启动

3.1 maste 配置

3.2 slave 配置

--------------------

## 一、准备官方镜像 ##

官方docker 镜像 https://hub.docker.com/\_/mysql

docker pull mysql:latest
    # 创建mysql网络
    docker network create mysql-net --subnet 172.1.2.0/24
    
    docker volume rm $(docker volume list |awk '{if(NR>0) print $2}')

主从规划

<table> 
 <thead> 
  <tr> 
   <th>role</th> 
   <th>ip</th> 
   <th>port</th> 
   <th>复制账号</th> 
   <th>password</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>master</td> 
   <td>172.1.2.2</td> 
   <td>3306</td> 
   <td>Slave</td> 
   <td>slave</td> 
  </tr> 
  <tr> 
   <td>slave</td> 
   <td>172.1.2.3</td> 
   <td>3307</td> 
   <td>-</td> 
   <td>-</td> 
  </tr> 
 </tbody> 
</table>

## 二、准备配置文件 ##

cd ~
    mkdir mysql  mysql/master mysql/slave
    cd mysql
    # master 配置文件
    echo "[mysqld]
    server-id=1
    log-bin=mysql-bin" >> master/mysql.cnf
    # slave 配置文件
    echo "[mysqld]
    server-id=2
    relay_log = /usr/local/mysql/data/mysql-relay-bin relay_log-index = /usr/local/mysql/data/mysql-relay-bin.index log_slave_updates = 1
    read_only=1" >> slave/mysql.cnf

## 三、测试mysql的启动 ##

### 3.1 maste 配置 ###

docker run --network mysql-net --name master -p 3306:3306 --ip 172.1.2.3 -e MYSQL_ROOT_PASSWORD=mysecret -d mysql:latest
    # 创建slave用户，并配置权限
    CREATE USER 'slave'@'172.1.2.%' IDENTIFIED WITH mysql_native_password BY 'slave';
    select user,host from mysql.user;
    GRANT REPLICATION SLAVE ON *.* TO 'slave'@'172.1.2.%';
    # mysql master配置 mysql.cnf
    docker cp master/mysql.cnf master:/etc/mysql/conf.d/mysql.cnf
    # 修改配置之后，一定要重启
    docker restart master
    # 验证binlog文件是否开启 
    show global variables like '%log_bin%';

### 3.2 slave 配置 ###

docker run --network mysql-net --name slave -p 3307:3306 --ip 172.1.2.4 -e MYSQL_ROOT_PASSWORD=mysecret -d mysql:latest
    # mysql slave配置 mysql.cnf
    docker cp slave/mysql.cnf slave:/etc/mysql/conf.d/mysql.cnf
    # 修改配置之后，一定要重启
    docker restart slave
    # 指定主节点ip，端口，用户，并配置主从
    change master to master_host='172.1.2.3',master_port=3306,master_user='slave',master_password='slave';
    # 或部分复制
    change master to master_host='192.168.81.132',master_port=3306,master_user='slave',master_password='slave',master_log_file='mysql- bin.000002',master_log_pos=155;
    start slave;
    #检测
    show slave status;