用Dockerfile手动创建mysql5.7主从镜像

一、mysql-master

1.1 Dockerfile

首先，Dockerfile 长这样，具体的命令上面有解释。核心逻辑就是拷贝两个文件进去，然后在容器启动的时候执行 conf.sh，由 conf.sh 执行另外一个文件。

From mysql:5.7.25
MAINTAINER tigerfive tigerfive@aliyun.com

ENV MYSQL_ALLOW_EMPTY_PASSWORD yes
COPY conf.sh /mysql/conf.sh
COPY privileges.sql /mysql/privileges.sql

CMD ["sh", "/mysql/conf.sh"]

这里首先设置允许免密登录是为了方便后面配置，密码最后再通过 privileges.sql 来设置。

1.2 启动脚本

#!/bin/bash

set -e

echo '1. set server_id....'
sed -i '/\[mysqld\]/a server-id=1\nlog-bin=/var/log/mysql/mysql-bin\ngtid-mode=ON\nenforce-gtid-consistency=ON' /etc/mysql/mysql.conf.d/mysqld.cnf

echo '2. start mysql...'
service mysql start

echo '3. setting password...'
sed -i 's/MYSQLROOTPASSWORD/'$MYSQL_ROOT_PASSWORD'/' /mysql/privileges.sql
sed -i 's/MYSQLREPLICATIONUSER/'$MYSQL_REPLICATION_USER'/' /mysql/privileges.sql
sed -i 's/MYSQLREPLICATIONPASSWORD/'$MYSQL_REPLICATION_PASSWORD'/' /mysql/privileges.sql
mysql < /mysql/privileges.sql


echo '4. service mysql status'
echo 'mysql for tigerfive if ready...'

tail -f /dev/null

1.3 privileges.sql

这个文件是对 MySQL 进行一些权限配置，比如设置用户密码，创建新用户，数据库授权等。
后面两句很重要

use mysql;
set password for root@'localhost' = password("MYSQLROOTPASSWORD");
grant all on *.* to "MYSQLREPLICATIONUSER"@'%' identified by "MYSQLREPLICATIONPASSWORD" with grant option;
flush privileges;

构建镜像:
docker build -t tigerfive/mysql5.7-master:2.1 .


启动:
docker run  --name tigersql -e MYSQL_ROOT_PASSWORD="1234567" -e MYSQL_REPLICATION_USER="repl"  -e MYSQL_REPLICATION_PASSWORD="1234567"  -d tigerfive/mysql5.7-master:2.1


链接容器测试登陆
# docker exec -it tigersql bash

root@9fa3dcf5299e:/# mysql -uroot -p1234567
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5


查看权限:
mysql> select * from mysql.user where user='repl'\G
*************************** 1. row ***************************
                  Host: %
                  User: repl

成功创建mysql-master镜像

二、mysql-slave

1.1 Dockerfile

From mysql:5.7.25
MAINTAINER tigerfive tigerfive@aliyun.com

ENV MYSQL_ALLOW_EMPTY_PASSWORD yes
COPY conf.sh /mysql/conf.sh
COPY privileges.sql /mysql/privileges.sql

CMD ["sh", "/mysql/conf.sh"]

1.2 启动脚本

#!/bin/bash

set -e

echo '1. set server_id...'
RAND="$(date +%s | rev | cut -c 1-2)$(echo ${RANDOM})"
sed -i '/\[mysqld\]/a server-id='$RAND'\nlog-bin=/var/log/mysql/mysql-bin\ngtid-mode=ON\nenforce-gtid-consistency=ON' /etc/mysql/mysql.conf.d/mysqld.cnf


echo '2. start mysql...'
service mysql start

echo '3. setting password...'
sed -i 's/MYSQLROOTPASSWORD/'$MYSQL_ROOT_PASSWORD'/' /mysql/privileges.sql
sed -i 's/MYSQLMASTERSERVICEHOST/'$MYSQL_MASTER_SERVICE_HOST'/' /mysql/privileges.sql
sed -i 's/MYSQLREPLICATIONUSER/'$MYSQL_REPLICATION_USER'/' /mysql/privileges.sql
sed -i 's/MYSQLREPLICATIONPASSWORD/'$MYSQL_REPLICATION_PASSWORD'/' /mysql/privileges.sql


mysql < /mysql/privileges.sql

echo '4. service mysql status'
echo 'mysql for tigerfive if ready...'

tail -f /dev/null

1.3 privileges.sql

use mysql;
set password for root@'localhost' = password('MYSQLROOTPASSWORD');
flush privileges;
CHANGE MASTER TO master_host='MYSQLMASTERSERVICEHOST', master_user='MYSQLREPLICATIONUSER', master_password='MYSQLREPLICATIONPASSWORD' ;
START SLAVE;

制作镜像
docker build -t tigerfive/mysql5.7-slave:2.1  .


查看mysql-master的容器IP
docker inspect tigersql |grep IPAddr

ip为: 172.17.0.2


启动命令
docker run  --name tigersql2 -e MYSQL_ROOT_PASSWORD="1234567" -e MYSQL_MASTER_SERVICE_HOST="172.17.0.2" -e MYSQL_REPLICATION_USER='repl' -e MYSQL_REPLICATION_PASSWORD="1234567"   -d tigerfive/mysql5.7-slave:2.1

主从测试OK