docker离线版安装mysql8.0及主从备份

1、导入mysql8镜像

docker load -i mysql8.tar

2、创建主节点

docker run -id --name=mysql-master  -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 -e TZ=Asia/Shanghai -v /etc/mysql/master/config:/etc/mysql/conf.d -v /etc/mysql/msater/data:/var/lib/mysql mysql:8.0

3、在/etc/mysql/master/config创建配置文件my.cnf

# 文件名必须为my.cnf   不能为mysqld.cnf
touch /etc/mysql/master/config my.cnf  

主节点配置文件（仅供参考）

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
# log-error      = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address   = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
# symbolic-links=0
 
init_connect='SET collation_connection = utf8mb4_0900_ai_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
[client]
default-character-set=utf8mb4
 
 
[mysqld]
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
## 设置server