Docker容器实现mysql主从节点部署

一.主节点部署

1.获取镜像及相关配置文件

docker run -p 3306:3306 \
 --name mysql-master \
 -v /opt/app/mysql-master/log:/var/log/mysql \
 -v /opt/app/mysql-master/data:/var/lib/mysql \
 -v /opt/app/mysql-master/conf:/etc/mysql \
 -v /opt/app/mysql-master/mysql.conf.d:/etc/mysql/mysql.conf.d \
 -v /opt/app/mysql-master/conf.d:/etc/mysql/conf.d \
 -e MYSQL_ROOT_PASSWORD=root \
 -d mysql:5.7

docker ps 查看镜像是否启动

2.主节点配置

vim /opt/app/mysql-master/conf/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

replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

二.从节点部署

1.获取镜像及相关配置文件

 docker run -p 3307:3306 \
 --name mysql-slave \
 -v /opt/app/mysql-slave/log:/var/log/mysql \
 -v /opt/app/mysql-slave/data:/var/lib/mysql \
 -v /opt/app/mysql-slave/conf:/etc/mysql \
 -v /opt/app/mysql-slave/mysql.conf.d:/etc/mysql/mysql.conf.d \
 -v /opt/app/mysql-slave/conf.d:/etc/mysql/conf.d \
 -e MYSQL_ROOT_PASSWORD=root \
 -d \
 --link mysql-master:mysql-master \
 mysql:5.7

docker ps 查看镜像是否启动

2.从节点配置

vim /opt/app/mysql-slave/conf/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

replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

三.master节点配置

下载mariadb yum -y install mariadb

1.登录mysql-master

mysql -h 192.168.255.157 -uroot -proot -P 3306

2.授权

grant replication slave on *.* to 'backup'@'%' identified by '123456';

3.重启容器，使用配置生效

docker restart mysql-master

4.查看状态

show master status\G

四.slave节点配置

1.重启容器 

docker restart mysql-slave

2.登录mysql-slave

mysql -h 192.168.255.157 -uroot -proot -P 3307

3.绑定主节点

change master to master_host='mysql-master', master_user='backup', master_password='123456', master_log_file='mysql-bin.000001', master_log_pos=154, master_port=3306;

4.启动从节点

start slave;

5.查看状态

show slave status\G