安装docker
安装docker,参考:https://www.runoob.com/docker/centos-docker-install.html
docker安装mysql5.7:
docker pull mysql:5.7
查看当前的docker中的镜像:
docker images
输出:
# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
zookeeper latest 611ffeaf5959 7 days ago 224MB
mysql 5.7 1e4405fe1ea9 2 weeks ago 437MB
配置mysql主从
mysql-master:
docker run -p 3307:3306 --name mysql-master \
-v /mydata/mysql/master/log:/var/log/mysql \
-v /mydata/mysql/master/data:/var/lib/mysql \
-v /mydata/mysql/master/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:5.7
说明:
-p 3307:3306
:将docker容器的3306端口映射到Centos主机的3307端口;--name mysql-master
:创建的docker容器名字为mysql-master;-v /mydata/mysql/master/log:/var/log/mysql
:将docker容器的/var/log/mysql
路径,映射到Centos主机的/mydata/mysql/master/log
路径;其他-v
雷同;-e MYSQL_ROOT_PASSWORD=root
:设置mysql root的密码为root
;-d mysql:5.7
:-d
后台启动mysql的5.7版本;
mysql-slaver:
docker run -p 3308:3306 --name mysql-slaver-01 \
-v /mydata/mysql/slaver/log:/var/log/mysql \
-v /mydata/mysql/slaver/data:/var/lib/mysql \
-v /mydata/mysql/slaver/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:5.7
查看正在运行的容器:
docker ps
输出:
查看所有的容器(包括运行和未运行):docker ps -a
上面是创建了两个mysql的容器,下面配置主从角色:
mysql-master:
vim /mydata/mysql/master/conf/my.cnf ## my.cnf不存在则创建
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection=utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve ## 跳过域名解析,使用客户端软件连接会快些,不是必须
server_id=1
log-bin=mysql-bin
read-only=0 ## 是否只读,主库可写可读
binlog-do-db=gmall_ums ## 需要同步哪些库,一一罗列
binlog-do-db=gmall_pms
binlog-do-db=gmall_oms
binlog-do-db=gmall_sms
binlog-do-db=gmall_cms
replicate-ignore-db=mysql ## 不同步哪些库
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
mysql-slaver:
vim /mydata/mysql/slaver/conf/my.cnf ## my.cnf不存在则创建
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection=utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve ## 跳过域名解析,使用客户端软件连接会快些,不是必须
server_id=2
log-bin=mysql-bin
read-only=1 ## 是否只读,从库设置为只读
binlog-do-db=gmall_ums ## 需要同步哪些库,一一罗列
binlog-do-db=gmall_pms
binlog-do-db=gmall_oms
binlog-do-db=gmall_sms
binlog-do-db=gmall_cms
replicate-ignore-db=mysql ## 不同步哪些库
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
上面配置完了之后两个数据库并不会自动进行同步,下面建立联系:
## 登录mysql-master的容器的控制台
docker exec -it mysql-master /bin/bash
## 登录mysql实例
mysql -uroot -proot
## 为master单独创建一个用于同步的账号:用户名backup,密码backup
mysql> grant replication slave on *.* to 'backup'@'%' identified by 'backup'
## 查看master的状态
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000001
Position: 439
Binlog_Do_DB: gmall_ums,gmall_pms,gmall_oms,gmall_sms,gmall_cms
Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)
## 登录mysql-slaver的容器的控制台
docker exec -it mysql-slaver /bin/bash
## 登录mysql实例
mysql -uroot -proot
1.
CHANGE MASTER TO
MASTER_HOST='192.168.61.136', ## mysql-master的ip
MASTER_USER='backup',
MASTER_PASSWORD='backup',
MASTER_PORT=3307, ## mysql-master开放的端口
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=0, ## 这里可以是0,mysql会自动找到对应的POS
MASTER_CONNECT_RETRY=10;
2. start slave;
致此,mysql master-slaver配置成功;
其他
-
例如删除名为mysql-master的container:
docker rm mysql-master
; -
查看某端口运行着的程序:
lsof -i:port
; -
重启docker:
systemctl restart docker
; -
运行/停止container:
docker start/stop mysql-master
; -
我理解的docker:
mysql-master的container:docker rm mysql-master
;
-
查看某端口运行着的程序:
lsof -i:port
; -
重启docker:
systemctl restart docker
; -
运行/停止container:
docker start/stop mysql-master
; -
查看日志,在启动mysql失败时,使用:
docker logs mysql-master
;参考:docker logs-查看docker容器日志 -
我理解的docker: