MySQL Setup

Run Auvyra on MySQL.

MySQL is fully supported. It passes the same contract test suite as MongoDB, and every Auvyra feature works the same on every engine. Choose it if you already run MySQL.

With Docker Compose

Use the MySQL Compose file instead of the default one:

node scripts/generate-env.mjs
docker compose -f docker-compose.mysql.yml up -d --build

Use the same -f docker-compose.mysql.yml for every later docker compose command, such as logs and down.

MySQL is not published to the host. If you already have a .env, running the script again adds the passwords it lacks and changes nothing else.

Your own server

Create an empty database, then set these in .env:

DATABASE_PROVIDER=mysql
DATABASE_URL=mysql://user:password@localhost:3306/auvyra

Percent-encode any special characters in the password. The user needs permission to create tables and indexes in that database.

Check the connection

pnpm db:init

A success prints the server version. Tables are also created automatically when Auvyra starts.

Versions

Auvyra is tested against MySQL 9.