Database

SQLite and MySQL setup.

RankedSMPX stores ranks, history and extra inventories in SQLite by default. MySQL is optional.

database:
  type: sqlite          # sqlite or mysql
  sqlite-file: rankedsmp.db
  mysql:
    host: localhost
    port: 3306
    database: rankedsmp
    username: root
    password: password
    pool:
      maximum-pool-size: 10
      minimum-idle: 2
      connection-timeout: 30000
      idle-timeout: 600000
      max-lifetime: 1800000

Pool times are in milliseconds. database.type needs a restart, not a reload.

Use MySQL

Create an empty database and a user with access to it.
Fill in the mysql block and set type: mysql.
Restart the server.

Use /rankexport before switching, then /rankimport <file> on the new database to carry ranks over.

Never share config.yml with a real password in it.