React + Express + MySQL

React for the frontend, Express on Node.js for the API, and MySQL as the relational database.

This is the MERN stack variant for when data has clear relationships and a schema with referential integrity and SQL queries is preferable.

Services included

In addition to your application, the Stack brings up MySQL, an nginx that receives traffic on port 80, an automatic backups service, and the web file manager.

Project structure

text

.
├── .docker
│   └── docker-compose.yaml
├── backend
│   ├── src
│   │   ├── config.js
│   │   ├── database.js
│   │   ├── index.js
│   │   └── server.js
│   ├── test
│   │   └── sample.js
│   ├── Dockerfile
│   ├── LICENSE
│   ├── healthcheck.js
│   ├── package-lock.json
│   └── package.json
├── backup
│   └── backup-runner.sh
├── frontend
│   ├── public
│   │   ├── favicon.ico
│   │   ├── index.html
│   │   ├── logo192.png
│   │   ├── logo512.png
│   │   ├── manifest.json
│   │   └── robots.txt
│   ├── src
│   │   ├── App.css
│   │   ├── App.js
│   │   ├── App.test.js
│   │   ├── index.css
│   │   ├── index.js
│   │   ├── logo.svg
│   │   ├── serviceWorker.js
│   │   ├── setupProxy.js
│   │   └── setupTests.js
│   ├── Dockerfile
│   ├── package-lock.json
│   └── package.json
├── nginx
│   └── default.conf
├── .env.example
└── compose.yaml

Getting started

Install the Stack and bring it up:

bash

docker-deploy-stack --stack javascript/react-express-mysql
cd /root/stack/javascript/react-express-mysql
docker compose up -d

Then replace the example application with yours, from Git, via SFTP, or from the web file manager, following how-do-i-deploy-an-application-on-a-stack.md. Your code goes in the app/ folder.

Each time you update the code, apply the changes:

bash

docker compose up -d --build

Configuration

Editable values are in the Stack’s .env file:

Variable	Default	Purpose
`APP_ENV`	`development`	Application environment.
`DB_NAME`	`example`	Database name.
`DB_USER`	`root`	Database user.
`BACKUP_ENABLED`	`1`	Automatic backups: `1` enabled, `0` disabled.
`BACKUP_INTERVAL_SECONDS`	`86400`	How many seconds between backups.
`BACKUP_RETENTION_DAYS`	`7`	How many days backups are retained.
`MARIADB_VERSION`	`10.6.4-focal`	Version of the corresponding image.

After changing it, apply the changes with docker compose up -d.

Useful commands

bash

docker compose ps          # see running containers
docker compose logs -f     # view live logs
docker compose restart     # restart services
docker compose down        # stop and remove containers