17. Docker应用-Docker部署MySQL

单机

基础配置

• 创建目录

mkdir -p /data/mysql/{data,logs,conf}

• 编辑配置文件

cat > /data/mysql/conf/my.cnf << EOF
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
pid-file = /var/run/mysqld/mysqld.pid
max_connections = 100
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4
default-storage-engine = INNODB

[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
EOF

下载镜像

docker pull mysql:5.7.31

部署服务

docker run -d --name mysql-5.7 \
-p 3306:3306 \
--restart=always \
-e MYSQL_ROOT_PASSWORD="Whaty@123" \
-v /data/mysql/data:/var/lib/mysql \
-v /data/mysql/logs:/var/log/mysql \
-v /data/mysql/conf:/etc/mysql/conf.d \
mysql:5.7.31

验证服务

主从

基础配置

• 创建目录

mkdir -p /data/mysql/{master,slaver}/{data,logs,conf}

• 编辑配置文件-master

cat > /data/mysql/master/conf/my.cnf << EOF
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
pid-file = /var/run/mysqld/mysqld.pid
max_connections = 100
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4
default-storage-engine = INNODB

#主从复制
server_id = 01
log-bin = mysql-master-bin
binlog-ignore-db = information_schema
binlog-ignore-db = mysql
binlog-ignore-db = performance_schema
binlog_cache_size = 1M
binlog_format = mixed
expire_logs_days = 180
slave_skip_errors = 1062

[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
EOF

• 编辑配置文件-slaver

cat > /data/mysql/slaver/conf/my.cnf << EOF
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
pid-file = /var/run/mysqld/mysqld.pid
max_connections = 100
collation-server = utf8mb4_unicode_ci
character-set-server = utf8mb4
default-storage-engine = INNODB

#主从复制
server_id = 02
log-bin = mysql-slaver-bin
binlog-ignore-db = information_schema
binlog-ignore-db = mysql
binlog-ignore-db = performance_schema
binlog_cache_size = 1M
binlog_format = mixed
expire_logs_days = 180
slave_skip_errors = 1062
relay_log = mysql-relay-bin
log_slave_updates = 1
read_only = 1

[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
EOF

下载镜像

docker pull mysql:5.7.31

部署服务

• 部署master

docker run -d --name mysql-master \
-p 3316:3306 \
--restart=always \
-e MYSQL_ROOT_PASSWORD="Whaty@123" \
-v /data/mysql/master/data:/var/lib/mysql \
-v /data/mysql/master/logs:/var/log/mysql \
-v /data/mysql/master/conf:/etc/mysql/conf.d \
mysql:5.7.31

• 部署slaver

docker run -d --name mysql-slaver \
-p 3326:3306 \
--restart=always \
-e MYSQL_ROOT_PASSWORD="Whaty@123" \
-v /data/mysql/slaver/data:/var/lib/mysql \
-v /data/mysql/slaver/logs:/var/log/mysql \
-v /data/mysql/slaver/conf:/etc/mysql/conf.d \
mysql:5.7.31

• 配置主从-master配置

#创建主从用户
docker exec -it mysql-master \
mysql -uroot -p'Whaty@123' \
-e "create user 'slave'@'%' identified by 'whaty1212';"

#为主从用户授权
docker exec -it mysql-master \
mysql -uroot -p'Whaty@123' \
-e "grant replication slave,replication client on *.* to 'slave'@'%';"

#让配置生效
docker exec -it mysql-master \
mysql -uroot -p'Whaty@123' \
-e "FLUSH PRIVILEGES;"

#检查主库配置
docker exec -it mysql-master \
mysql -uroot -p'Whaty@123' \
-e "show master status;"

• 配置主从-slaver配置

#配置主从复制
docker exec -it mysql-slaver \
mysql -uroot -p'Whaty@123' \
-e "change master to master_host='192.168.108.128', master_user='slave', master_password='whaty1212', master_port=3316, master_log_file='mysql-master-bin.000004', master_log_pos=154, master_connect_retry=30;"

#开启主从同步
docker exec -it mysql-slaver \
mysql -uroot -p'Whaty@123' \
-e "start slave;"

#查看主从状态
docker exec -it mysql-slaver \
mysql -uroot -p'Whaty@123' \
-e "show slave status \G;"

验证服务

• 创建数据库

docker exec -it mysql-master \
mysql -uroot -p'Whaty@123' \
-e "create database test;"

• 查看同步

docker exec -it mysql-slaver \
mysql -uroot -p'Whaty@123' \
-e "show databases;"

集群