docker重新打包mysql_docker重新打包MySQL5.7镜像

我不是女神ヾ 2022-10-25 01:48 355阅读 0赞

1：先下载MySQL镜像

\# docker pull  mysql:5.7

2：运行镜像生成容器

\# docker run --name mysql -p 3306:3306 -e MYSQL\\\_ROOT\\\_PASSWORD=123456  -d mysql:5.7

3：查看生成最新的容器

\# docker ps -l

CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES

64f075017f93        mysql:5.7                  "docker-entrypoint..."   17 minutes ago      Exited (1) 16 minutes ago                                 mysql

4：进入容器查看是否安装成功

\# docker exec -it mysql  bash

\[email protected\]:/\# mysql -uroot -p123456

Welcome to the MySQL monitor.  Commands end with ; or \\g.

Your MySQL connection id is 3

Server version: 5.7.22-log MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘\\h‘ for help. Type ‘\\c‘ to clear the current input statement.

MySQL \[(none)\]>

5：宿主机登录测试MySQL

\# mysql -uroot -p123456 -h192.168.1.20

Welcome to the MariaDB monitor.  Commands end with ; or \\g.

Your MySQL connection id is 4

Server version: 5.7.22-log MySQL Community Server (GPL)

Type ‘help;‘ or ‘\\h‘ for help. Type ‘\\c‘ to clear the current input statement.

MySQL \[(none)\]>

6：修改my.cnf配置文件

my.cnf配置文件

![3d55c55a16c40d63afc5b6ea9bfe6025.gif][]

![64bc1000f92f58db26193811c9d13956.gif][]

\# cat > /etc/mysql/my.cnf <

\[client\]

port= 3306socket= /var/run/mysqld/mysqld.sock

\[mysqld\]

port= 3306socket= /var/run/mysqld/mysqld.sock

back\_log= 80basedir= /usr

tmpdir= /tmp

datadir= /var/lib/mysql

\#-------------------gobal variables------------\#

slave-parallel-type=LOGICAL\_CLOCK

slave-parallel-workers=16slave\_preserve\_commit\_order=on

gtid\_mode=ON

relay\_log\_info\_repository=TABLE

master\_info\_repository=TABLE

relay\_log\_recovery=on

enforce\_gtid\_consistency=ON

binlog\_checksum=NONE

log\_slave\_updates=ON

log-bin = /var/lib/mysql/mysql-bin

max\_connect\_errors= 20000max\_connections= 2000wait\_timeout= 3600interactive\_timeout= 3600net\_read\_timeout= 3600net\_write\_timeout= 3600table\_open\_cache= 1024table\_definition\_cache= 1024thread\_cache\_size= 512open\_files\_limit= 10000character-set-server =utf8

collation-server =utf8\_bin

skip\_external\_locking

performance\_schema= 1user=mysql

myisam\_recover\_options=DEFAULT

skip-name-resolve

local\_infile= 0lower\_case\_table\_names= 0\#--------------------innoDB------------\#

innodb\_buffer\_pool\_size=2000M

innodb\_data\_file\_path=ibdata1:200M:autoextend

innodb\_flush\_log\_at\_trx\_commit= 1innodb\_io\_capacity= 600innodb\_lock\_wait\_timeout= 120innodb\_log\_buffer\_size=8M

innodb\_log\_file\_size=200M

innodb\_log\_files\_in\_group= 3innodb\_max\_dirty\_pages\_pct= 85innodb\_read\_io\_threads= 8innodb\_write\_io\_threads= 8innodb\_support\_xa= 1innodb\_thread\_concurrency= 32innodb\_file\_per\_table

innodb\_rollback\_on\_timeout

\#------------session variables-------\#

join\_buffer\_size=8M

key\_buffer\_size=256M

bulk\_insert\_buffer\_size=8M

max\_heap\_table\_size=96M

tmp\_table\_size=96M

read\_buffer\_size=8M

sort\_buffer\_size=2M

max\_allowed\_packet=64M

read\_rnd\_buffer\_size=32M

\#------------MySQL Log----------------\#

log-bin = my3306-bin

binlog\_format=row

sync\_binlog= 1expire\_logs\_days= 15max\_binlog\_cache\_size=128M

max\_binlog\_size=500M

binlog\_cache\_size=64k

slow\_query\_log

log-slow-admin-statements

log\_warnings= 1long\_query\_time= 0.25\#---------------replicate--------------\#

relay-log-index =relay3306.index

relay-log =relay3306

server-id =88init\_slave= ‘set sql\_mode=STRICT\_ALL\_TABLES‘log-slave-updates

\[myisamchk\]

key\_buffer=512M

sort\_buffer\_size=512M

read\_buffer=8M

write\_buffer=8M

\[mysql\]

prompt=MySQL \[\\\\d\]>default-character-set=utf8

\[mysqlhotcopy\]

interactive-timeout

\[mysqld\_safe\]

open-files-limit = 8192log-error = /var/lib/mysql/mysqld\_error.log

END

7：生成新的镜像

\# docker commit 64f075017f93  mysql:5.7.22

8：查看镜像

\# docker images

REPOSITORY                   TAG                 IMAGE ID            CREATED             SIZE

mysql                        5.7.22              1bc73a7082d4        20 minutes ago      372MB

mysql                        5.7                     66bc0f66b7af        2 weeks ago         372MB

9：测试新的镜像是否生效

\# docker run --name mysql\_test  -p 3306:3306 -e MYSQL\\\_ROOT\\\_PASSWORD=123456  -d mysql:5.7.22

\# docker exec -it mysql\_test  bash

查看/etc/mysql/my.cnf配置文件

宿主机登陆测试MySQL数据库

\# mysql -uroot -p123456 -h192.168.1.20

原文：https://www.cnblogs.com/manger/p/9342531.html

[3d55c55a16c40d63afc5b6ea9bfe6025.gif]: /images/20221024/6e0fa9f904514b7c9028ffa3cbf9fac8.png
[64bc1000f92f58db26193811c9d13956.gif]: /images/20221024/48ed3ef941f747878a98006a4ad5ea7d.png