docker部署数据库

mkdir -p /data/mysql/mysql5.7/{conf,data,log}

cd /data/mysql/mysql5.7

cat > conf/my.cnf <<EOF
[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
init_connect="SET collation_connection = utf8mb4_unicode_ci"
init_connect="SET NAMES utf8mb4"
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
skip-name-resolve
EOF


docker run -d \
  --name backup_mysql57 \
  -p 13306:3306 \
  -v /data/mysql/mysql5.7/data:/var/lib/mysql \
  -v /data/mysql/mysql5.7/conf:/etc/mysql/conf.d \
  -v /data/mysql/mysql5.7/log:/var/log/mysql \
  -e MYSQL_ROOT_PASSWORD=123456 \
  --restart=always \
  mysql:5.7
  
  
  
mkdir -p /data/mysql/mysql8.0/{conf,data,log}

cd /data/mysql/mysql8.0

cat > conf/my.cnf << 'EOF'
[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
port=3306
bind-address=0.0.0.0
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake

# 兼容旧客户端（如 Navicat），如需更高安全性可删除此行
default_authentication_plugin=mysql_native_password

max_connections=500
skip-name-resolve
EOF

docker run -d \
  --name backup_mysql57 \
  -p 23306:3306 \
  -v /data/mysql/mysql8.0/data:/var/lib/mysql \
  -v /data/mysql/mysql8.0/conf:/etc/mysql/conf.d \
  -v /data/mysql/mysql8.0/log:/var/log/mysql \
  -e MYSQL_ROOT_PASSWORD=123456 \
  --restart=always \
  mysql:8.0
  
  
mkdir -p /data/oracle/oracle11g/{data,log}
cd /data/oracle/oracle11g



docker run -d \
  --name backup_oracle11g \
  -p 11521:1521 \
  -v /data/oracle/oracle11g/data:/opt/oracle/oradata \
  -v /data/oracle/oracle11g/log:/opt/oracle/logs \
  --restart=always \
  -e ORACLE_PASSWORD=123456 \
  gvenzl/oracle-xe:11-slim-faststart
  
  
  
mkdir -p /data/sqlserver/sqlserver2019/{data,log}
cd /data/sqlserver/sqlserver2019/

docker run -d \
  --name backup_sqlserver2019 \
  -p 11433:1433 \
  -v /data/sqlserver/sqlserver2019/data:/var/opt/mssql/data \
  -v /data/sqlserver/sqlserver2019/log:/var/opt/mssql/log \
  -v /data/sqlserver/sqlserver2019/backup:/var/opt/mssql/backup \
  -e ACCEPT_EULA=Y \
  -e MSSQL_SA_PASSWORD='123456' \
  -e MSSQL_PID=Developer \
  -e MSSQL_AGENT_ENABLED=true \
  --restart=always \
  mcr.microsoft.com/mssql/server:2019-latest