Adding support guide for mysql with docker

[nakulnagariy]

This could be just basics to many of you but it was a lot of exploration for me so just wanted to share my work.

If you were wanted to go with MySQL instead of postgres DB, changes can be done after you follow the complete guide given here.

Once you have done all the steps you should have a running app.

If you make it till here, it just requires a couple of changes to switch from postgres to MySql.

change the docker-compose.yml to the following:

just make sure, you have the the available port for sql if not change it to something else eg. 3333

.env

DATABASE_TYPE=mysql
DATABASE_HOST="localhost"
DATABASE_PORT=3333
DATABASE_USERNAME=root
DATABASE_PASSWORD="mysqlpass"
DATABASE_NAME=legalyatra_services

docker-compose.yml

services:
  mysql:
    image: mysql
    ports:
      - ${DATABASE_PORT}:3306
    volumes:
      - ~/db/mysql:/var/lib/mysql
    environment:
      MYSQL_USER: ${DATABASE_USERNAME}
      MYSQL_PASSWORD: ${DATABASE_PASSWORD}
      MYSQL_ROOT_PASSWORD: ${DATABASE_PASSWORD}
      MYSQL_DATABASE: ${DATABASE_NAME}

  maildev:
    build:
      context: .
      dockerfile: maildev.Dockerfile
    ports:
      - ${MAIL_CLIENT_PORT}:1080
      - ${MAIL_PORT}:1025

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080

  # Uncomment to use redis
  # redis:
  #   image: redis:7-alpine
  #   ports:
  #     - 6379:6379

  api:
    build:
      context: .
      dockerfile: Dockerfile
    ports:
      - ${APP_PORT}:${APP_PORT}

After you done with the above setup try to run the docker with the following script:

docker compose up -d mysql adminer maildev

your all three services should be running like below.

Once your services are up and running, you almost half way through already.

Now install Mysql client.

npm i mysql2 --save

Now delete the already generated migration file. and generate a new one with below script.

npm run migration:generate -- src/database/migrations/newMigration --pretty=true

Run migrations

npm run migration:run

Run seeds

npm run seed:run:relational

Run app in dev mode

npm run start:dev

Open http://localhost:3000

To setup Adminer

Open the running port in your browser.
Open http://localhost:8080

Running App SS:

Now you're all set for your project.

[Shchepotin]

@nakulnagariy thank you for the guide!