Dockerfile编译安装mysql5.7镜像

创建mysql目录，编写Dockerfile

进入mysql目录中，编写Dockerfile，拉取mysql安装包

[root@localhost mysql]# ls
Dockerfile  mysql-boost-5.7.27.tar.gz

编写Dockerfile

[root@localhost mysql]# cat Dockerfile 
FROM daocloud.io/library/centos:7
MAINTAINER docker-server
RUN useradd -r mysql -M -s /sbin/nologin
RUN yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make && yum -y install cmake
RUN  mkdir -p /usr/local/{data,mysql,log}
ADD mysql-boost-5.7.27.tar.gz  /usr/local/
WORKDIR /usr/local/mysql-5.7.27/
RUN cmake . \
-DWITH_BOOST=boost/boost_1_59_0/ \ 
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1
RUN make && make install
RUN chown -R mysql.mysql /usr/local/mysql 
RUN  /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
RUN echo -e "[client] \n port = 3306 \n socket = /tmp/mysql.sock \n default-character-set = utf8 \n [mysqld] \n port = 3306 \n user = mysql \n basedir = /usr/local/mysql \n datadir = /usr/local/mysql/data \n socket = /tmp/mysql.sock \n character_set_server = utf8" > /etc/my.cnf
EXPOSE 3306
RUN echo "/usr/local/mysql/bin/mysqld_safe --user=mysql &" > /run.sh && chmod +x /run.sh && sh /run.sh
CMD ["usr/sbin/init"]

创建镜像 时间比较长，半小时起步

[root@localhost mysql]#  docker build -t mysql .

镜像占用空间10G左右，镜像存放位置空间需要足够大，否则创建镜像失败，可将其余镜像删除，重启虚拟机，清除缓存，或者扩容（需要是xfs）

注意初始化时的密码

创建并启动容器

[root@localhost mysql]# docker run -it -p 3306:3306 --name mysql mysql:latest  /bin/bash

在Dockerfile中数据库启动失败，则进行手动启动
进入容器，启动数据库失败

[root@758b7760bedb mysql]# ./bin/mysqld_safe --user=mysql &
[1] 23
[root@758b7760bedb mysql]# Logging to '/usr/local/mysql/data/758b7760bedb.err'.
2021-03-16T02:18:55.295676Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2021-03-16T02:19:09.119790Z mysqld_safe mysqld from pid file /usr/local/mysql/data/758b7760bedb.pid ended


[1]+  Done                    ./bin/mysqld_safe --user=mysql

查看报错日志

[root@758b7760bedb mysql]# cat data/758b7760bedb.err 

上网查询发现是初始化的问题
删除data下的数据，重新初始化
注意记录初始化后的密码
初始化后重新启动数据库，并查看端口号，使用密码进入数据库

[root@758b7760bedb mysql]# rm -rf data/*
[root@758b7760bedb mysql]# ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
2021-03-16T02:26:00.902468Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
2021-03-16T02:26:01.164284Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-03-16T02:26:01.192153Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-03-16T02:26:01.250692Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating 
2021-03-16T02:26:01.255851Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-03-16T02:26:01.257607Z 1 [Note] A temporary password is generated for root@localhost: <d<?hwOA-5kz
[root@758b7760bedb mysql]# ls data/
auto.cnf  ib_buffer_pool  ib_logfile0  ib_logfile1  ibdata1  mysql  performance_schema  sys
[root@758b7760bedb mysql]# ./bin/mysqld_safe --user=mysql &
[1] 257
[root@758b7760bedb mysql]# Logging to '/usr/local/mysql/data/758b7760bedb.err'.
2021-03-16T02:26:32.808815Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

[root@758b7760bedb mysql]# ps -ef|grep mysql
root        257    210  0 02:26 pts/1    00:00:00 /bin/sh ./bin/mysqld_safe --user=mysql
mysql       408    257  1 02:26 pts/1    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local60bedb.err --pid-file=758b7760bedb.pid --socket=/tmp/mysql.sock --port=3306

Dockerfile编译安装数据库创建成功