在Docker中快速构建多种数据库测试环境（含Oracle、MySQL、PG、MSSQL、GreenPlum、OB、TiDB等）

docker run -d --name lhrcentos76 -h lhrcentos76 \
  -p 227:22 -p 3387:3389 \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true lhrbest/lhrcentos76:9.0 \
  /usr/sbin/init

root@lhrxxt:~# docker ps
CONTAINER ID   IMAGE                     COMMAND            CREATED       STATUS         PORTS                                                                            NAMES
c542bc126bbc   lhrbest/lhrcentos76:9.0   "/usr/sbin/init"   11 days ago   Up 7 seconds   0.0.0.0:227->22/tcp, :::227->22/tcp, 0.0.0.0:3387->3389/tcp, :::3387->3389/tcp   lhrcentos76
root@lhrxxt:~# 
root@lhrxxt:~# docker exec -it lhrcentos76 bash
[root@lhrcentos76 /]# cat /etc/redhat-release 
CentOS Linux release 7.6.1810 (Core) 

root@lhrxxt:~# docker start lhroracle21c
lhroracle21c
root@lhrxxt:~# docker exec -it lhroracle21c bash
[root@lhroracle21c /]# su - oracle
Last login: Sun Sep  4 20:45:52 CST 2022 on pts/0
[oracle@lhroracle21c ~]$ sas

SQL*Plus: Release 21.0.0.0.0 - Production on Tue Sep 13 15:07:53 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@LHRCDB> startup
ORACLE instance started.

Total System Global Area  859829400 bytes
Fixed Size                  9692312 bytes
Variable Size             532676608 bytes
Database Buffers          310378496 bytes
Redo Buffers                7081984 bytes
Database mounted.
Database opened.
SYS@LHRCDB> show pbds
SP2-0158: unknown SHOW option "pbds"
SYS@LHRCDB> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB2                           READ WRITE NO
SYS@LHRCDB> exit
Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
[oracle@lhroracle21c ~]$ exit
logout
[root@lhroracle21c /]# exit
exit
root@lhrxxt:~# exit
logout
PS C:\Users\lhr\Desktop> wsl
root@lhrxxt:~# docker ps
CONTAINER ID   IMAGE                              COMMAND            CREATED       STATUS         PORTS

                                                NAMES
68ef9ba74c02   lhrbest/oracle21c_ee_db_21.3.0.0   "/usr/sbin/init"   10 days ago   Up 7 minutes   5502-5510/tcp, 0.0.0.0:1530->1521/tcp, :::1530->1521/tcp, 0.0.0.0:3400->3389/tcp, :::3400->3389/tcp, 0.0.0.0:5510->5500/tcp, :::5510->5500/tcp, 0.0.0.0:55100->5501/tcp, :::55100->5501/tcp   lhroracle21c
root@lhrxxt:~#

root@lhrxxt:~# docker pull postgres:14.5 
14.5: Pulling from library/postgres
7a6db449b51b: Pull complete 
b4f184bc0704: Pull complete 
606a73c0d34a: Pull complete 
c39f1600d2b6: Pull complete 
31f42f92b0fe: Pull complete 
c8b67d2b0354: Pull complete 
31107b8480ee: Pull complete 
b26434cf8bfa: Pull complete 
36220bd76bfa: Pull complete 
b79e75c4a0c2: Pull complete 
cc1ab699dda5: Pull complete 
37312064dd9b: Pull complete 
4bce56fcbfe5: Pull complete 
Digest: sha256:10e195b76c4e51f5a8c0c5686ce15c3d701f7f13c7003d50f40502b69c18fe5f
Status: Downloaded newer image for postgres:14.5
docker.io/library/postgres:14.5
root@lhrxxt:~# docker run --name lhrpg14 -h lhrpg14 -d -p 54327:5432 -e POSTGRES_PASSWORD=lhr -e TZ=Asia/Shanghai postgres:14.5
9395477ca203bc5f4b82f886e888a5724b22cddf051e528e00db68b281c53e25
root@lhrxxt:~# docker exec -it lhrpg14 bash
root@lhrpg14:/# su - postgres
postgres@lhrpg14:~$ psql
psql (14.5 (Debian 14.5-1.pgdg110+1))
Type "help" for help.

postgres=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(3 rows)

root@lhrxxt:~# docker run -d --name mysql8030 -h mysql8030 -p 3418:3306 \
>   -v /etc/mysql/mysql8030/conf:/etc/mysql/conf.d \
>   -e MYSQL_ROOT_PASSWORD=lhr -e TZ=Asia/Shanghai \
>   mysql:8.0.30
f6e94a91fd69e26d0e9e7bd5b4ef11ecde0f4b8502299c537342141ea01bf80a
root@lhrxxt:~# 
root@lhrxxt:~# cat >  /etc/mysql/mysql8030/conf/my.cnf <<"EOF"
> [mysqld]
> default-time-zone = '+8:00'
> log_timestamps = SYSTEM
> skip-name-resolve
> log-bin
> server_id=80303418
> character_set_server=utf8mb4
> EOF
root@lhrxxt:~# docker restart mysql8030
mysql8030
root@lhrxxt:~# docker exec -it mysql8030 bash
bash-4.4# mysql      
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
bash-4.4# mysql -uroot -plhr
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.30 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.05 sec)

mysql> create database lhrdb;
Query OK, 1 row affected (0.04 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| lhrdb              |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

docker search mssql
docker pull mcr.microsoft.com/mssql/server:2017-latest
docker pull mcr.microsoft.com/mssql/server:2019-latest
docker pull mcr.microsoft.com/mssql/server:2022-latest

-- 2017
docker rm -f mssql2017
docker run -d --name mssql2017 --hostname  mssql2017 \
-p 1401:1433  \
-e "ACCEPT_EULA=Y" -e "SA_PASSWORD=lhr@zr123" \
-e "TZ=Asia/Shanghai" \
-e "MSSQL_PID=Enterprise" \
-e "MSSQL_COLLATION=Chinese_PRC_BIN" \
mcr.microsoft.com/mssql/server:2017-latest

docker exec -it mssql20171401 bash
/opt/mssql-tools/bin/sqlcmd  -S localhost -U sa -P "lhr@zr123"
sqlcmd -S 192.168.1.35,1401 -U SA -P "lhr@zr123"


-- 2019
docker rm -f mssql2019
docker run -d --name mssql2019  --hostname  mssql2019 \
-p 1402:1433  \
-e "ACCEPT_EULA=Y" -e "SA_PASSWORD=lhr@zr123" \
-e "TZ=Asia/Shanghai" \
-e "MSSQL_PID=Enterprise" \
-e "MSSQL_COLLATION=Chinese_PRC_BIN" \
mcr.microsoft.com/mssql/server:2019-latest

docker exec -it mssql20191402 bash
/opt/mssql-tools/bin/sqlcmd  -S localhost -U sa -P "lhr@zr123"
sqlcmd -S 192.168.1.35,1402 -U SA -P "lhr@zr123"


-- 2022
docker rm -f mssql2022
docker run -d --name mssql2022 --hostname  mssql2022 \
-p 1433:1433  \
-e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=lhr@zr123" \
-e "TZ=Asia/Shanghai" \
-e "MSSQL_PID=Enterprise" \
-e "MSSQL_COLLATION=Chinese_PRC_BIN" \
mcr.microsoft.com/mssql/server:2022-latest



SELECT Name from sys.Databases
go

SELECT @@VERSION
SELECT SERVERPROPERTY('Edition')
go


-- 修改sa密码
USE [master]
GO
ALTER LOGIN [sa] WITH CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'lhr'
GO


-- 远程登录
sqlcmd -S 192.168.8.8,1433 -U sa -P lhr
sqlcmd -S 192.168.8.8,1433 -d master -h -1 -U sa -P lhr -W -Q "set nocount on;SELECT name FROM master..sysdatabases"


-- linux客户端
curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo
yum install -y mssql-tools unixODBC-devel mssql-cli

echo "export PATH=/opt/mssql-tools/bin:$PATH" >> /root/.bashrc
source /root/.bashrc


-- 建库
create database lhrdb COLLATE Chinese_PRC_BIN;

docker run -itd -h redis-lhr --name redis-lhr -p 6379:6379 redis