docker系列7： docker搭建mysql

骑猪看日落 2022-03-29 14:17 284阅读 0赞

### 文章目录 ###

*  1, 启动docker-mysql服务
 *  2, nginx.conf配置

docker安装三大数据库：oracle,sqlserver,mysql

#oracle_12c 服务
    docker run -d  -it --net=host --name oracle12c \
     -v OracleDBData:/ORCL \
     --restart=always  store/oracle/database-enterprise:12.2.0.1
    # 登陆oracle12c容器
    # docker exec -it oracle12c bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
    # SQL> sqlplus sys/Oradoc_db1@ORCLCDB as sysdba
    
    #oracle_11g 服务
    #docker run -d --net=host --name=oracle \
    -v oracle_app:/home/oracle/app/oracle/ \
    --restart=always registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
    # 登陆oracle_11g 容器
    # docker exec -it oracle bash -c "source /home/oracle/.bash_profile; sqlplus /nolog"
    # SQL> sqlplus system/helowin@helowin as sysdba
    
    #mysql 服务
    #docker run -d --net=host --name=mysql -v mysql-date:/var/lib/mysql \
     -v mysql-conf:/etc/mysql  -e MYSQL_ROOT_PASSWORD=123456  \
     --restart=always   mysql:5.7
    
    #sqlserver 服务
    #docker run -d --net=host --name=mssql \
      -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=AAAaaa123!' \
      -v mssql_db:/var/opt/mssql \
      --restart=always  microsoft/mssql-server-linux

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V5ZW9mZWFnbGU_size_16_color_FFFFFF_t_70]  
使用场景： 在windows server 2012 服务器上使用docker-mysql服务， 由于docker windows使用的是virtualbox 虚拟机安装的容器， 所以使用docker run -p xx:xx 不能让外界直接访问，所以用到了nginx来反向代理，实现windows —> docker:mysql

# 1, 启动docker-mysql服务 #

*  mysql5.5

#使用端口转发：效率低　-p 3306:3306 
    #使用宿主机端口：效率高　--net=host  
    
    #--net=host 
    docker run  -d  --name mysql \
    -p 3306:3306 \
    -v mysql-data:/var/lib/mysql  \
    -e MYSQL_ROOT_PASSWORD=123456  \
    --restart=always \
    mysql:5.5 --character-set-server=utf8

*  mysql5.7

docker run  -d  --name mysql_cdh \
    -p 3306:3306 \
    -v mysql-data:/var/lib/mysql  \
    -e MYSQL_ROOT_PASSWORD=123456  \
    --restart=always \
    mysql:5.7  --character-set-server=utf8
    
    #配置mysql
    docker exec -it mysql_cdh bash
    cat  >>/etc/mysql/my.cnf <<EOF
    [mysqld] 
    bind-address = 0.0.0.0
    character-set-server=utf8  
    EOF
    
    #创建数据库
    mysql -uroot -p123456 -e "drop database if exists hive ; create database hive default charset utf8";
    mysql -uroot -p123456 -e "drop database if exists oozie; create database oozie default charset utf8";
    mysql -uroot -p123456 -e "drop database if exists hue; create database hue default charset utf8";
    exit

*  mysql8

docker run  -d  --name mysql_cdh  \
    -p 3308:3306 \
    -v mysql-data:/var/lib/mysql  \
    -v mysql-conf:/etc/mysql \
    -e MYSQL_ROOT_PASSWORD=123456  \
    --restart=always \
    mysql:8.0.15 --character-set-server=utf8
    
    改localhost登陆密码：　ALTER USER "root"@"localhost" IDENTIFIED  BY "123456";
    
    远程连接报错：Authentication plugin 'caching_sha2_password' cannot be loaded
    ==== > 改远程登陆的密码：　　ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    
    jdbc连接报错：java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
    ===>更换驱动：　mysql-connector-java-5.1.21.jar包换成mysql-connector-java-8.0.11.jar

# 2, nginx.conf配置 #

添加如下配置 ，注意\[stream\] 要和\[http\]同级

stream {
    	upstream mysql{
    		hash $remote_addr consistent;
    		server 192.168.99.100:3306 max_fails=3 fail_timeout=30s;
    	}
          
    	server {
    		listen 3306;
    		proxy_connect_timeout 3000s;
    		proxy_timeout 6000s;
    		proxy_pass mysql;									
    	}    
    }
    
    #http{ 
    #	............
    #}

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V5ZW9mZWFnbGU_size_16_color_FFFFFF_t_70]: /images/20220329/59b67f7dd42b4e788f8a83501b2a252e.png