DrawSplatTM MySQL Setup

Wizard Teacher Admin Open Board

Admin Access

Enter the DrawSplatTM admin password to use the MySQL setup wizard. No password? Click Preview as Viewer for a read-only tour — no real data is loaded.

Request Access

Preview mode — you're looking at the MySQL setup wizard in read-only form. No backend data is loaded. Click Lock Admin to exit and sign in with the real admin password.

MySQL Backend Setup Wizard

Choose Railway, DigitalOcean, or another MySQL host. Connect the public saving service here; boards stay private to each signed-in account. Save and reopen boards, including added audio and video notes, through an HTTPS API. Google classroom rooms, templates, moderation, and turn-ins remain separate features.

1

Install Backend

Deploy the saving service in server/mysql-backend on a server that can reach MySQL.

2

Create Database

Create an empty MySQL database and give its credentials to the saving service. Tables are created automatically at startup; existing databases receive tracked migrations.

3

Connect DrawSplatTM

Test the public API address, enable online saving, then sign in on the whiteboard. Keep database credentials on the server.

Public API Endpoint

This is the URL DrawSplatTM can call. It should point to the backend API, not directly to MySQL.

Choose your host

Railway: Deploy server/mysql-backend from GitHub and add a MySQL service in the same project. Reference its MYSQL_URL in the API service.

DigitalOcean: Run the bundled Docker Compose setup on a Droplet, or deploy the API on App Platform and connect a managed database.

Existing MySQL: Run this same API wherever Node.js or Docker is available. Set a database URL or individual host, port, database, username, and password settings.

Step-by-step hosting guide

Create your saving account

For teachers setting up their own saving account. Student accounts should be provisioned by the school. This password is separate from the Teacher Admin password.

Then open the whiteboard and choose File → Save online. Use File → Online account to sign out on a shared device.

Server-Side Database Settings

Use these fields to generate a server-only .env template. The password is not saved in the browser.

Generated .env Template

Put this on the backend server as server/mysql-backend/.env. Keep it out of Git and away from students.

Backend Endpoint Contract

  1. GET /health checks the database and supported features.
  2. POST /auth/login signs in to an account.
  3. GET /boards lists only your saved boards.
  4. GET /boards/:key opens your board.
  5. PUT /boards/:key saves your board with conflict detection.
Read Backend Guide View Schema