Docker Composeで各種DBを作成する

• MySQL

(8.0.23)
https://blog1.mammb.com/entry/2020/10/13/222411

OS Ubuntu 22.04

sudo rm -rf ./mysqldata
sudo mkdir -p ./mysqldata
sudo chmod -R 777 ./mysqldata

vim docker-compose.yml

version: '3.8'
services:
  mysql01:
    image: mysql:8.0.23
    ports:
      - 3306:3306
    environment:
      - MYSQL_ROOT_PASSWORD=password
    volumes:
      - ./mysqldata:/var/lib/mysql

docker-compose up -d
docker-compose ps
docker-compose exec mysql01 bash
mysql -u root -p

docker-compose down -v

• Oracle

(19c)
https://blog1.mammb.com/entry/2020/10/13/222411

OS Ubuntu 22.04

-- 1. イメージ作成

cd

git clone https://github.com/oracle/docker-images.git

cd docker-images/OracleDatabase/SingleInstance/dockerfiles

ダウンロードファイル名：LINUX.X64_193000_db_home.zip

ダウンロードファイルは、解凍せずに以下のディレクトリ配下へ格納

~/docker-images/OracleDatabase/SingleInstance/dockerfiles/19.3.0

./buildContainerImage.sh -e -v 19.3.0

docker image ls

-- 2. コンテナ作成

sudo rm -rf ./oradata
sudo mkdir -p ./oradata
sudo chmod -R 777 ./oradata

vim docker-compose.yml

version: '3.8'
services:
  oracle01:
    image: oracle/database:19.3.0-ee
    ports:
      - 1521:1521
      - 5500:5500
    environment:
      - ORACLE_SID=orcl
      - ORACLE_PDB=pdb1
      - ORACLE_PWD=oracle
      - INIT_SGA_SIZE=1000
      - INIT_PGA_SIZE=200
      - ORACLE_EDITION=enterprise
      - ORACLE_CHARACTERSET=AL32UTF8
      - ENABLE_ARCHIVELOG=false
    volumes:
      - ./oradata:/opt/oracle/oradata

docker-compose up -d
docker-compose ps

docker-compose logs oracle01 -f
※コンテナができるまでかなり時間がかかる

docker-compose exec oracle01 bash
sqlplus / as sysdba

docker-compose down -v

• PostgreSQL

(14)
https://blog1.mammb.com/entry/2020/10/13/222411

OS Ubuntu 22.04

sudo rm -rf ./postgresdata
sudo mkdir -p ./postgresdata
sudo chmod -R 777 ./postgresdata

vim docker-compose.yml

version: '3.8'
services:
  postgres01:
    image: postgres:14
    ports:
      - 5432:5432
    environment:
      - POSTGRES_PASSWORD=postgres
    volumes:
      - ./postgresdata:/var/lib/postgresql/data

docker-compose up -d
docker-compose ps
docker-compose exec postgres01 bash
su - postgres
psql

docker-compose down -v

• SQL Server

(2019)
https://blog1.mammb.com/entry/2020/10/13/222411

sudo rm -rf ./mssqldata
sudo mkdir -p ./mssqldata
sudo chmod -R 777 ./mssqldata

vim docker-compose.yml

version: '3.8'
services:
  sqlserver01:
    image: mcr.microsoft.com/mssql/server:2019-latest
    ports:
      - 1433:1433
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=password
    volumes:
      - ./mssqldata:/var/opt/mssql

docker-compose up -d
docker-compose ps
docker-compose exec sqlserver01 bash

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA

docker-compose down -v