Docker中MySQL容器的创建和连接教程

[root@private_work mysql]# docker version

mysql/
|-- cmake-3.2.2.tar.gz
|-- create_mysql_user.sh # mysql用户初始化脚本
|-- Dockerfile
|-- install_mysql-5.6.24.sh # mysql服务安装脚本
|-- my.f # mysql服务配置文件
|-- mysql-5.6.24.tar.gz
`-- supervisord.conf # 服务管理工具配置文件

# FROM: 依赖的镜像
FROM ted1993/mysql:5.6.24

＃MAINTAINER: 个人信息
MAINTAINER xuqiangqiang "739827282@qq."

＃ RUN: 执行命令
RUN yum -y install tar g-c++ supervisor ncurses-devel libtool bison bison-devel pwgen

RUN mkdir -p /var/log/supervisor

＃ ADD: 添加本地文件到容器中，如果是压缩包会在目标目录进行自动解压，如果只想添加文件可以使用 COPY命令
ADD ./supervisord.conf /etc/supervisord.conf
ADD ./cmake-3.2.2.tar.gz /root/tools/
ADD ./mysql-5.6.24.tar.gz /root/tools/
ADD ./install_mysql-5.6.24.sh /root/tools/
ADD ./create_mysql_user.sh /create_mysql_user.sh

# WORKDIR: 当前的工作目录
WORKDIR /root/tools/

RUN sh install_mysql-5.6.24.sh

ADD ./my.f /data/server/mysql-5.6.24/etc/my.f

RUN rm -rf /root/tools/mysql-5.6.24
RUN rm -rf /root/tools/mysql-5.6.24.tar.gz
RUN rm -rf /root/tools/cmake-3.2.2
RUN rm -rf /root/tools/cmake-3.2.2.tar.gz

# EXPOSE: 公开的端口，会暴露在外的端口
EXPOSE 22 3306

# CMD: 容器启动执行的命令 一个dockerfile只有一个cmd生效。
CMD ["/usr/bin/supervisord"]

[supervisord]
nodaemon=true

[program:mysqld]
mand=/etc/init.d/mysqld start
numprocs=1
autostart=true
autorestart=true

[program:sshd]
mand=/usr/sbin/sshd -D
numprocs=1
autostart=true
autorestart=true

#!/bin/bash
grep "^mysql:" /etc/passwd &> /dev/null || groupadd mysql && useradd -g mysql -s /sbin/nologin mysql


if [ ! -d cmake-3.2.2 ];then
tar xzvf cmake-3.2.2.tar.gz
fi
cd cmake-3.2.2
./bootstrap && gmake && gmake install && cd ..


if [ ! -d mysql-5.6.24 ];then
tar xzf mysql-5.6.24.tar.gz
fi
cd mysql-5.6.24
cmake \
-DCMAKE_INSTALL_PREFIX=/data/server/mysql-5.6.24 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_DATADIR=/data/mysql-5.6.24/ \
-DSYSCONFDIR=/data/server/mysql-5.6.24/etc/ \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_EXTRA_CHARSETS=plex \
-DENABLED_LOCAL_INFILE=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_unicode_ci \
-DWITH_DEBUG=0
CPU_NUM=$(cat /proc/cpuinfo | grep processor | wc -l)
if [ $CPU_NUM -gt 1 ];then
make -j$CPU_NUM
else
make
fi
make install

echo "PATH=\$PATH:/data/server/mysql/bin" >> /etc/profile && . /etc/profile
ln -s /data/server/mysql-5.6.24/ /data/server/mysql
rm -rf /etc/my.f

mkdir -p /data/server/mysql-5.6.24/etc/
mkdir -p /data/server/mysql/data/
mkdir -p /data/log/mysql/

chown -R mysql:mysql /data/server/mysql/
chown -R mysql:mysql /data/server/mysql/data/
chown -R mysql:mysql /data/log/mysql
\cp -f /data/server/mysql/support-files/mysql.server /etc/init.d/mysqld
sed -i 's#^basedir=$#basedir=/data/server/mysql#' /etc/init.d/mysqld
sed -i 's#^datadir=$#datadir=/data/server/mysql/data#' /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
/data/server/mysql/scripts/mysql_install_db --datadir=/data/server/mysql/data/ --basedir=/data/server/mysql --user=mysql

#!/bin/bash

/data/server/mysql/bin/mysqld_safe >> /dev/null 2>&1 &

RET=1
while [[ RET -ne 0 ]]; do
echo "=> Waiting for confirmation of MySQL service startup"
sleep 5
/data/server/mysql/bin/mysql -uroot -e "status" > /dev/null 2>&1
RET=$?
done


echo "============================MYSQL_PASS_INFO=============================== "
echo ""
PASS_ROOT=${MYSQL_PASS:-$(pwgen -s 8 1)}
PASS_DBA=${MYSQL_PASS:-$(pwgen -s 8 1)}
echo ""
echo "=> Creating MySQL root user with ${PASS_ROOT} password"
echo "=> Creating MySQL dba user with ${PASS_DBA} password"
echo ""
/data/server/mysql/bin/mysql -uroot -e "grant all privileges on . to 'dba'@'%' identified by '${PASS_DBA}'";
/data/server/mysql/bin/mysql -uroot -e "update mysql.user set password=PASSWORD('${PASS_ROOT}') where user='root' and host='localhost'";
echo ""
echo "===================================END====================================="
echo ""
echo "=> Done!"

echo ""
echo ""
echo "==============================REMOTE_MYSQL_PASSWORD====================="
echo "You can now connect to this MySQL Server using:"
echo ""
echo " mysql -udba -p${PASS_DBA} -h<host> -P<port>"
echo ""
echo "Please remember to change the above password as soon as possible!"
echo "MySQL user 'root' has no password but only allows local connections"
echo "========================================================================"

docker build -t ted1993/mysql:5.6.24 . # 注意面有一个"."

[root@private_work mysql]# docker images
REPOSITORY TAG IMAGE ID CREATED VIRTUAL SIZE
ted1993/mysql 5.6.24 d3ed9c578f4c 5 days ago 902.8 MB

docker run -d -P ted1993/mysql:5.6.24

[root@private_work mysql]# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ab622592bf1e mysql:5.6.24 "/usr/bin/supervisor 3 days ago Up 3 days 0.0.0.0:5000->22/tcp, 0.0.0.0:5001->3306/tcp jolly_swartz

FROM centos:centos6
MAINTAINER Fanbin Kong "kongxx@hotmail."

RUN yum install -y mysql-server mysql

RUN /etc/init.d/mysqld start &&\
mysql -e "grant all privileges on . to 'root'@'%' identified by 'letmein';"&&\
mysql -e "grant all privileges on . to 'root'@'localhost' identified by 'letmein';"&&\
mysql -u root -pletmein -e "show databases;"

EXPOSE 3306

CMD ["/usr/bin/mysqld_safe"]

sudo docker build -t kongxx/mysql_server .

FROM centos:centos6
MAINTAINER Fanbin Kong "kongxx@hotmail."

RUN yum install -y mysql

sudo docker build -t kongxx/mysql_client .

$ sudo docker images | grep kongxx
kongxx/mysql_client latest aa31f22f6fc5 2 hours ago 303.7 MB
kongxx/mysql_server latest 3b9b08c8dda4 2 hours ago 353.3 MB

sudo docker run --name=mysql_server -d -P kongxx/mysql_server

sudo docker run --name=mysql_client1 --link=mysql_server:db -t -i kongxx/mysql_client /usr/bin/mysql -h db -u root -pletmein

sudo docker run --name=mysql_client2 --link=mysql_server:db -t -i kongxx/mysql_client /usr/bin/mysql -h db -u root -pletmein

sudo docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
ac0c76c627c0 kongxx/mysql_client:latest /usr/bin/mysql -h db 10 seconds ago Up 9 seconds mysql_client2
763c4825722d kongxx/mysql_client:latest /usr/bin/mysql -h db 41 minutes ago Up 40 minutes mysql_client
32f7839f7e9d kongxx/mysql_server:latest /usr/bin/mysqld_safe About an hour ago Up About an hour 0.0.0.0:49153->3306/tcp mysql_client1/db,mysql_client2/db,mysql_server