docker-compose部署MySQL

一.安装docker(离线安装)

1.上传并解压安装包，可点此下载

tar -Pzxvf docker-19.03.8.tgz
cp docker/* /usr/bin/

2.注册docker服务为系统服务

cat <<EOF >> /etc/systemd/system/docker.service
[Unit]
Description=Docker Application Container Engine
Documentation=https://docs.docker.com
After=network-online.target firewalld.service
Wants=network-online.target
[Service]
Type=notify
# the default is not to use systemd for cgroups because the delegate issues still
# exists and systemd currently does not support the cgroup feature set required
# for containers run by docker
ExecStart=/usr/bin/dockerd
ExecReload=/bin/kill -s HUP $MAINPID
# Having non-zero Limit*s causes performance problems due to accounting overhead
# in the kernel. We recommend using cgroups to do container-local accounting.
LimitNOFILE=infinity
LimitNPROC=infinity
LimitCORE=infinity
# Uncomment TasksMax if your systemd version supports it.
# Only systemd 226 and above support this version.
#TasksMax=infinity
TimeoutStartSec=0
# set delegate yes so that systemd does not reset the cgroups of docker containers
Delegate=yes
# kill only the docker process, not all processes in the cgroup
KillMode=process
# restart the docker process if it exits prematurely
Restart=on-failure
StartLimitBurst=3
StartLimitInterval=60s
[Install]
WantedBy=multi-user.target
EOF

3.设置docker服务文件权限

# 设置文件权限
chmod +x /etc/systemd/system/docker.service

4.配置容器存储地址（可选）

vim /etc/docker/daemon.json

放入以下内容

{
  "data-root": "/data/docker"
}

注：以上文件将docker的容器存放位置设置为/data/docker/，此目录可修改或删除，若使用请确保该目录存在

重载配置文件

systemctl daemon-reload

二.启动docker

1.启动docker

systemctl start docker

2.设置开机自启

systemctl enable docker.service

3.验证

systemctl status docker

4.查看版本

docker -v

5.配置国内镜像源

vim /etc/docker/daemon.json

{
  "data-root": "/data/docker",
  "registry-mirrors": [
    "https://mirror.ccs.tencentyun.com",
    "https://hub-mirror.c.163.com",
    "https://mirror.baidubce.com"
  ]
}

若使用私有仓库地址(harbor、nexus)，请添加如下内容到daemon.json

"insecure-registries": ["IP:port"]

注：daemon.json修改后需要重载

systemctl daemon-reload

systemctl restart docker

三.安装docker-compose(离线安装)

1.github下载官方安装包，可以点此跳转

2.移动安装包

sudo mv docker-compose-linux-x86_64 /usr/local/bin/docker-compose

3.授权docker-compose权限

sudo chmod +x /usr/local/bin/docker-compose

4.查看版本

docker-compose -v

四.部署MySQL

1.创建存放目录

cd /data
mkdir docker-compose && cd docker-compose
mkdir mysql && cd mysql

2.创建挂载目录

cd /data/docker-compose/mysql
mkdir -p /data/docker-compose/mysql/data
mkdir -p /data/docker-compose/mysql/config

3.新建配置文件

vim /data/docker-compose/mysql/config/my.cnf

放入以下内容

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

4.编写docker-compose文件

vim /data/docker-compose/mysql/docker-compose.yml

放入以下内容

# 放入以下内容
version: '3'
services:
  mysql:
    image: mysql:8.0.31
    restart: always
    container_name: mysql
    environment:
      MYSQL_ROOT_PASSWORD: password
      TZ: Asia/Shanghai
    ports:
      - 3306:3306
    volumes:
      - /data/docker-compose/mysql/data:/var/lib/mysql
      - /data/docker-compose/mysql/config/my.cnf:/etc/mysql/my.cnf
    command:
      --max_connections=1000
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --default-authentication-plugin=mysql_native_password

5.启动mysql容器

cd /data/docker-compose/mysql/

docker-compose up -d