Use MySQL

You can use NearBeach with MySQL. You can easily run MySQL within the same docker-compose file, or alternatively you can run it separately (external).

External Database

Note

We recommend using an external database like AWS RDS, etc. So you can scale and backup externally to the docker container.

Below is the sample code for using MySQL. Please note we do not have any of the docker database setup, as this is not required for externally run databases.

version: '3'

services:
    nearbeach:
        image: robotichead/nearbeach:latest
        container_name: nearbeach
        environment:
        ...
        - DB_DATABASE=<<Please fill>>
        - DB_USER=<<Please fill>>
        - DB_PASSWORD=<<Please fill>>
        - DB_HOST=<<please fill>>
        - DB_ENGINE=mysql
        - DB_PORT=<<please fill>>
        ...

You will need to fill out the following fields. These fields should match how you would log into that database.

• DB_DATABASE=<<Please fill>>

• DB_USER=<<Please fill>>

• DB_PASSWORD=<<Please fill>>

• DB_HOST=<<please fill>>

• DB_ENGINE=mysql

• DB_PORT=<<please fill>>

Docker Database

Note

This will run the database within the docker environment.

version: '3'

services:
   db:
       image: mysql:8.0
       container_name: nearbeach-db
       ports:
       - 3306:3306
       environment:
       - MYSQL_DATABASE=<<Please fill>>
       - MYSQL_USER=<<Please fill>>
       - MYSQL_PASSWORD=<<Please fill>>
       - MYSQL_ROOT_PASSWORD=<<Please fill>>
       volumes:
       - ./init:/docker-entrypoint-initdb.d
   nearbeach:
       image: robotichead/nearbeach:latest
       container_name: nearbeach
       environment:
...

The above code would be used in your docker-compose file.