一.主节点部署
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