Docker下mysql维护

待我称王封你为后i 2021-09-02 07:57 300阅读 0赞

# 一 下载镜像文件 #

docker pull mysql:5.7

# 二 创建实例并启动 #

docker run -p 3306:3306 --name mysql \
    -v /mydata/mysql/log:/var/log/mysql \
    -v /mydata/mysql/data:/var/lib/mysql \
    -v /mydata/mysql/conf:/etc/mysql \
    -e MYSQL_ROOT_PASSWORD=root \
    -d mysql:5.7

# 三 参数说明 #

\-p 3306:3306：将容器的 3306 端口映射到主机的 3306 端口

\-v /mydata/mysql/log:/var/log/mysql：将配置文件挂载到主机

\-v /mydata/mysql/data:/var/lib/mysql：将数据文件挂载到主机

\-v /mydata/mysql/conf:/etc/mysql：将配置文件挂载到主机

\-e MYSQL\_ROOT\_PASSWORD=root：初始化root用户的密码

\-d：后台运行

mysql:5.7：版本

# 四 docker容器文件挂载与端口映射  #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

# 五 mysql常见配置 #

[client]
    # 客户端连接字符集 默认为latin1不支持中文
    default-character-set=utf8
    
    [mysql]
    default-character-set=utf8
    
    # MySQL服务端参数
    [mysqld]
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    # 指定服务器字符集
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve

# 六 mysql的常用维护命令 #

[root@centos ~]# docker ps
    CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
    dace3a556b4c        mysql:5.7           "docker-entrypoint.s…"   13 minutes ago      Up 8 minutes        0.0.0.0:3306->3306/tcp, 33060/tcp   mysql
    [root@centos ~]# docker exec -it da /bin/bash
    root@dace3a556b4c:/# whereis mysql
    mysql: /usr/bin/mysql /usr/lib/mysql /etc/mysql /usr/share/mysql
    root@dace3a556b4c:/# ls
    bin  boot  dev    docker-entrypoint-initdb.d  entrypoint.sh  etc    home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
    root@dace3a556b4c:/# cd /var/log
    root@dace3a556b4c:/var/log# ls
    alternatives.log  apt  btmp  dpkg.log  faillog    lastlog  mysql    wtmp
    root@dace3a556b4c:/var/log# cd mysql
    root@dace3a556b4c:/var/log/mysql# cd /var/lib
    root@dace3a556b4c:/var/lib# ls
    apt  dpkg  misc  mysql    mysql-files  mysql-keyring  pam  systemd
    root@dace3a556b4c:/var/lib# cd mysql
    root@dace3a556b4c:/var/lib/mysql# ls
    auto.cnf    ca.pem         client-key.pem    ib_buffer_pool  ib_logfile1  ibtmp1  performance_schema    public_key.pem     server-key.pem
    ca-key.pem  client-cert.pem  dace3a556b4c.pid  ib_logfile0     ibdata1        mysql   private_key.pem    server-cert.pem  sys
    root@dace3a556b4c:/var/lib/mysql# exit
    exit
    [root@centos ~]# cd  /mydata/
    [root@centos mydata]# ls
    mysql
    [root@centos mydata]# cd mysql/
    [root@centos mysql]# ls
    conf  data  log
    [root@centos mysql]# vi /mydata/mysql/conf/my.cnf
    [root@centos mysql]# docker restart mysql
    mysql
    [root@centos mysql]# docker ps
    CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                               NAMES
    dace3a556b4c        mysql:5.7           "docker-entrypoint.s…"   39 minutes ago      Up 5 seconds        0.0.0.0:3306->3306/tcp, 33060/tcp   mysql
    [root@centos mysql]# docker exec -it da /bin/bash
    root@dace3a556b4c:/# cd /etc/mysql/
    root@dace3a556b4c:/etc/mysql# ls
    my.cnf
    root@dace3a556b4c:/etc/mysql# cat my.cnf
    [client]
    # 客户端连接字符集 默认为latin1不支持中文
    default-character-set=utf8
    
    [mysql]
    default-character-set=utf8
    
    # MySQL服务端参数
    [mysqld]
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    # 指定服务器字符集
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve
    root@dace3a556b4c:/etc/mysql# exit
    exit
    
    # docker 的 mysql自动启动
    [root@centos ~]# docker update mysql --restart=always

# 七 参考 #

[https://www.bilibili.com/video/BV1np4y1C7Yf?p=10][https_www.bilibili.com_video_BV1np4y1C7Yf_p_10]

[https://blog.csdn.net/h4241778/article/details/108901890][https_blog.csdn.net_h4241778_article_details_108901890]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/499d4e8addf740f0a0b6d707db4f3346.png
[https_www.bilibili.com_video_BV1np4y1C7Yf_p_10]: https://www.bilibili.com/video/BV1np4y1C7Yf?p=10
[https_blog.csdn.net_h4241778_article_details_108901890]: https://blog.csdn.net/h4241778/article/details/108901890