docker 安装mysql5.7

- 日理万妓 2021-09-28 11:26 343阅读 0赞

下载镜像

docker pull   mysql:5.7

查看镜像

docker image ls

创建自己的目录

mkdir -p /mysql/cnf  /mysql/data  /mysql/logs

创建自己的mysql配置文件

vi  /mysql/cnf/mysqld.cnf

# Copyright (c) 2014, 2016, Oracle and/or its affiliates. All rights reserved.
    #
    # This program is free software; you can redistribute it and/or modify
    # it under the terms of the GNU General Public License as published by
    # the Free Software Foundation; version 2 of the License.
    #
    # This program is distributed in the hope that it will be useful,
    # but WITHOUT ANY WARRANTY; without even the implied warranty of
    # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    # GNU General Public License for more details.
    #
    # You should have received a copy of the GNU General Public License
    # along with this program; if not, write to the Free Software
    # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA
    #
    # The MySQL  Server configuration file.
    #
    # For explanations see
    # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
    [mysqld]
    pid-file	= /var/run/mysqld/mysqld.pid
    socket		= /var/run/mysqld/mysqld.sock
    datadir		= /var/lib/mysql
    #log-error	= /var/log/mysql/error.log
    # By default we only accept connections from localhost
    #bind-address	= 127.0.0.1
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    server-id = 2
    sql_mode = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    default-time-zone='+8:00'
    #事务隔离级别，默认为可重复读，mysql默认可重复读级别（此级别下可能参数很多间隙锁，影响性能）
    transaction_isolation = READ-COMMITTED
    #数据库默认字符集, 主流字符集支持一些特殊表情符号（特殊表情符占用4个字节）
    character-set-server = utf8mb4
    #数据库字符集对应一些排序等规则，注意要和character-set-server对应
    collation-server = utf8mb4_general_ci 
    #设置client连接mysql时的字符集,防止乱码
    init_connect='SET NAMES utf8mb4'
    #是否对sql语句大小写敏感，1表示不敏感
    lower_case_table_names = 1
    #SQL数据包发送的大小，如果有BLOB对象建议修改成1G
    max_allowed_packet = 128M
    #MySQL连接闲置超过一定时间后(单位：秒)将会被强行关闭
    #MySQL默认的wait_timeout  值为8个小时, interactive_timeout参数需要同时配置才能生效
    interactive_timeout = 1800
    wait_timeout = 1800
    #内部内存临时表的最大值 ，设置成128M。
    #比如大数据量的group by ,order by时可能用到临时表，
    #超过了这个值将写入磁盘，系统IO压力增大
    tmp_table_size = 134217728
    max_heap_table_size = 134217728
    #order by 或group by 时用到
    #建议先调整为2M，后期观察调整
    sort_buffer_size = 2097152
    #一般数据库中没什么大的事务，设成1~2M，默认32kb
    binlog_cache_size = 524288
    #TIMESTAMP如果没有显示声明NOT NULL，允许NULL值
    explicit_defaults_for_timestamp = true
    ############################主从复制 设置 ########################################
    #开启mysql binlog功能
    log-bin=mysql-bin
    #步进值auto_imcrement 一般有n台主MySQL就填n
    auto_increment_increment=2   
    #起始值 一般填第n台主MySQL。此时为第一台主MySQL 第i台就填写i
    auto_increment_offset=1  
    #作为从库时生效, 想进行级联复制，则需要此参数
    log_slave_updates
    #作为从库时生效, 中继日志relay-log可以自我修复
    relay_log_recovery = 1
    #作为从库时生效, 主从复制时忽略的错误
    slave_skip_errors = ddl_exist_errors

创建并运行容器

docker run -p 3306:3306 --name mysql5.7 --privileged=true -v /mysql/cnf/mysqld.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf -v /mysql/logs:/logs -v /mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root123  -d mysql:5.7

查看容器

docker ps -a

查看容器日志

docker logs -f  容器id或者容器名

进入容器

docker exec  -it  容器id或者容器名  /bin/bash

\#查看mysql到底用的哪一个配置文件  
\#这些就是mysql默认会搜寻my.cnf的目录，顺序排前的优先。

mysql --help|grep 'my.cnf'
    root@1b320a4b490b:/# mysql --help|grep 'my.cnf'
                          order of preference, my.cnf, $MYSQL_TCP_PORT,
    /etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf