SQL Database

Create a MySQL and PostgresSQL instance and a database.

• mysql
• postgres
• adminer
• project location: sql-database
• postgres port: 5432
• mysql port: 3306
• adminer port: 9090 (open it in the web browser)

Run MySQL, PostgresSQL and Adminer:

cd sql-database
docker compose up -d
cd ..

Docker Compose

services:
  mysql:
    image: mysql:8
    environment:
      MYSQL_DATABASE: sandbox
      MYSQL_ROOT_PASSWORD: notasecret
    ports:
      - "3306:3306"
    restart: on-failure
    volumes:
      - mysql_data:/var/lib/mysql

  postgres:
    image: postgres:13
    environment:
      POSTGRES_DB: sandbox
      POSTGRES_PASSWORD: notasecret
    ports:
      - "5432:5432"
    restart: on-failure
    volumes:
      - postgres_data:/var/lib/postgresql/data

  adminer:
    image: adminer:4
    ports:
      - "9090:8080"
    restart: on-failure

volumes:
  mysql_data:
  postgres_data:

networks:
  default:
    external: true
    name: kafka-sandbox_network