Docker-Compose部署MySQL

最新推荐文章于 2024-08-15 14:04:15 发布

Ene Takane

最新推荐文章于 2024-08-15 14:04:15 发布

阅读量590

点赞数 1

分类专栏： Docker MySQL 文章标签： docker mysql

本文链接：https://blog.csdn.net/qq_42325247/article/details/105142374

版权

Docker-Compose部署MySQL

文章目录

Docker-Compose部署MySQL

1、安装Docker

apt-get update
## 安装docker仓库
apt-get install apt-transport-https ca-certificates curl gnupg-agent software-properties-common

在这里插入图片描述

## 添加docker官方密钥
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
apt-key fingerprint 0EBFCD88
## 设置稳定版仓库
add-apt-repository \
> "deb [arch=amd64] https://download.docker.com/linux/ubuntu \
> $(lsb_release -cs) \
> stable"
## 安装最新版本的 Docker Engine-Community 和 containerd  
apt-get install docker-ce docker-ce-cli containerd.io
## 验证docker是否安装成功
docker --version

2、安装docker-compose

## 安装docker-compose
curl -L "https://github.com/docker/compose/releases/download/1.25.4/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
## 增加可执行权限
chmod +x /usr/local/bin/docker-compose
## 验证是否安装成功
docker-compose version

配置MySQL组的目录

# pwd
/test/docker-compose/mysql
# tree -L 3
.
├── docker-compose.yml
├── master
│   ├── data
│   ├── etc
│   │   └── my.cnf
│   └── init_db
│       └── init.sql
└── slave
    ├── etc
    │   └── my.cnf
    └── init_db
        └── init.sql
## 配置my.cnf文件
[mysqld]
server_id                       = 2002201      ## 主从不同
user                            = mysql
port                            = 3306
default_storage_engine                  = InnoDB
character_set_server                    = utf8mb4
skip-name-resolve                   = 1
skip-external-locking                   = 1
lower_case_table_names                  = 1
query_cache_type                        = 0
query_cache_size                            = 0
max_connections                     = 1000
default-time-zone                   = '+8:00'
log_timestamps                      = SYSTEM
 
innodb_strict_mode                  = 1
innodb_file_per_table