快捷導(dǎo)航

docker部署mysql及制作鏡像壓縮包實(shí)踐

更新時間：2026年01月10日 14:39:40 作者：愛吃蘿卜的美羊羊

這篇文章主要介紹了docker部署mysql及制作鏡像壓縮包實(shí)踐,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教

拉取mysql鏡像

1、需要先配置docker加速鏡像

sudo mkdir -p /etc/docker

sudo tee /etc/docker/daemon.json <<EOF
{
    "registry-mirrors": ["https://docker.wctmd.us.kg"]
}
EOF
 
sudo systemctl daemon-reload
sudo systemctl restart docker

如果不配置是無法拉取mysql鏡像的，如下

配置后執(zhí)行拉取命令：

執(zhí)行如下命令可查看已拉取的鏡像及版本

docker images

也可設(shè)置特點(diǎn)版本下載所需要的mysql鏡像，如：

docker pull mysql:5.7

我下載了mysql5.7版本的鏡像

2、制作壓縮包

docker save -o mysql.tar mysql

mysql.tar 壓縮包名稱

mysql 本地mysql鏡像名稱

刪除mysql鏡像

docker rmi mysql

現(xiàn)在我本地只剩mysql5.7的鏡像

切換到壓縮包的目錄，用本地壓縮包加載鏡像，這樣就不用每次都遠(yuǎn)程去拉取鏡像

docker load -i mysql.tar

3、用鏡像部署mysql容器

需要把mysql配置文件my.cnf上傳,my.cnf內(nèi)容如下：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.3/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.3/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password
host-cache-size=0
skip-name-resolve
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
secure-file-priv=/var/lib/mysql-files
user=mysql
default-time-zone='Asia/Shanghai'
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/var/run/mysqld/mysqld.sock

!includedir /etc/mysql/conf.d/

其中要注意設(shè)置mysql時區(qū)，上面的配置我加了時區(qū)，不然數(shù)據(jù)庫默認(rèn)是UTC時區(qū)

default-time-zone='Asia/Shanghai'

把my.cnf上傳到/usr/local/mysql目錄下

執(zhí)行下面命令即可部署mysql容器

docker run -d --restart=always --name mysql -p 3307:3306 -v /usr/local/mysql/data:/var/lib/mysql -v /usr/local/mysql/my.cnf:/etc/mysql/conf.d/my.cnf -e MYSQL_ROOT_PASSWORD=123456 mysql

注意3307是宿主機(jī)端口，3306是容器內(nèi)部mysql端口，

--restart=always 表示把mysql容器設(shè)置到開機(jī)啟動服務(wù)中，系統(tǒng)重啟后,mysql容器隨機(jī)啟動

-v /usr/local/mysql/data:/var/lib/mysql -v /usr/local/mysql/my.cnf:/etc/mysql/conf.d/my.cnf 是把mysql數(shù)據(jù)庫數(shù)據(jù)、配置文件掛載到宿主機(jī)中，即使刪除了容器，mysql數(shù)據(jù)還存在，不丟失。每次用上面的命令重新部署容器，數(shù)據(jù)庫數(shù)據(jù)和配置文件都會自動加載到容器中。

查看MySQL容器是否部署成功：