DUXPLIMA Documentation

MySQL and MariaDB

Connecting to MySQL or MariaDB to share minions across servers.

storage {
  type     = "mysql"          # or "mariadb"
  host     = "db.example.net"
  port     = 0                # 0 is 3306
  database = "minecraft"
  username = "minions"
  password = "secret"
  table-prefix = "minions_"
  pool-size = 10
}
KeyMeaning
typemysql or mariadb. The MariaDB driver is downloaded on the first start
host, portThe database server; port 0 is 3306
databaseThe database, which must exist
username, passwordA user with rights to create tables in it
pool-sizeConnections the pool may open, 10 by default

The user needs CREATE, ALTER, INDEX, SELECT, INSERT, UPDATE and DELETE on the database. The tables are created at the first start. To bring an existing SQLite file across, see Moving off SQLite.

Related: Overview, PostgreSQL