创建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编译安装数据库创建成功